Hi there,
when I do test mails ... working fine.
But When I schedule jobs does not seems
to be working ... there are no email blockouts.
Any hints or ideas?
Best regards
Henrik
Henrik Bachmannmailto:[EMAIL PROTECTED]
B.I.M.-Consulting Magdeburg
Title: RE: When to go for ORACLE NAMES Server
-- DATATYPE.sql
--
-- To check datatype consistency between two environments
--
--
SELECT
table_name,
column_name,
data_type,
data_length,
data_precision,
data_scale,
nullable
FROM
Hi
I think this parameter is available from 8.1.6 where us I am in 8.1.5..Any
idea how to control it in 8.1.5?
Raj
-Original Message-
Sent: 12 May 2001 00:18
To: Multiple recipients of list ORACLE-L
Raj,
It's new archiving tracing introduced in 8i. If
you're on 8.1.6 or later you
Hi Everybody,
I am using oracle 8.1.6 db.
I want to create a trigger which fires for every new object created
in a particular schema. Basically, i want to grant privileges for
this newly created object to Roles, Users dynamically as and when
the new object created.
When i tried , the trigger got
Arul,
Ak Hi Everybody,
Ak I am using oracle 8.1.6 db.
Ak I want to create a trigger which fires for every new object created in a
Ak particular schema. Basically, i want to grant privileges for this newly
Ak created object to Roles, Users
Rafiq
But I want my db to be archived..
Raj
-Original Message-
Sent: 11 May 2001 21:46
To: Multiple recipients of list ORACLE-L
Your archiving is TRUE instead of false
Check for log_archive_start FALSE
change this parameter to false and rebounce your database.
Regards
Unless things have changed, 2 thru 20999 are user specified error numbers, not
generated by Oracle.
[EMAIL PROTECTED] 05/11/01 01:20PM
Has anyone any idea what this means?
It is coming up when trying to use a procedure in a PL/SQL package to
display a web page. With some negative
You can run the catnsnmp.sql script from rdbms/admin to get rid of it...
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de
Raj,
Nope, none that I know of. Yet another reason to
upgrade ;)
-- Anita
--- Raj Gopalan [EMAIL PROTECTED]
wrote:
Hi
I think this parameter is available from 8.1.6 where
us I am in 8.1.5..Any
idea how to control it in 8.1.5?
Raj
-Original Message-
Sent: 12 May 2001 00:18
If the production environment is already available, you could use
DBMS_STATS.EXPORT_TABLE_STATS on the production table
and import those stats into your development instance.
Regards,
Chris Gait
On 18 Apr 2001, at 11:00, Murali Vallath wrote:
Thanks for the feedback, I am coming from the
How can I modify a Unix file in an other editor not using vi, for instance I would
like to use a Windows based editor?
Roland Sköldblom
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX:
I beleave intelligent agent requires tnsnames.ora also.
Alex Hillman
-Original Message-
Sent: Monday, May 14, 2001 1:47 AM
To: Multiple recipients of list ORACLE-L
On Sunday 13 May 2001 18:51, Mohan, Ross wrote:
Sounds like client-based Forms would be OK with ONS, then.
Or, izzit?
It doesn't seem to have DBA here (mostly 8.1.6 databases)... perhaps
you were generalizing? It does have RESOURCE tho, which is plenty bad
since it pulls in UNLIMITED TABLESPACE behind the scenes.
-Original Message-
From: lvordos [mailto:[EMAIL PROTECTED]]
Sent: Sunday, May 13,
Hi Gurus,
I am facing some problem while fetching data from
oracle.
I have to fetch all info like
column_name,data_type,data_length,Nullable and primary
key for particular table.
For that i had prepared 2 quiries like:
select A.column_name,A.data_type,
2 decode(A.data_type,'NUMBER',
3
Rajesh,
You can't run interactive commands using rsh. You should be able to put
all your commands into a script(s) and execute those. Otherwise try
rlogin.
Regards,
David A. Barbour
Rajesh Dayal wrote:
Hi All,
Env. is TRU64 Unix and Oracle 7.3.4
This is a standby server
LOL!
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-Original Message-
From: Gary Boyd [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, May 10, 2001 10:16 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: PostGres WAS: RE:
Title: RE: Imedia query optimization
Ranganath,
I have found that intermedia queries really bite the biggie without a hint. Read up on the hints /*+ FIRST_ROWS DOMAIN_INDEX_NO_SORT */
There is a chapter in the doco on tuning intermedia queries that discusses the reasons why these hints
I believe as of 8.1.6, Oracle removed DBA from DBSNMP (and MDSYS and CTXSYS
and ORDSYS and..)
From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: DBSNMP user?
Date: Mon, 14 May 2001 05:55:42 -0800
It doesn't
Diana,
Can I build the initial local primary key index using the storage and
tablespace clause to place the index in the correct index tablespace
to begin with. This index is multiple gigs and my database is tight
on space right now. I'm not sure that I have enough room to put
the index in
Nope! Most of the TNSNAMES.ORA files on my servers are empty, and IA still
works (at least as much as can be expected).
Perhaps LISTENER.ORA is what you were thinking of?
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International,
Title: RE: PostGres WAS: RE: Oracle 9i Articles - self tuning, launch
OMG is that FUNNY
I just woke everyone with my 'quiet' laugh !
-Original Message-
From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 14, 2001 11:51 AM
To: Multiple recipients of list
Funny, the threads on my MS Outlook at home never show up as threads... I
end up with little entries all over the place. Might as well rely on
e-mail.
The volume on the newsgroup is much higher, but perhaps as a result there is
a LOT of junk going through there, a lot of spam. Some of it is
Is OracleOraHome81Agent the OEM agent?
-Original Message-
Sent: Monday, May 14, 2001 8:05 AM
To: Multiple recipients of list ORACLE-L
You can run the catnsnmp.sql script from rdbms/admin to get rid of it...
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin
Allowing people to create objects on the fly sounds
like bad news to me...
Anyway, one possible workaround would be to have your
trigger schedule a dbms_job to perform the grants.
Then your grants would take place shortly after the
ddl had been performed...
hth
connor
--- Arul kumar [EMAIL
Good morning all,
Scenario:
UserA/sid=testA
UserB/sid=testB
Problem:
How can I create the environment that allows UserA to export his schema, and
UserB can import fromuser=UserA touser=UserB. I do NOT want to grant the
roles imp_full_database/exp_full_database to these users, because this
Oracle 8.1.5 and 7.3.4.5
No Alter System switch logfile performed.
NT 4.0
I am testing some recovery plans, and I tried to restore a cold backup and
roll the database forward. However, when I went to apply the 1st archive
log since the cold backup it complained about a size of the transaction
Hello,
while building my portlet i came across this strengh expression:
wwsec_sso_enabler_private
What is it?
Where can I find documentation covering this topic
Thank you in advance
Pawel
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Hi, Babu,
Please, check if you have the following steps done:
1. NetBackup SERVER side: create permission files to allow alternate client
restore:
File NETBACKUP PATH/db/altnames/restore client name should contain
primary backup client name
2. NetBackup CLIENT side:
a/ set UNIX
Hi, everyone:
I had problem installing Oracle 8.1.7.0 on my Petium 4 machine running Windows
Me.
I changed the scripts to use -nojit option, however, when I was installing, only
Oracle Cllients was installed. Any idea?
TIA
Matt
--
Please see the official ORACLE-L FAQ:
Title: RE: Intermedia
I am
curious to know if the NOLOGGING option would work in an update or insert
statement, I mean by using NOLOGGING in an update statement can writes to the
redo log be turned off fora particular update or insert operation for that
matter. Specially for huge updates
Title: svrmgrl return code
on unix (hpux 11) can svrmgrl return any value other than
a zero (0)?
even a
exit 1
returns a 0 to the calling script
R. Matt Adams - GE Appliances - [EMAIL PROTECTED]
Meddle not in the affairs of troff,
for it is subtle and quick to anger.
I just tried c.d.o.* (example news:comp.databases.oracle.server )
with Netscape 4.75, and threading works fine as far as I can tell.
Based on what is stored of those newsgroups here (only goes back
about 1 or 2 weeks), I didn't see any huge amount of spam.
regards,
ep
On 14 May 2001, at 7:56,
Cherie,
Hm, good question. I think I remember (unfortunately, this was at my
previous job, so I don't have the scripts) that in order to specify LOCAL,
you lost control of the storage parameters -- they automatically default to
the same as the table. But it's certainly worth a try.
I created
Hi, Arul,
Do you have index on this table? If yes, can you drop this index and try how
it works? You may hit a bug.
HTH
Vadim
-Original Message-
Sent: Monday, May 14, 2001 6:40 AM
To: Multiple recipients of list ORACLE-L
Hi Ora DBAs,
I am working on Oracle 8.1.6 version on SUN SOLARIS
Ok, I'll jump in here 'cause I may be able to simplify the issue.
Starting with Oracle 8, you can create a Primary Key that uses an existing
index. This makes the administration stuff easier. You can create your own
locally partitioned unique index (using regular CREATE INDEX syntax).
Once the
Please see bug #1507768 on MetaLink. If you look towards the bottom at 3/23/2001 you
will see an update that describes replacing some DLLs with ones from a newer version
of JRE that performs the CPUID on a P4 correctly. I had this same issue at home, but
on Win2000, and the 3/23 note worked
1) What is the easiest way to do these local installations? With the old
16-bit version of the Oracle
client, you could do a network install, then have the workstations
reference that installation by changing
ini files. I don't think that the 32-bit version of the client supports
network
There was similar Q from Vikas@innoventry a few days back
You cannot turn off logging.
Reason: Search through your mails dated 3 days back.
Rajaram.
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Monday, May 14, 2001 12:36 PM
To: Multiple recipients
Hi,
starting here:
http://www.google.com/search?q=hayden+oracle+white+paperhl=enlr=safe=offstart=10sa=N
Look at page #2 of results (there are a *LOT* of hayden
worthington hits about Oracle performance white papers. Most of the
links are the same, or similar to yours, and they are DEAD
Matt,
AFAIK, there aren't any products certified with
Windows ME (it isn't even listed as a platform on the
certification page on metalink). Isn't that the
successor to Windows98, though? In which case all it
would support would be client tools anyway.
HTH,
-- Anita
--- [EMAIL PROTECTED]
ssh is your friend.
oli
[EMAIL PROTECTED] wrote
Hi All,
Env. is TRU64 Unix and Oracle 7.3.4
This is a standby server configuration. I want to run
certain scripts(on secondary server), based on some incident
on primary server. And on top of that, every thing has to be
fully
Matt,
Control backslash gives me 131.
Is that enough ;)
- Kirti Deshpande
Verizon Information Services
http://www.superpages.com
-Original Message-
From: Adams, Matthew (GEA, 088130) [SMTP:[EMAIL PROTECTED]]
Sent: Monday, May 14, 2001 11:36 AM
To: Multiple recipients of
I really did not understand what you did. A little bit more details please.
My understanding of the question was - how to install Oracle client on
multiple Windows machines.
Alex Hillman
-Original Message-
Sent: Monday, May 14, 2001 1:51 PM
To: Multiple recipients of list ORACLE-L
1)
Kevin,
Thanks for your comments.
I already have the existing (non-partitioned) index out there.
Is there any way to convert this to a locally partitioned
index? I see ways to split existing partitioned indexes
into additional partitions but I don't see any documentation
on changing a regular
Matt,
What version of Oracle 8.1.7 are you trying to install? Actually, for which
platform is your CD? The only version that you can install on ME is
Personal Oracle, not Enterprise Edition or Standard Edition.
Ed Haskins
Oracle DBA
Verizon Wireless
-Original Message-
Sent: Monday,
Thanks Rajaram !
Here's the bottom line :
NOLOGGING doesn't apply to conventional DML at all ! It applies only to
CREATE/ALTER objects and Direct Load Inserts such as using SqlLoader or
INSERT as SELECT
-Original Message-
Sent: Monday, May 14, 2001 10:56 AM
To: Multiple recipients
thanks
-Original Message-
Sent: Monday, May 14, 2001 2:39 PM
To: Multiple recipients of list ORACLE-L
Thanks Rajaram !
Here's the bottom line :
NOLOGGING doesn't apply to conventional DML at all ! It applies only to
CREATE/ALTER objects and Direct Load Inserts such as using
Hi,
It's not used by many people. But, If you have many clients, you can install client
softwares on application server or different home on database server. do followings:
- map a server in which client softwares will be installed, such as 'L:'
- install client softwares to 'L:'
- export
Eric,
thanks for your help! I've found what I was looking for.
Regards,
Ed
Hi,
starting here:
http://www.google.com/search?q=hayden+oracle+white+paperhl=enlr=safe=offstart=10sa=N
Look at page #2 of results (there are a *LOT* of hayden
worthington hits about Oracle performance
Does anyone know what the SYS.IDL_UB1$ table is?
It suddenly grew to app. 100Meg in my Development database. I tried
searching on it on Ixora on Friday but as soon as I did my computer crashed.
Now that I'm back up I decided it might be safer to post here :).
Thanks in advance,
Jay Miller
--
My eldest graduated from college Saturday. A double major in Spanish and German, cum
laude, and a Fullbright scholar. I'm proud of the boy!;-)
Follow the link below for a nice picture and a little blurb.
http://www.naz.edu/academics/fulbright/scholars.cfm
--
Bill Thater
I had this problem while installing on my Pentium 4 machine. I raised a tar
for this and as per their instructions, I could install 817 on Pentium. I
quoting the contents of the tar for your reference. If you have any
problems, please contact me directly.
Oracle Tar instructions:
Congratulations. Apparently you did a great job.
Michael Armstead
Application Database Administrator, OCP-Certified
US Pharmaceuticals IT
Glaxo SmithKline
-Original Message-
From: Thater, William [SMTP:[EMAIL PROTECTED]]
Sent: Monday, May 14, 2001 4:20 PM
To: Multiple
Jay,
I think these tables deal with p-code chunks for pl/sql objects ... do you
have lots of server side code?
It is possible that you can truncate these tables, but then you'll have to
recompile ALL (including SYS/SYSTEM) owned packages and user packages. Not
recommended without help from OWS
Conratulations, Dad! You deserve to have a bit of a brag. And Well Done
to Edward too.
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, May 14, 2001 4:20 PM
My eldest graduated from college Saturday. A double major in Spanish and
I believe that table holds the PL/SQL source code.
[EMAIL PROTECTED] 05/14/01 03:30PM
Does anyone know what the SYS.IDL_UB1$ table is?
It suddenly grew to app. 100Meg in my Development database. I tried
searching on it on Ixora on Friday but as soon as I did my computer crashed.
Now that I'm
Lisa,
I just went through Intermedia install on HPUX 11 and Ora 8.1.6 (32 bit)
with no apparent problems. Been able to create Intermedia indexes and all is
working well. Could you share what problems you've encountered?
Thanks,
Gary Weber
-Original Message-
Sent: Monday, May 14, 2001
Congrats! now if you can post a cigar for each of us. ;o)
--- Thater, William [EMAIL PROTECTED] wrote:
My eldest graduated from college Saturday. A double major in Spanish
and German, cum laude, and a Fullbright scholar. I'm proud of the
boy!;-)
Follow the link below for a nice picture
Wonderful. But now I really feel old!
-Original Message-
Sent: Monday, May 14, 2001 1:51 PM
To: Multiple recipients of list ORACLE-L
Congratulations. Apparently you did a great job.
Michael Armstead
Application Database Administrator, OCP-Certified
US Pharmaceuticals IT
Glaxo
After all of the MicroSoft bashing, this should be fun!!
An unemployed man goes to apply for a job with Microsoft as a janitor.
The manager there arranges for him to take an
aptitude test (Section:Floors, sweeping and cleaning).
After the test, the manager says, You will be
Congrats! I hope my boys' resume looks as impressive someday. (I'll give them a few
years yet as they're just 5 and 9 now).
Stephen Andert
[EMAIL PROTECTED] 05/14/01 01:20PM
My eldest graduated from college Saturday. A double major in Spanish and German, cum
laude, and a Fullbright
Title: RE: Tomato Story
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
An unemployed man goes to apply for a job with Microsoft as
a janitor.
The manager there arranges for him to take an
aptitude test (Section:Floors, sweeping and cleaning).
...
Dick,
That's the best parable I've read in longer than I can remember...
grin
Thanks,
Scott Shafer
San Antonio, TX
210-581-6217
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Monday, May 14, 2001 4:06 PM
To: Multiple recipients of list ORACLE-L
Miller, Jay wrote:
Does anyone know what the SYS.IDL_UB1$ table is?
It suddenly grew to app. 100Meg in my Development database.
Someone probably loaded (or generated) a ton of PL/SQL into the database.
Although I've never attempted a truncate on these tables, some Metalink sources
claim
ROTFL!! This is a good one, Dick!
John
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 14, 2001 2:06 PM
To: Multiple recipients of list ORACLE-L
Subject: OT:Tomato Story
After all of the MicroSoft bashing, this should be fun!!
--
Please see the
I always wondered what DIANA stood for... :)
Diana Duncan
TITAN Technology Partners
One Copley Parkway, Ste 540
Morrisville, NC 27560
VM: 919.466.7337 x 316
F: 919.466.7427
E: [EMAIL PROTECTED]
Hi Jay,
Does anyone know what the SYS.IDL_UB1$ table is?
It suddenly grew to app. 100Meg in my Development database. I tried
searching on it on Ixora on Friday but as soon as I did my
computer crashed.
Now that I'm back up I decided it might be safer to post here :).
Did you recently install
Congratulations from me too, Bill.
-Original Message-
Sent: Monday, May 14, 2001 5:06 PM
To: Multiple recipients of list ORACLE-L
Congratulation on a job well done in raising your family and instilling the
proper values. It's not a brag it's a well deserved BOAST.
ROR mª¿ªm
[EMAIL
Oracle : 8.0.5
Platform : Sun
SQL statement:
select distinct(spid) spid, name, commonname from (
select distinct queryspid spid from results union
select distinct subjspid spid from results
) a, species
where a.spid=species.id ;
Table Species only has 33 records, while table
If I move table to different tablespace and then change tablespace for this
table in People tools table using application designer - will I have any
additional problems during upgrade?. If yes - what are they?
Alex Hillman
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Title: RE: cdump, bdump, udump
I used to be of the same school of thought as you. But on Solaris 2.7 with Oracle v8.1.7 I have seen the various processes hang on to the old log for days if I mv alertSID.log alertSID.log.old ; touch alertSID.log
7113:oracle@e6500a ls -Fla
Title: RE: Can I partition my primary key constraint index?
ahhh, mostly right. I found in v8.1.6 that if I use a non-unique index to enforce a unique/primary key constraint that the index does not drop when you drop the constraint.
-Original Message-
From: Vadim Gorbounov
Manoj,
Nothing helps your sql skills like traversing the data dictionary,
put on your hip waders get out your TUSC posters, a magnifying glass, a
bottle of scotch and dive in. Here is one way, by no means the best or the
only.
SELECT A.column_name, A.data_type,
When using sqlplus to do the select you are most probably using the privileges
that have been assigned to you in a role. Privileges assigned to
a user through a role are not used (or applied) inside PL/SQL blocks (procedures/functions).
You need to have the appropriate privilege explicitly
hi gurus,
I am able to select from every hting from v$session at command line.
but when i write in procedure it fails why.
SQL select osuser from v$session where username = 'IMAGE_INDEX' and rownum
= 1;
OSUSER
--
MLOBO
this is ok...
CREATE OR
Hi Narender,
You will need to grant explicit select privilege to the user id for
accessing the underlying view sys.v_$session to be able to do this in a
PL/SQL procedure. The id may have access to the v$session via a role. And
that would not work in a PL/SQL procedure.
HTH..
Regards,
- Kirti
Any scripts (sql or pl/sql) out there to compute various statistical things
in Oracle?
Would depend on just what you are looking for. A quick look at
Oracle's SQL functions showed avg, st. deviation, and variance
although no median but that should be easier to write than some of the
All,
We have an Informix database and looking to setup a sql interface to an Oracle
database.
Both database servers are Sun E-class servers running O/S 2.6.
All assistance is greatly appreciated.
Thanks in advance.
Roy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
hi Gurus,
I would like know wheather oracle supports oracle 8.1.7. on sun solaris 8
(64bit) ? Where do i find more info.I searched in product life cycle in
metalink.. i could not find much info..
can some body tell or where to look.
what are the pros and cons ? does any body had problems or
hi gurus,
I am able to select from every hting from v$session at command line.
but when i write in procedure it fails why.
SQL select osuser from v$session where username = 'IMAGE_INDEX' and rownum
= 1;
OSUSER
--
MLOBO
this is ok...
CREATE OR REPLACE PROCEDURE
hi pat...
thanks for info.
I granted explicit previleges to user,
narender
-Original Message-
Sent: Tuesday, May 15, 2001 2:50 PM
To: Multiple recipients of list ORACLE-L
hi gurus,
I am able to select from every hting from v$session at command line.
but when i write in
Hello all,
I was scanning through several Oracle 8.1.7 databases that I inherited
recently, and noticed that there was a user ID by the name of RAO in
each of the databases, with DBA privileges.
For some reason, I recall seeing somewhere that this user is created
when installing a particular
Hi Roland,
(DISCLAIMER - I have no interest in Pacemaker software, other than that Paul
has a good product)
I use an editor called CRiSP extensively - it is a GUI-based version of a
character based editor called Brief (from Underware), that got bought by
Borland (remember them ...).
It runs
On Monday 14 May 2001 19:55, Pat Hildebrand wrote:
Would depend on just what you are looking for. A quick look at
Oracle's SQL functions showed avg, st. deviation, and variance
although no median but that should be easier to write than some of the
others.
Pat
Ha!
Here's
84 matches
Mail list logo