date:20030731

I have a question re. these conversions...

If an Oracle database has 120 tablespaces, how does that translate in MSSQL
speak?

(One of the tablespaces is USERS, home of dozens of schemas; the others are
either RB, SYSTEM, TEMP or application tablespaces)

How many separate schemas-tablespaces can MSSQL hold per server?

Patrice.

-Original Message-
Sent: Thursday, July 31, 2003 7:34 AM
To: Multiple recipients of list ORACLE-L


I know Microsoft is offering a new course called 'Microsoft SQL Server
2000 for Experienced Database Professionals'.  It is aimed at DBAs with
experience with Oracle, DB2, Sybase etc. who want to know more about SQL
Server.

You can read more about this course at
http://www.microsoft.com/traincert/syllabi/2723afinal.asp.

Gudmundur

 Hello,
 
 There is alot of talk about multi-skilling/reskilling going 
 on here at my company. We use Oracle and MSSQL dbs. 
 I have been wondering if anyone is aware of a resource that 
 shows the oracle programming technique and what the 
 corresponding MSSQL programming technique is. ie
 Oracle defines variable   : MSSQL defines variable
 Oracle cursor looks like this   : MSSQL cursor looks like this.
 Oracle uses rollbacks: MSSQL uses MSSQL rollbacks
 etc
 Hope you all understand what I mean.
 
 TIA
 Denham Eva
 Oracle DBA
 Linux like TeePee... No Windows, No Gates and Apache inside!
 
 
 __
 ___
 This e-mail message has been scanned for Viruses and Content 
 and cleared 
 by MailMarshal
 
 For more information please visit www.marshalsoftware.com 
 __
 ___
 
 ##
 ###
 Note:
 This message is for the named person's use only.  It may 
 contain confidential, proprietary or legally privileged 
 information.  No confidentiality or privilege is waived or 
 lost by any mistransmission.  If you receive this message in 
 error, please immediately delete it and all copies of it from 
 your system, destroy any hard copies of it and notify the 
 sender.  You must not, directly or indirectly, use, disclose, 
 distribute, print, or copy any part of this message if you 
 are not the intended recipient. TFMC and any of its 
 subsidiaries each reserve the right to monitor all e-mail 
 communications through its networks.
 
 Any views expressed in this message are those of the 
 individual sender, except where the message states otherwise 
 and the sender is authorized to state them to be the views of 
 any such entity.
 
 Thank You.
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Denham Eva
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 
 and in the message BODY, include a line containing: UNSUB 
 ORACLE-L (or the name of mailing list you want to be removed 
 from).  You may also send the HELP command for other 
 information (like subscribing).
 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gudmundur Bjarni Josepsson
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Boivin, Patrice J
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: 9i-OCP Question

We use a SAN.

Where does that leave me?

: )

Patrice.

-Original Message-
Sent: Wednesday, July 30, 2003 7:10 PM
To: Multiple recipients of list ORACLE-L


I'm constantly amazed (and relieved!) that there's disagreement on the
most fundamental principles.

First, I found myself nodding at Roy's first post.  On some databases,
I have three log groups, with two members each.  Each set of members
has its own disk.  I'll concede the argument that the instance goes
down right away if one of the drives fails, but I _still_ have a full
set of logs on the other drive, and that's a good thing, right?

Second, if I have three groups of two members each and follow what
seems to be the consensus opinion, I have three drives, each holding
two members, one from each group.  In this case, aren't the two members
on the same drive identical?  If I lose that drive, I lose that entire
log group, and therefore no longer have a full set of logs--so what's
the point of having two copies?  I also lose the instance immediately
if that group happens to be the current group at the time of disk
failure.

Third, while I agree that every member of every group should ideally
have its own disk, does ANYONE actually configure their DB this way?  I
had a hard enough time dedicating one or two disks to redo logs; who
can dedicate eight, especially given drive sizes of 72+ GB and (single)
log file sizes of, what, 100 MB?




--- Pardee, Roy E [EMAIL PROTECTED] wrote:
 Yep, that's right--I had it wrong.  You need to have at least one
 member from each group in order to do a full recovery.  I see now
 from my trusty dba fundamentals I class text that each member of a
 group is identical (or is supposed to be).
 
 So I guess I'll go back to being confused about why the answer to the
 question below is 2.  I guess 2 is the minimum required to survive a
 single disk failure?
 
 Cheers,
 
 -Roy
 
 Roy Pardee
 Programmer/Analyst/DBA
 SWFPAC Lockheed Martin IT
 Extension 8487


__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Boivin, Patrice J
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Oracle to MSSQL conversion?

2003-07-31 Thread Anjo Kolk



Hmm, must be a one hour course then ;-)

On Thursday 31 July 2003 12:34, you wrote:
 I know Microsoft is offering a new course called 'Microsoft SQL Server
 2000 for Experienced Database Professionals'.  It is aimed at DBAs with
 experience with Oracle, DB2, Sybase etc. who want to know more about SQL
 Server.

 You can read more about this course at
 http://www.microsoft.com/traincert/syllabi/2723afinal.asp.

 Gudmundur

  Hello,
 
  There is alot of talk about multi-skilling/reskilling going
  on here at my company. We use Oracle and MSSQL dbs.
  I have been wondering if anyone is aware of a resource that
  shows the oracle programming technique and what the
  corresponding MSSQL programming technique is. ie
  Oracle defines variable   : MSSQL defines variable
  Oracle cursor looks like this   : MSSQL cursor looks like this.
  Oracle uses rollbacks: MSSQL uses MSSQL rollbacks
  etc
  Hope you all understand what I mean.
 
  TIA
  Denham Eva
  Oracle DBA
  Linux like TeePee... No Windows, No Gates and Apache inside!
 
 
  __
  ___
  This e-mail message has been scanned for Viruses and Content
  and cleared
  by MailMarshal
 
  For more information please visit www.marshalsoftware.com
  __
  ___
 
  ##
  ###
  Note:
  This message is for the named person's use only.  It may
  contain confidential, proprietary or legally privileged
  information.  No confidentiality or privilege is waived or
  lost by any mistransmission.  If you receive this message in
  error, please immediately delete it and all copies of it from
  your system, destroy any hard copies of it and notify the
  sender.  You must not, directly or indirectly, use, disclose,
  distribute, print, or copy any part of this message if you
  are not the intended recipient. TFMC and any of its
  subsidiaries each reserve the right to monitor all e-mail
  communications through its networks.
 
  Any views expressed in this message are those of the
  individual sender, except where the message states otherwise
  and the sender is authorized to state them to be the views of
  any such entity.
 
  Thank You.
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.net
  --
  Author: Denham Eva
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- 858-538-5051 http://www.fatcity.com
  San Diego, California-- Mailing list and web hosting services
  -
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
  and in the message BODY, include a line containing: UNSUB
  ORACLE-L (or the name of mailing list you want to be removed
  from).  You may also send the HELP command for other
  information (like subscribing).

-- 

Anjo Kolk
http://www.oraperf.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Anjo Kolk
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: buffer busy waits and v$filestat

2003-07-31 Thread Anjo Kolk


Not completely true.

If the dbwr is going to write a buffer, it will set a bit that the buffer is 
being written. In  the good old days, this meant that the buffer could be 
changed until the block was written ('write complete waits'). However in 8.1, 
cloning of buffers was introduced. So now the dirty buffer is cloned (see 
stats in v$sysstat), the new clone can be changed, the old clone is written. 
(old and new are bad words, but you get my drift). So write complete waits 
should be a whole lot less in 8.1 then before.  They may still happen (not 
sure why yet).

Anjo.


On Wednesday 30 July 2003 03:04, you wrote:
 That's On 2003.07.29 19:59, Diego Cutrone wrote:
  Another thing I think (I'm sorry to disagree with
  Mladen on this) is that when DBWR hasn't finished
  writing a buffer to the disk, and a session wants that
  buffer in exclusive mode, there's a wait and that wait
  is computed as a write complete wait and not as BBW.

 DBWR works in 2 phases:
 a) It scans for dirty buffers and pins them.
 b) It starts IO, usually using writev.

 If IO has been launched and not yet finished, then the wait is
 write complete wait. If IO hasn't been started yet, we have buffer
 busy. This write complete wait became essential with the advent of
 asynchronous I/O. I was just simplifying things, nothing else.

-- 

Anjo Kolk
http://www.oraperf.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Anjo Kolk
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: read only tablespace

2003-07-31 Thread Ron Rogers

What was the activity on the database before you issued the alter
tablespace command? It could be that the server was busy finishing up
that activity. If you were creating massive indexes then the temporary
indexes have to be made perminent. 
Ron

 [EMAIL PROTECTED] 07/30/03 03:34PM 
why does it take long time to turn a tablespace read only . I issued
the command 10 mins back , its still not returned .  There is almost no
activity in db .

8.1.7.4 
hp-ux 

-ak
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ron Rogers
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: 9i-OCP Question

I am wondering... where do these questions come from?

There is a disclosure agreement at the beginning of each Oracle exam...

Patrice.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Boivin, Patrice J
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: clustering




Hi!

I found out that these hanging problems were 
version 9.0.1's problems. I wasn't directly involved with this setup. But in 9.2 
they say these problems are fixed. (One instance hits ORA-600 with parameter 
4519 and all instances would hang until restarted all instances).
This was on 3-node tru64.

Tanel.

  - Original Message - 
  From: 
  Hemant 
  K Chitale 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Tuesday, July 29, 2003 6:19 
PM
  Subject: Re: clustering
  Tanel,I think that you've had some unfortunate 
  experiences with RAC. Mind elucdating them ?I don't see nodes 
  hanging when one node dies [I'm running a 2-node Tru64 RAC 
  Cluster]HemantAt 03:04 PM 28-07-03 -0800, you wrote:
  However, 
failed transactions must be handled from client side. Queries may migrate to 
surviving nodes transparently.Also, 
currently RAC has many problems, such all nodes hanging when one node dies. 
Completely separate systems are still (an will always be) the most available 
solution.Tanel.- Original Message - 

  From: Indy Johal 
  To: Multiple recipients of 
  list ORACLE-L 
  Sent: Monday, July 28, 2003 7:49 PM 
  Subject: Re: clustering
  Another Important different is that RAC is best High Availability 
  solution in case of System/Instance Failure where in case of HP or Veritas 
  Cluster, all of the resource get stopped on live system/node of the 
  cluster and then get started on second node and hence user will be 
  affected. But in case of system or Instance failure, there is seamless 
  transition of the User session in RAC 
  Indy Johal
  "Ron Rogers" [EMAIL PROTECTED] 
  Sent by: [EMAIL PROTECTED] 
  07/28/03 12:29 PM 
  Please respond to ORACLE-L 
   
   
  To: Multiple recipients of list 
  ORACLE-L [EMAIL PROTECTED] 
   
  cc: 
   
  Subject: Re: 
  clustering
  ak, 
  As I understand it, an HP cluster is 2 boxes that have the capability 
  to access the same disks and data but only one can have the oracle 
  instance running and accessing the datafiles(active). Sort of like a 
  high availability option. 
  With RAC both boxes can access the instance and datafiles at the same 
  time. 
  List, Correct me if I need it. 
  Ron
   [EMAIL PROTECTED] 07/28/03 12:14PM  
  Hi Guys , 
  I am new to this clustering concept. Just trying to understand few 
  basics . Need ur help .
  what is differece between oracle running on sun /hp cluster with 2 
  nodes and oracle with RAC running on 2 nodes ? 
  thanks, 
  -ak 
  -- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.net 
  -- 
  Author: Ron Rogers 
  INET: [EMAIL PROTECTED]
  Fat City Network Services -- 858-538-5051 http://www.fatcity.com 

  San Diego, California -- 
  Mailing list and web hosting services 
  - 
  To REMOVE yourself from this mailing list, send an E-Mail message 
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
  the message BODY, include a line containing: UNSUB ORACLE-L 
  (or the name of mailing list you want to be removed from). You 
  may 
  also send the HELP command for other information (like 
  subscribing).
  
  Hemant K ChitaleOracle 9i Database Administrator Certified 
  ProfessionalMy personal web site is : http://hkchital.tripod.com-- Please see the 
  official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: 
  [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 
  http://www.fatcity.com San Diego, California -- Mailing list and web hosting 
  services - 
  To REMOVE yourself from this mailing list, send an E-Mail message to: 
  [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message 
  BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list 
  you want to be removed from). You may also send the HELP command for other 
  information (like subscribing).

HP Data Protector

2003-07-31 Thread Patterson, Mark

Hi,

has anybody any experience of HP's Openview Storage Data Protector product
in relation to backing up Oracle databases? Any good or bad points to
comment on?

Am currently evaluating this product from Oracle RMAN perspective as well as
our overall centralised backup management process.

Using Windows 2000 and Oracle 8.1.7 Enterprise Edition.
Am experiencing difficulty performing restores from tape via RMAN and Data
Protector - can restore files individually when I issue restore
tablespace... and restore datafile... commands in RMAN but when I issue
restore database the Data Protector media management layer hangs
indefinitely after restoring first datafile and reports a status of
Pending in the Data Protector client interface.

Having no problems executing backups but would be interested in people's
general experiences and views.

Thanks,
Mark.




This message, including attached files, may contain confidential
information and is intended only for the use by the individual
and/or the entity to which it is addressed. Any unauthorized use,
dissemination of, or copying of the information contained herein is
not allowed and may lead to irreparable harm and damage for which
you may be held liable. If you receive this message in error or if
it is intended for someone else please notify the sender by
returning this e-mail immediately and delete the message.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Patterson, Mark
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: 9i-OCP Question

2003-07-31 Thread Senthil Kumar

Hi

This ques from a model examnothing to worry about disclosure and
all!!!

-Original Message-
Boivin, Patrice J
Sent: Thursday, July 31, 2003 6:24 PM
To: Multiple recipients of list ORACLE-L


I am wondering... where do these questions come from?

There is a disclosure agreement at the beginning of each Oracle exam...

Patrice.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Boivin, Patrice J
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Senthil Kumar
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Oracle to MSSQL conversion?

2003-07-31 Thread Grant Allen

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
 Boivin, Patrice J
 Sent: Thursday, July 31, 2003 12:59
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Oracle to MSSQL conversion?

 I have a question re. these conversions...

 If an Oracle database has 120 tablespaces, how does that
 translate in MSSQL
 speak?

The closest analogy is Filegroups.  Serve very similar purpose (to abstract
the physical storage), but aren't quite as sophisticated (no surprises
there)

 (One of the tablespaces is USERS, home of dozens of schemas;
 the others are
 either RB, SYSTEM, TEMP or application tablespaces)

 How many separate schemas-tablespaces can MSSQL hold per server?

No practical limit on schemas, don't know about Filegroups.  Be warned that
some people will try to convince you an Oracle schema equates to a SQLServer
database.  They're talking rubbish.  A schema is a schema in both.

Ciao
Fuzzy
:-)

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Grant Allen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: ORA-03115 (TOAD question!!)

rant

Man, I hope not.  The complete reversal of the security in TOAD from deny
all / grant some to grant all / deny some in 7.3 made maintenance a
nightmare (we're stuck at v7.2 for this reason).  Security granted by
default is not security -- it's a welcome mat with the key tucked
underneath.  This problem has been compounded by the lack of version
specified in the call to DBMS_APPLICATION_INFO.SET_MODULE that TOAD does.
If it had this, I could use a logon trigger to weed out non-standard
versions of TOAD on our production DBs.  I'm not looking to hamper our devs,
just help prevent them or TOAD from making happy accidents.

So now, if the freeware version's updated, I'll have zero control over who
uses what version of TOAD against our DBs.  And if the freeware version is
using the new and improved security-less model, it's an open door.

I miss Toadman Jim...

/rant

Rich

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA


 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, July 30, 2003 6:59 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: ORA-03115 (TOAD question!!)
 
 
 I believe I read on the TOAD list that they are working on a 
 major upgrade
 to the free version of TOAD that will bring it up to the 7.5 
 code base.  I
 think the target date was September...
 
 Dave
 
  -Original Message-
  From: Jesse, Rich [mailto:[EMAIL PROTECTED]
  Sent: Tuesday, July 29, 2003 4:09 PM
  To: Multiple recipients of list ORACLE-L
  Subject: RE: ORA-03115 (TOAD question!!)
  
  
  7.6 is BETA.  7.5.2 is the current release.  New betas appear 
  frequently.
  Also, this version is not free.  It's listed at just under 
  $800 US.  The
  freeware version is v6.x, which has the LOB bug, among a host 
  of others.
  
  Rich
  
  Rich Jesse   System/Database Administrator
  [EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: read only tablespace

Hi!

 The alter tablespace read only is waiting for every query which started
 before the alter tablespace was issued to finish. Just in case one of
 them might write to that tablespace and therefore fail.

Do you mean DML? Or transaction?

Anyway, I get following error on my 9.2.0.1 on Win2000 when making
tablespace read only during ongoing DML.

SQL update t set a = 1;
update t set a = 1
*
ERROR at line 1:
ORA-00372: file 9 cannot be modified at this time
ORA-01110: data file 9: 'C:\ORACLE\ORA92\ORCL\USERS01.DBF'

So it seems, that at least in this version of Oracle, tablespace can be made
read only during (first) DML on it. This happened when I ran an update
statement first time, and alter ts read only *during* it. When I ran alter
ts after update finished correctly, Oracle behaved as expected, it waited
until commit or rollback to this transaction.

When testing a bit more, I also got some ORA-00603: ORACLE server session
terminated by fatal error errors in updating session with a tracefile.
These issues could be fixed in latest versions though.

Tanel.


 so while the database does not HAVE to be quiesced before you issue an
 alter tablespace read only, it helps to prevent waits


 --- Tanel Poder [EMAIL PROTECTED] wrote:
  Hi!
 
  Alter tablespace read only performs checkpoint on datafiles belonging
  to this tablespace. But 10 minutes on an idle system is indicating
  some problems.
 
  Check this: select event, p1, p2, p3, state from v$session_wait where
  sid = sid of waiting session;
 
  You should get some indication, on what your alter tablespace command
  is waiting.
 
  Tanel.
 
- Original Message -
From: AK
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, July 30, 2003 10:34 PM
Subject: read only tablespace
 
 
why does it take long time to turn a tablespace read only . I
  issued the command 10 mins back , its still not returned .  There is
  almost no activity in db .
 
8.1.7.4
hp-ux
 
-ak


 __
 Do you Yahoo!?
 Yahoo! SiteBuilder - Free, easy-to-use web site design software
 http://sitebuilder.yahoo.com
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Rachel Carmichael
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

HELP! Index Debate!

Please help resolve this dispute. 
We have a query that runs over 5 hours.  Sections of the query are
listed below.

The table QOH_DAY_FACT table had only on index and that was on the
TIME_ID column.  I propose adding an index with PROD_ID, WHS_ID, LOT_ID,
WHS_LOC, TIME_ID and QUALITY_ID.  My test shows the runtime was reduced
to about 1.5 hours. 

The developer said all the columns in the index except PROD_ID were
being ignored.  He says there should be six separate indexes, one for
each column before Oracle will use them.

Also, does the order of the columns in the index have to match the order
of the columns in the WHERE CLAUS or is it more important to match the
WHERE CLAUS to the data content (least number of rows first)?

I will be running more tests, but I would like some input on this if
anyone has an opinion.

Thanks!
Ron


select T1.COUNTRY_NAME c1
  , T2.PRODTN_PROC_NAME c2
  , T2.PLANT_NAME c3
  , T1.WHS_NAME c4
  , T1.WHS_CMPLX_NAME c5
  , T3.WHS_LOC_NAME c6
  , T4.GRADE_DESC c7
  , T4.PACK_DESC c8
  , T5.FULL_DT c9
  , T6.QOH_MT c10...

from DWMART.DISTRIB_FCLTY_DIM T1
  , DWMART.MFG_FCLTY_DIM T2
  , DWMART.DISTRIB_LOC_DIM T3
  , DWMART.TIME_DIM T5
  , DWMART.QUALITY_DIM T7
  , DWMART.QOH_DAY_FACT T6
  , DWMART.PROD_DIM T4 
where T6.PROD_ID=T4.PROD_ID(+)
   and T6.WHS_ID=T1.WHS_ID
   and T6.LOT_ID=T2.LOT_ID
   and T6.WHS_LOC_ID=T3.WHS_LOC_ID
   and T6.TIME_ID=T5.TIME_ID
   and T6.QUALITY_ID=T7.QUALITY_ID 
order by c9 asc
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Smith, Ron L.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: 9i-OCP Question

2003-07-31 Thread April Wells

Title: RE: 9i-OCP Question





didn't you say it was a question/answer out of the book?


April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas


Few people really enjoy the simple pleasure of flying a kite
Adam Wells age 11




-Original Message-
From: Senthil Kumar [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 31, 2003 8:44 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: 9i-OCP Question



Hi


This ques from a model examnothing to worry about disclosure and
all!!!


-Original Message-
Boivin, Patrice J
Sent: Thursday, July 31, 2003 6:24 PM
To: Multiple recipients of list ORACLE-L



I am wondering... where do these questions come from?


There is a disclosure agreement at the beginning of each Oracle exam...


Patrice.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Boivin, Patrice J
 INET: [EMAIL PROTECTED]


Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Senthil Kumar
 INET: [EMAIL PROTECTED]


Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).



The information contained in this communication, including attachments, is strictly 
confidential and for the intended use of the addressee only; it may also contain 
proprietary, price sensitive, or legally privileged information. Notice is hereby given that 
any disclosure, distribution, dissemination, use, or copying of the information by anyone 
other than the intended recipient is strictly prohibited and may be illegal. If you have 
received this communication in error, please notify the sender immediately by reply e-mail, 
delete this communication, and destroy all copies.
 

Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to 
this e-mail has been swept for viruses. We specifically disclaim all liability and will 
accept no responsibility for any damage sustained as a result of software viruses and advise 
you to carry out your own virus checks before opening any attachment.

Re: read only tablespace

2003-07-31 Thread Rachel Carmichael

9.2.0.1 on Linux and my alter statement just waited to complete without
erroring out. We had both query only (select) and DML running. when I
rebooted the database, and no one was logged in, the alter tablespace
read only completed.

if you search the archives you can find the discussion thread. It was
about 2 months ago I believe


--- Tanel Poder [EMAIL PROTECTED] wrote:
 Hi!
 
  The alter tablespace read only is waiting for every query which
 started
  before the alter tablespace was issued to finish. Just in case one
 of
  them might write to that tablespace and therefore fail.
 
 Do you mean DML? Or transaction?
 
 Anyway, I get following error on my 9.2.0.1 on Win2000 when making
 tablespace read only during ongoing DML.
 
 SQL update t set a = 1;
 update t set a = 1
 *
 ERROR at line 1:
 ORA-00372: file 9 cannot be modified at this time
 ORA-01110: data file 9: 'C:\ORACLE\ORA92\ORCL\USERS01.DBF'
 
 So it seems, that at least in this version of Oracle, tablespace can
 be made
 read only during (first) DML on it. This happened when I ran an
 update
 statement first time, and alter ts read only *during* it. When I ran
 alter
 ts after update finished correctly, Oracle behaved as expected, it
 waited
 until commit or rollback to this transaction.
 
 When testing a bit more, I also got some ORA-00603: ORACLE server
 session
 terminated by fatal error errors in updating session with a
 tracefile.
 These issues could be fixed in latest versions though.
 
 Tanel.
 
 
  so while the database does not HAVE to be quiesced before you issue
 an
  alter tablespace read only, it helps to prevent waits
 
 
  --- Tanel Poder [EMAIL PROTECTED] wrote:
   Hi!
  
   Alter tablespace read only performs checkpoint on datafiles
 belonging
   to this tablespace. But 10 minutes on an idle system is
 indicating
   some problems.
  
   Check this: select event, p1, p2, p3, state from v$session_wait
 where
   sid = sid of waiting session;
  
   You should get some indication, on what your alter tablespace
 command
   is waiting.
  
   Tanel.
  
 - Original Message -
 From: AK
 To: Multiple recipients of list ORACLE-L
 Sent: Wednesday, July 30, 2003 10:34 PM
 Subject: read only tablespace
  
  
 why does it take long time to turn a tablespace read only . I
   issued the command 10 mins back , its still not returned .  There
 is
   almost no activity in db .
  
 8.1.7.4
 hp-ux
  
 -ak
 
 
  __
  Do you Yahoo!?
  Yahoo! SiteBuilder - Free, easy-to-use web site design software
  http://sitebuilder.yahoo.com
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.net
  --
  Author: Rachel Carmichael
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- 858-538-5051 http://www.fatcity.com
  San Diego, California-- Mailing list and web hosting
 services
 
 -
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like
 subscribing).
 
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Tanel Poder
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).


__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: ORA-03115 (TOAD question!!)

Where can we get a list of the bugs in freeware TOAD?

Patrice.

-Original Message-
Sent: Thursday, July 31, 2003 10:50 AM
To: Multiple recipients of list ORACLE-L


rant

Man, I hope not.  The complete reversal of the security in TOAD from deny
all / grant some to grant all / deny some in 7.3 made maintenance a
nightmare (we're stuck at v7.2 for this reason).  Security granted by
default is not security -- it's a welcome mat with the key tucked
underneath.  This problem has been compounded by the lack of version
specified in the call to DBMS_APPLICATION_INFO.SET_MODULE that TOAD does.
If it had this, I could use a logon trigger to weed out non-standard
versions of TOAD on our production DBs.  I'm not looking to hamper our devs,
just help prevent them or TOAD from making happy accidents.

So now, if the freeware version's updated, I'll have zero control over who
uses what version of TOAD against our DBs.  And if the freeware version is
using the new and improved security-less model, it's an open door.

I miss Toadman Jim...

/rant

Rich

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA


 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, July 30, 2003 6:59 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: ORA-03115 (TOAD question!!)
 
 
 I believe I read on the TOAD list that they are working on a 
 major upgrade
 to the free version of TOAD that will bring it up to the 7.5 
 code base.  I
 think the target date was September...
 
 Dave
 
  -Original Message-
  From: Jesse, Rich [mailto:[EMAIL PROTECTED]
  Sent: Tuesday, July 29, 2003 4:09 PM
  To: Multiple recipients of list ORACLE-L
  Subject: RE: ORA-03115 (TOAD question!!)
  
  
  7.6 is BETA.  7.5.2 is the current release.  New betas appear 
  frequently.
  Also, this version is not free.  It's listed at just under 
  $800 US.  The
  freeware version is v6.x, which has the LOB bug, among a host 
  of others.
  
  Rich
  
  Rich Jesse   System/Database Administrator
  [EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Boivin, Patrice J
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Inlist Iterator and NULLs SOLVED

2003-07-31 Thread Daniel Fink

Thanks to Wolfgang for spotting the problem. It was not the inlist iterator at all but 
an outer join! The NOT NULL predicate invalidated the outer join, so the optimizer was 
smart enough to make a different decision. I am still perplexed as to why the table 
access information was so radically different, but in light of the new finding, an 
explanation can be found.

The lesson learned here is to not to focus on a 'problem' until you fully understand 
the whole situation. 

Danielbegin:vcard 
n:Fink;Daniel
tel;cell:303.808.3282
tel;work:303.272.3225
x-mozilla-html:TRUE
adr:;;
version:2.1
email;internet:[EMAIL PROTECTED]
title:DB Services Lead
x-mozilla-cpt:;-4832
fn:Daniel Fink
end:vcard

RE: ORA-03115 (TOAD question!!)

http://www.toadsoft.com

I still think that the freeware version is excellent, just lacking in some
features found in v7.

Rich

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA


 -Original Message-
 From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]
 Sent: Thursday, July 31, 2003 9:10 AM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: ORA-03115 (TOAD question!!)
 
 
 Where can we get a list of the bugs in freeware TOAD?
 
 Patrice.
 
 -Original Message-
 Sent: Thursday, July 31, 2003 10:50 AM
 To: Multiple recipients of list ORACLE-L
 
 
 rant
 
 Man, I hope not.  The complete reversal of the security in 
 TOAD from deny
 all / grant some to grant all / deny some in 7.3 made maintenance a
 nightmare (we're stuck at v7.2 for this reason).  Security granted by
 default is not security -- it's a welcome mat with the key tucked
 underneath.  This problem has been compounded by the lack of version
 specified in the call to DBMS_APPLICATION_INFO.SET_MODULE 
 that TOAD does.
 If it had this, I could use a logon trigger to weed out non-standard
 versions of TOAD on our production DBs.  I'm not looking to 
 hamper our devs,
 just help prevent them or TOAD from making happy accidents.
 
 So now, if the freeware version's updated, I'll have zero 
 control over who
 uses what version of TOAD against our DBs.  And if the 
 freeware version is
 using the new and improved security-less model, it's an open door.
 
 I miss Toadman Jim...
 
 /rant
 
 Rich
 
 Rich Jesse   System/Database Administrator
 [EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA
 
 
  -Original Message-
  From: [EMAIL PROTECTED]
  [mailto:[EMAIL PROTECTED]
  Sent: Wednesday, July 30, 2003 6:59 PM
  To: Multiple recipients of list ORACLE-L
  Subject: RE: ORA-03115 (TOAD question!!)
  
  
  I believe I read on the TOAD list that they are working on a 
  major upgrade
  to the free version of TOAD that will bring it up to the 7.5 
  code base.  I
  think the target date was September...
  
  Dave
  
   -Original Message-
   From: Jesse, Rich [mailto:[EMAIL PROTECTED]
   Sent: Tuesday, July 29, 2003 4:09 PM
   To: Multiple recipients of list ORACLE-L
   Subject: RE: ORA-03115 (TOAD question!!)
   
   
   7.6 is BETA.  7.5.2 is the current release.  New betas appear 
   frequently.
   Also, this version is not free.  It's listed at just under 
   $800 US.  The
   freeware version is v6.x, which has the LOB bug, among a host 
   of others.
   
   Rich
   
   Rich Jesse   System/Database Administrator
   [EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Run Forms 9i

2003-07-31 Thread Indy Johal


Siddharth

Is your Http server running and can check it with 
http://ciscow40s0249.cisco-temp.com:

If you got an error in it then it mean you need to start the OHS by using dcmctl utility or thru OEM which can be invoked by running 
http://ciscow40s0249.cisco-temp.com:1810


Then check if the OC4J instance is running like the Default one is OC4J_BI_FORMS and the easy way is to use the below two link where First one is to check the Listener Servlet and the second one will check the Default forms and make sure that your ORACLE_HOME\forms90 contain test.fmx and ORACLE_HOME\forms90\server\default.env says FORMS90_PATH=ORACLE_HOME\forms90

http://ciscow40s0249.cisco-temp.com:/forms90/l90servlet
http://ciscow40s0249.cisco-temp.com:/forms90/f90servlet -- This will give the page as Forms are installed successfully by running the test.fmx

If you got an error 
then it means your OC4J Instance is down and this again can be started by using dcmctl utility or OEM as in OHS


If all is well above then Now you can make the following changes to run your application
1) create a directory named like ORACLE_HOME\forms90\SIDHARTH
2) put all of the your application .fmx and .plx file in the above directory
3) edit ORACLE_HOME\forms90\server\default.env file and make FORMS90_PATH=ORACLE_HOME\forms90\SIDHARTH
4) edit ORACLE_HOME\forms90\server\formsweb.cfg and make the following changes
forms=MODULE1.fmx
userid=SCOTT/[EMAIL PROTECTED]
5)http://ciscow40s0249.cisco-temp.com:/forms90/f90servlet


Hope this will give you some of the setup Idea and make it run or let me know

Indy Johal







Siddharth Haldankar [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/31/03 04:29 AM
Please respond to ORACLE-L


To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Run Forms 9i



Hi,

Do you have to do any setting to run forms9i, it does not have any forms
runtime environment. It runs only in the web server. My forms are giving
this link

http://ciscow40s0249.cisco-temp.com:/forms90/f90servlet?form=C:\Prog
ram%20Files\Common%20Files\System\MAPI\1033\MODULE1.fmxuserid=SCOTT/TIG
[EMAIL PROTECTED]buffer_records=NOdebug_messages=YESarray=YESquery_only=NOqu
iet=NORENDER=YES

but it gives page not displayed. Do we need to set any parameters?
Please advice.

Thanks in advance.

- Siddharth Haldankar
 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Siddharth Haldankar
 INET: [EMAIL PROTECTED]

Fat City Network Services  -- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).

Re: clustering

2003-07-31 Thread Hemant K Chitale



Ah. I never went to 9.0.1 I went from 8.1.5 OPS to 9.2.0.2
RAC, using Export-Import
and migrating to LMT, AutoAllocate, ASSM etc.
Hemant
At 05:24 AM 31-07-03 -0800, you wrote:
Hi!

I found out that these hanging problems were
version 9.0.1's problems. I wasn't directly involved with this setup. But
in 9.2 they say these problems are fixed. (One instance hits ORA-600 with
parameter 4519 and all instances would hang until restarted all
instances).
This was on 3-node tru64.

Tanel.

- Original Message - 
From: Hemant K
Chitale 
To: Multiple recipients of
list ORACLE-L 
Sent: Tuesday, July 29, 2003 6:19 PM
Subject: Re: clustering


Tanel,

I think that you've had some unfortunate experiences with RAC.
Mind elucdating them ?
I don't see nodes hanging when one node dies [I'm running a 2-node
Tru64 RAC Cluster]

Hemant

At 03:04 PM 28-07-03 -0800, you
wrote:
However, failed transactions must be handled from client side.
Queries may migrate to surviving nodes
transparently.
Also, currently RAC has many problems, such all nodes hanging when
one node dies. Completely separate systems are still (an will always be)
the most available solution.

Tanel.

- Original Message - 
From: Indy Johal 
To: Multiple recipients of list
ORACLE-L 
Sent: Monday, July 28, 2003 7:49 PM 
Subject: Re: clustering



Another Important different is that RAC is best High Availability
solution in case of System/Instance Failure where in case of HP or
Veritas Cluster, all of the resource get stopped on live system/node of
the cluster and then get started on second node and hence user will be
affected. But in case of system or Instance failure, there is seamless
transition of the User session in RAC 



Indy Johal



Ron Rogers [EMAIL PROTECTED]

Sent by: [EMAIL PROTECTED] 

07/28/03 12:29 PM 
Please respond to ORACLE-L 
 
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 
 cc: 
 Subject: Re: clustering





ak, 
As I understand it, an HP cluster is 2 boxes that have the capability 
to access the same disks and data but only one can have the oracle 
instance running and accessing the datafiles(active). Sort of like a 
high availability option. 
With RAC both boxes can access the instance and datafiles at the same 
time. 
List, Correct me if I need it. 
Ron

 [EMAIL PROTECTED] 07/28/03 12:14PM  
Hi Guys , 
I am new to this clustering concept. Just trying to understand few 
basics . Need ur help .

what is differece between oracle running on sun /hp cluster with 2 
nodes and oracle with RAC running on 2 nodes ? 

thanks, 
-ak 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Ron Rogers 
INET: [EMAIL PROTECTED]

Fat City Network Services -- 858-538-5051 http://www.fatcity.com 
San Diego, California -- Mailing list and web hosting services 
- 
To REMOVE yourself from this mailing list, send an E-Mail message 
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
the message BODY, include a line containing: UNSUB ORACLE-L 
(or the name of mailing list you want to be removed from). You may 
also send the HELP command for other information (like subscribing).
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is : http://hkchital.tripod.com
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). 


Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
My personal web site is : http://hkchital.tripod.com


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hemant K Chitale
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Correct method of auto starting standby db

2003-07-31 Thread Bob Metelsky

All,
I have a question of how to auto start a standby database. IOW,
it seems the logs are only applies if I issue the command
Recover managed standby database;

With thatcommand, the logs are applied, however, if I (or someone else)
exits the cmd window the process stops

So, how can I set this up to be automated?

I need to keep the database in this state (I must be missing the
obivious)

Sqlplus /nolog
Connect sys/*** as sysdba
Startup mount;
Alter databse mount standby database;

Recover managed standby database;

I used this doc as a base for my initSID.ora files and dosnt seem to
mention the starting up on the db
http://www.oracle-base.com/Articles/8i/StandbyDatabase.asp

Thanks!
bob

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bob Metelsky
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: ORA-03115 (TOAD question!!)

2003-07-31 Thread Charu Joshi

Title: RE: ORA-03115 (TOAD question!!)

Hi,

It
worked!! As suggested by Raj, I browsed the TOAD help on SQL*Net installation
and found out this piece of information:

**
When Oracle connects, it will look in ALL_HOMES for the
"LAST_HOME" value, which in this case is zero "0". It appends zero to
"HOME" to produce "HOME0", then it looks in HKLM\Software\ORACLE\HOME0 for the
ORACLE_HOME value.
**

I
modified the LAST_HOME key to point tothe 8i HOME and restarted TOAD and
was able to query CLOBs successfully.

Thanks
a lot!!

Best
wishes,
Charu

-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Jamadagni,
RajendraSent: Tuesday, July 29, 2003 8:21 PMTo: Multiple
recipients of list ORACLE-LSubject: RE: ORA-03115 (TOAD
question!!)
It is a TOAD question you need to read the sqlnet setup
section from help file. It is pretty detailed and will help you resolve the
problem.
Raj
Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art
!
-Original Message- From: Charu
Joshi [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 29, 2003 11:20 AM To: Multiple recipients of list ORACLE-L Subject: ORA-03115 (TOAD question!!)
Hi,
I have Oracle 8i Enterprise Server, Oracle 9i Enterprise
Server and Oracle 7.3.4 client on my NT4 machine. When
I connect to remote/local databases through TOAD 6.5
(which supports LOBs) and try to fetch a CLOB value I
get the 'ORA-03115: Unsupported network datatype or
representation'.
I think that this error is due to the limitation of CLOBs
in SQL*Net 2.3 which comes with 7.3.4 client. However,
I have set the default home to ORA_8i_HOME(which has
Net8) using the 'Home Selector' utility. Also, TOAD is
reading the TNSNames.Ora file from this home, so
should be using Net8 rather than SQL*Net. I have
Googled and searched Metalink, but got no clearcut reply. Can you please suggest any way to rectify it?
Thanks regards, Charu.

-- Please see the official ORACLE-L
FAQ: http://www.orafaq.net -- Author: Charu Joshi INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego,
California -- Mailing list and web
hosting services -
To REMOVE yourself from this mailing list, send an E-Mail
message to: [EMAIL PROTECTED] (note EXACT spelling
of 'ListGuru') and in the message BODY, include a line
containing: UNSUB ORACLE-L (or the name of mailing
list you want to be removed from). You may also
send the HELP command for other information (like subscribing).

RE: That Veritas thing

2003-07-31 Thread Goulet, Dick




Folks,

 While we're on Veritas's backs, I recently (like Tuesday 
night) heard from an Oracle employee (to remain nameless) that Orbitz will be 
issuing a retraction of their claim that their Oracle RAC implementation was the 
root cause of the outage they had. Seems the true culprit is, guess who, 
as the file system manager. It is supposedly also causing other problems 
with non Oracle stuff too.

Dick GouletSenior Oracle DBAOracle Certified 8i 
DBA 

  -Original Message-From: Michael Kline 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 30, 2003 8:29 
  PMTo: Multiple recipients of list ORACLE-LSubject: That 
  Veritas thing
  The database 
  backup is only export.
  
  Once in a while 
  they are supposed to be doing a cold
  backup.
  
  Finally found 
  someone that said they can't use
  the Oracle 
  Veritas agent with Oracle 9.0.2 and
  Failsafe and/or 
  clustering. They have given them
  a case number and 
  are working on it. When he 
  brings up the 
  Oracle agent it crashes...
  
  Well, that's why 
  we aren't getting any
  backup... except 
  the export and MAYBE a cold
  backup once in a 
  while.
  
  Thanks 
  list.
  
  
  Michael Alan Kline, Sr.PrincipalConsultantBusiness to Business 
  Solutions, LLCPhone: 804-744-1545 Cell: 804-314-6262ICQ: 
  1009605, 975313Email: [EMAIL PROTECTED] Web: www.b2bsol.com

RE: Correct method of auto starting standby db

2003-07-31 Thread Ross Collado

Hi,

What version of Oracle and OS platform you're using?
The document you read refers to an 8i db so I assume you are in 8i.
In our Solaris box with 8i on it, I created a shell script like so:

#!/bin/ksh
sqlplus -s /nolog !
Connect sys/*** as sysdba
recover managed standby database ;
exit
!

Then from the Unix prompt I run this script using nohup, eg:

$ nohup ./rcv_mng.sh  /dev/null 21 

Logging out of the session doesn't affect the script at all. It'll just keep
running in the background until you either kill the session or cancel it
from within another sqlplus window.

HTH
Ross


-Original Message-
Sent: Friday, 1 August 2003 12:54 AM
To: Multiple recipients of list ORACLE-L


All,
I have a question of how to auto start a standby database. IOW,
it seems the logs are only applies if I issue the command
Recover managed standby database;

With thatcommand, the logs are applied, however, if I (or someone else)
exits the cmd window the process stops

So, how can I set this up to be automated?

I need to keep the database in this state (I must be missing the
obivious)

Sqlplus /nolog
Connect sys/*** as sysdba
Startup mount;
Alter databse mount standby database;

Recover managed standby database;

I used this doc as a base for my initSID.ora files and dosnt seem to
mention the starting up on the db
http://www.oracle-base.com/Articles/8i/StandbyDatabase.asp

Thanks!
bob

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bob Metelsky
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ross Collado
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: rebuild index -initial extent - magic??!!

2003-07-31 Thread Wolfgang Breitling

Remember that initial_extent and next_extent in dba_indexes (and 
dba_tables) records what you requested in your storage clause - NOT what 
Oracle actually allocated. You need to look at dba_extents for tha.

At 02:34 AM 7/31/2003 -0800, you wrote:

If this is true:

The rebuild creates a new temporary segment that is the same size as the
required extents in the old index. If there is insufficient space to create
this temporary segment you get this error.
It doesn't reuse the existing space the index occupies but builds a second
identical index then renames and drops the old one.
Then rebuild will take longer as volume of data increases and more space 
will be required.  Where is the temp.. segment created?  In the old 
tablespace, the new tablespace (if you are moving it) or in memory or 
.in memory then ...??

I did the following in Oracle RDBMS 9i:

_ 

SQL alter index xsc_uk rebuild tablespace ax_le_small storage (initial 128K
  2  next 128K);
SQL select initial_extent,next_extent,index_name from dba_indexes
  2  where index_name like 'XSC%';
 65536  131072 XSC_CLNT_FK_I
 65536  131072 XSC_PK
131072  131072 XSC_UK
_ 

As I wish to use uniform extent sizing and I was given an import that does 
have that.  I am a little concerned about the initial extent changing - 
what if there is data in the index?  - how it could possibly deallocate 
space if you wish to have a smaller extent size.  It was very quick.  Did 
I really end up with new extents for XSC_UK each 128K
Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Wolfgang Breitling
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: ORA-03115 (TOAD question!!)

2003-07-31 Thread Jared Still


You may find it easier to just run the Oracle Home Selector
that appears in the Startup-Programs-Oracle Installation Products
menu.

It has the benefit of also modifying the PATH variable.

Jared

On Thu, 2003-07-31 at 07:54, Charu Joshi wrote:
 RE: ORA-03115 (TOAD question!!)Hi,
 
 It worked!! As suggested by Raj, I browsed the TOAD help on SQL*Net
 installation and found out this piece of information:
 
 **
 When Oracle connects, it will look in ALL_HOMES for the LAST_HOME value,
 which in this case is zero 0.  It appends zero to HOME to produce
 HOME0, then it looks in HKLM\Software\ORACLE\HOME0 for the ORACLE_HOME
 value.
 **
 
 I modified the LAST_HOME key to point to the 8i HOME and restarted TOAD and
 was able to query CLOBs successfully.
 
 Thanks a lot!!
 
 Best wishes,
 Charu
   -Original Message-
   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
 Jamadagni, Rajendra
   Sent: Tuesday, July 29, 2003 8:21 PM
   To: Multiple recipients of list ORACLE-L
   Subject: RE: ORA-03115 (TOAD question!!)
 
 
   It is a TOAD question  you need to read the sqlnet setup section from
 help file. It is pretty detailed and will help you resolve the problem.
 
   Raj
   --
 --
   Rajendra dot Jamadagni at nospamespn dot com
   All Views expressed in this email are strictly personal.
   QOTD: Any clod can have facts, having an opinion is an art !
 
 
 
   -Original Message-
   From: Charu Joshi [mailto:[EMAIL PROTECTED]
   Sent: Tuesday, July 29, 2003 11:20 AM
   To: Multiple recipients of list ORACLE-L
   Subject: ORA-03115 (TOAD question!!)
 
 
 
   Hi,
 
   I have Oracle 8i Enterprise Server, Oracle 9i Enterprise Server
   and Oracle 7.3.4 client on my NT4 machine. When I connect to
   remote/local databases through TOAD 6.5 (which supports LOBs) and
   try to fetch a CLOB value I get the 'ORA-03115: Unsupported
   network datatype or representation'.
 
   I think that this error is due to the limitation of CLOBs in
   SQL*Net 2.3 which comes with 7.3.4 client. However, I have set the
   default home to ORA_8i_HOME(which has Net8) using the 'Home
   Selector' utility. Also, TOAD is reading the TNSNames.Ora file
   from this home, so should be using Net8 rather than SQL*Net. I
   have Googled and searched Metalink, but got no clearcut reply. Can
   you please suggest any way to rectify it?
 
   Thanks  regards,
   Charu.
 
 
 
 
   --
   Please see the official ORACLE-L FAQ: http://www.orafaq.net
   --
   Author: Charu Joshi
 INET: [EMAIL PROTECTED]
 
   Fat City Network Services-- 858-538-5051 http://www.fatcity.com
   San Diego, California-- Mailing list and web hosting services
   -
   To REMOVE yourself from this mailing list, send an E-Mail message
   to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
   the message BODY, include a line containing: UNSUB ORACLE-L
   (or the name of mailing list you want to be removed from).  You may
   also send the HELP command for other information (like subscribing).
 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: 9i-OCP Question

2003-07-31 Thread Jared Still


Our Prod SAP system has 4 RAID1's dedicated to redo of 500m each
on an Clariion CX600 SAN.

Several groups with 2 members each.  That's 600 gig
of physical disk dedicated to redo, and nothing else.

Jared


On Thu, 2003-07-31 at 04:59, Boivin, Patrice J wrote:
 We use a SAN.
 
 Where does that leave me?
 
 : )
 
 Patrice.
 
 -Original Message-
 Sent: Wednesday, July 30, 2003 7:10 PM
 To: Multiple recipients of list ORACLE-L
 
 
 I'm constantly amazed (and relieved!) that there's disagreement on the
 most fundamental principles.
 
 First, I found myself nodding at Roy's first post.  On some databases,
 I have three log groups, with two members each.  Each set of members
 has its own disk.  I'll concede the argument that the instance goes
 down right away if one of the drives fails, but I _still_ have a full
 set of logs on the other drive, and that's a good thing, right?
 
 Second, if I have three groups of two members each and follow what
 seems to be the consensus opinion, I have three drives, each holding
 two members, one from each group.  In this case, aren't the two members
 on the same drive identical?  If I lose that drive, I lose that entire
 log group, and therefore no longer have a full set of logs--so what's
 the point of having two copies?  I also lose the instance immediately
 if that group happens to be the current group at the time of disk
 failure.
 
 Third, while I agree that every member of every group should ideally
 have its own disk, does ANYONE actually configure their DB this way?  I
 had a hard enough time dedicating one or two disks to redo logs; who
 can dedicate eight, especially given drive sizes of 72+ GB and (single)
 log file sizes of, what, 100 MB?
 
 
 
 
 --- Pardee, Roy E [EMAIL PROTECTED] wrote:
  Yep, that's right--I had it wrong.  You need to have at least one
  member from each group in order to do a full recovery.  I see now
  from my trusty dba fundamentals I class text that each member of a
  group is identical (or is supposed to be).
  
  So I guess I'll go back to being confused about why the answer to the
  question below is 2.  I guess 2 is the minimum required to survive a
  single disk failure?
  
  Cheers,
  
  -Roy
  
  Roy Pardee
  Programmer/Analyst/DBA
  SWFPAC Lockheed Martin IT
  Extension 8487
 
 
 __
 Do you Yahoo!?
 Yahoo! SiteBuilder - Free, easy-to-use web site design software
 http://sitebuilder.yahoo.com
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Paul Baumgartel
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Boivin, Patrice J
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: read only tablespace

2003-07-31 Thread AK

Rachel ,
Thanks for the Reply . On checking further I found that this session was
waiting on a lock from another session . But the table or object which was
locked by other session does not belong to this tablespace . Then why does
the read only operation waiting for the lock to release ??  Does it mean
that all transactions which started before issuing alter tablespace read
only should be finished ??

-ak


- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 30, 2003 5:44 PM


 Ah, one I have the answer to, as I had a similar question a while back.

 The alter tablespace read only is waiting for every query which started
 before the alter tablespace was issued to finish. Just in case one of
 them might write to that tablespace and therefore fail.

 so while the database does not HAVE to be quiesced before you issue an
 alter tablespace read only, it helps to prevent waits


 --- Tanel Poder [EMAIL PROTECTED] wrote:
  Hi!
 
  Alter tablespace read only performs checkpoint on datafiles belonging
  to this tablespace. But 10 minutes on an idle system is indicating
  some problems.
 
  Check this: select event, p1, p2, p3, state from v$session_wait where
  sid = sid of waiting session;
 
  You should get some indication, on what your alter tablespace command
  is waiting.
 
  Tanel.
 
- Original Message - 
From: AK
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, July 30, 2003 10:34 PM
Subject: read only tablespace
 
 
why does it take long time to turn a tablespace read only . I
  issued the command 10 mins back , its still not returned .  There is
  almost no activity in db .
 
8.1.7.4
hp-ux
 
-ak


 __
 Do you Yahoo!?
 Yahoo! SiteBuilder - Free, easy-to-use web site design software
 http://sitebuilder.yahoo.com
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Rachel Carmichael
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: AK
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Oracle to MSSQL conversion?

2003-07-31 Thread Jared Still

You might like to buy the ebook SQL Server 2000 for Oracle DBA's
by Chris Kempster: http://www.chriskempster.com/

I bought it, printed it and had it bound at Kinko's.

Appears to be a very good book, though I've only read parts of it.

Jared



On Thu, 2003-07-31 at 02:34, Denham Eva wrote:
 Hello,
 
 There is alot of talk about multi-skilling/reskilling going on here at my
 company. We use Oracle and MSSQL dbs. 
 I have been wondering if anyone is aware of a resource that shows the oracle
 programming technique and what the corresponding MSSQL programming technique
 is.
 ie
 Oracle defines variable   : MSSQL defines variable
 Oracle cursor looks like this   : MSSQL cursor looks like this.
 Oracle uses rollbacks: MSSQL uses MSSQL rollbacks
 etc
 Hope you all understand what I mean.
 
 TIA
 Denham Eva
 Oracle DBA
 Linux like TeePee... No Windows, No Gates and Apache inside!
 
 
 _
 This e-mail message has been scanned for Viruses and Content and cleared 
 by MailMarshal
 
 For more information please visit www.marshalsoftware.com
 _
 
 #
 Note:
 This message is for the named person's use only.  It may contain confidential,
 proprietary or legally privileged information.  No confidentiality or privilege
 is waived or lost by any mistransmission.  If you receive this message in error,
 please immediately delete it and all copies of it from your system, destroy any
 hard copies of it and notify the sender.  You must not, directly or indirectly,
 use, disclose, distribute, print, or copy any part of this message if you are not
 the intended recipient. TFMC and any of its subsidiaries each reserve
 the right to monitor all e-mail communications through its networks.
 
 Any views expressed in this message are those of the individual sender, except where
 the message states otherwise and the sender is authorized to state them to be the
 views of any such entity.
 
 Thank You.
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Denham Eva
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Oracle to MSSQL conversion?

2003-07-31 Thread Wolfe Stephen S GS-11 6 MDSS/SGSI

Being more of a SQL 2000 DBA (I am experienced from SQL Server 6.5).

At my installation I have 5 SQL-2000 database machines and recently
acquired three Oracle 9i machines.

The limit is essentially a function of your storage area and the amount
of real memory available to the processor or processor array.

I'm trying to draw similarities between the RDBM concepts now as I learn
Oracle's idea of a database.

Maybe now is a good time for me to ask these question since it is
related to this thread's subject, can you say that an Oracle instance is
essentially the same as a MSSQL database?  I ask this because a MSSQL
server can support multiple databases which can be configured different
ways.


v/r

Stephen S. Wolfe, GS-11, DAFC
Data Services Manager
[EMAIL PROTECTED]
(813) 827-9974  DSN 651-9974



 -Original Message-
 From: Boivin, Patrice J [mailto:[EMAIL PROTECTED] 
 Sent: Thursday, July 31, 2003 7:59 AM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Oracle to MSSQL conversion?
 
 
 I have a question re. these conversions...
 
 If an Oracle database has 120 tablespaces, how does that 
 translate in MSSQL speak?
 
 (One of the tablespaces is USERS, home of dozens of schemas; 
 the others are either RB, SYSTEM, TEMP or application tablespaces)
 
 How many separate schemas-tablespaces can MSSQL hold per server?
 
 Patrice.
 
 -Original Message-
 Sent: Thursday, July 31, 2003 7:34 AM
 To: Multiple recipients of list ORACLE-L
 
 
 I know Microsoft is offering a new course called 'Microsoft 
 SQL Server 2000 for Experienced Database Professionals'.  It 
 is aimed at DBAs with experience with Oracle, DB2, Sybase 
 etc. who want to know more about SQL Server.
 
 You can read more about this course at 
 http://www.microsoft.com/traincert/syllabi/2723afinal.asp.
 
 Gudmundur
 
  Hello,
  
  There is alot of talk about multi-skilling/reskilling going
  on here at my company. We use Oracle and MSSQL dbs. 
  I have been wondering if anyone is aware of a resource that 
  shows the oracle programming technique and what the 
  corresponding MSSQL programming technique is. ie
  Oracle defines variable   : MSSQL defines variable
  Oracle cursor looks like this   : MSSQL cursor looks like this.
  Oracle uses rollbacks: MSSQL uses MSSQL rollbacks
  etc
  Hope you all understand what I mean.
  
  TIA
  Denham Eva
  Oracle DBA
  Linux like TeePee... No Windows, No Gates and Apache inside!
  
  
  __
  ___
  This e-mail message has been scanned for Viruses and Content
  and cleared 
  by MailMarshal
  
  For more information please visit www.marshalsoftware.com
  __
  ___
  
  ##
  ###
  Note:
  This message is for the named person's use only.  It may
  contain confidential, proprietary or legally privileged 
  information.  No confidentiality or privilege is waived or 
  lost by any mistransmission.  If you receive this message in 
  error, please immediately delete it and all copies of it from 
  your system, destroy any hard copies of it and notify the 
  sender.  You must not, directly or indirectly, use, disclose, 
  distribute, print, or copy any part of this message if you 
  are not the intended recipient. TFMC and any of its 
  subsidiaries each reserve the right to monitor all e-mail 
  communications through its networks.
  
  Any views expressed in this message are those of the
  individual sender, except where the message states otherwise 
  and the sender is authorized to state them to be the views of 
  any such entity.
  
  Thank You.
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.net
  -- 
  Author: Denham Eva
INET: [EMAIL PROTECTED]
  
  Fat City Network Services-- 858-538-5051 http://www.fatcity.com
  San Diego, California-- Mailing list and web 
 hosting services
  
 -
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
  and in the message BODY, include a line containing: UNSUB 
  ORACLE-L (or the name of mailing list you want to be removed 
  from).  You may also send the HELP command for other 
  information (like subscribing).
  
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Gudmundur Bjarni Josepsson
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing:

RE: ORA-27101 RH linux 9 Oracle 9.2.0.3

2003-07-31 Thread Jack van Zanen

Title: Message



I set 
the value to 2147483648 and it still does the same thing.

Oracle 
database is open but when trying to connect through sqlnet I get 
ORA-27101.

I do 
shutdown immediate and startup and the problem is gone for a 
while.

I now 
stopped the archiver again and see if that gives me 
problems.

BTW: 
Is it normal 9i behaviour to write logswitches to trace


TIA



Jack

  
  -Original Message-From: Jack van Zanen 
  [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 4:09 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  ORA-27101 RH linux 9 Oracle 9.2.0.3
  Damn 
  your right,
  
  
  I 
  need new glasses :-)
  
  
  Thx
  
  
  
  
  
  
  

-Original Message-From: 
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, 
July 30, 2003 3:14 PMTo: Multiple recipients of list 
ORACLE-LSubject: RES: ORA-27101 RH linux 9 Oracle 
9.2.0.3

The parameter 
shmmax (Shared Memory) is lower than the sugested. Please 
check:

Yours: 
536870912
Sugested: 
2147483648



Sandro 
Augusto da SilvaTechnology 
Services  SupportNLA 
Technology ServicesPhone: +55 11 3398-8438Fax: 
+55 11 3398-7522
-Mensagem 
original-De: Jack van 
Zanen [mailto:[EMAIL PROTECTED] Enviada em: quarta-feira, 30 de julho 
de 2003 09:59Para: 
Multiple recipients of list ORACLE-LAssunto: RE: ORA-27101 RH linux 9 
Oracle 9.2.0.3


Hi,







Have 
tried to reconnect and get the error message 27101 (when using @sid 
logon)



**

[EMAIL PROTECTED] admin]# 
cd /proc/sys/kernel[EMAIL PROTECTED] kernel]# cat 
sem250 32000 
100 128[EMAIL PROTECTED] kernel]# cat 
shmmax536870912[EMAIL PROTECTED] kernel]# cat 
shmmni4096[EMAIL PROTECTED] kernel]# cat shmall2097152[EMAIL PROTECTED] 
kernel]# ulimit -u4095[EMAIL PROTECTED] kernel]# cat 
/proc/sys/net/ipv4/ip_local_port_range1024 
65000[EMAIL PROTECTED] kernel]# cat 
/proc/sys/fs/file-max65536[EMAIL PROTECTED] 
kernel]#





Only 
difference is that I set my semaphores higher than recommended (cat sem, cat 
shmmax)





Thx
-Original 
  Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 2:39 
  PMTo: Multiple 
  recipients of list ORACLE-LSubject: RES: ORA-27101 RH linux 9 
  Oracle 9.2.0.3
  Have you tried 
  to reconnect to the instance? Does the instance shuts down or your 
  connection?
  
  Try changing 
  the following parameters: 
  
  Oracle9i
  Installation 
  Guide
  Release 2 (9.2.0.1.0) for 
  UNIX Systems: AIX-Based Systems, Compaq Tru64 UNIX, HP
  9000 
  Series HP-UX, Linux Intel, and Sun Solaris
  
  2-20 
  Installation 
  Guide
  
  Perform the following steps to modify the kernel 
  parameters by using the /proc
  file system.
  1. 
  Log in as the root user.
  2. 
  Change to the /proc/sys/kernel 
  directory.
  3. 
  Review the current semaphore parameter values in 
  the sem file by using 
  the
  cat 
  or 
  more utility. For example, 
  using the cat utility, enter the 
  following
  command:
  # cat 
  sem
  The 
  output lists, in order, the values for the SEMMSL, SEMMNS, 
  SEMOPM,
  and 
  SEMMNI parameters. The following example shows how the 
  output
  appears:
  250 
  32000 32 128
  In 
  the preceding output example, 250 is the value of the SEMMSL 
  parameter,
  32000 is the value of the SEMMNS parameter, 32 is 
  the value of the SEMOPM
  parameter, and 128 is the value of the SEMMNI 
  parameter.
  4. 
  Modify the parameter values by using the following 
  command syntax:
  # echo 
  SEMMSL_value 
  SEMMNS_value SEMOPM_value SEMMNI_value  sem
  Replace the parameter variables with the values 
  for your system in the order
  that they are entered in the preceding example. 
  For example:
  # 
  echo 100 32000 100 100  sem
  5. 
  Review the current shared memory parameters by 
  using the cat or more
  utility. For example, using the 
  cat utility, enter the 
  following command:
  # cat 
  shared_memory_parameter
  In 
  the preceding example, the variable shared_memory_parameter is either 
  the
  SHMMAX or SHMMNI parameter. The parameter name 
  must be entered in
  lowercase letters.
  6. 
  Modify the shared memory parameter by using the 
  echo utility. For 
  example,
  to 
  modify

RE: That Veritas thing

2003-07-31 Thread Orr, Steve

Title: Message



Thanks 
for the " rumor gossip" Dick,

Is 
this in reference to the Veritas clustered file systems technology? Or the 
Veritas Cluster Manager product? Or a file systems manager 
person?

Curiouser and curiouser...


  
  -Original Message-From: Goulet, Dick 
  [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 9:19 
  AMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  That Veritas thing
  Folks,
  
   While we're on Veritas's backs, I recently (like Tuesday 
  night) heard from an Oracle employee (to remain nameless) that Orbitz will be 
  issuing a retraction of their claim that their Oracle RAC implementation was 
  the root cause of the outage they had. Seems the true culprit is, guess 
  who, as the file system manager. It is supposedly also causing other 
  problems with non Oracle stuff too.
  
  Dick GouletSenior Oracle DBAOracle Certified 8i 
  DBA 
  
-Original Message-From: Michael Kline 
[mailto:[EMAIL PROTECTED]Sent: Wednesday, July 30, 2003 8:29 
PMTo: Multiple recipients of list ORACLE-LSubject: 
That Veritas thing
The database 
backup is only export.

Once in a while 
they are supposed to be doing a cold
backup.

Finally found 
someone that said they can't use
the Oracle 
Veritas agent with Oracle 9.0.2 and
Failsafe and/or 
clustering. They have given them
a case number 
and are working on it. When he 
brings up the 
Oracle agent it crashes...

Well, that's 
why we aren't getting any
backup... 
except the export and MAYBE a cold
backup once in 
a while.

Thanks 
list.


Michael Alan Kline, Sr.PrincipalConsultantBusiness to Business 
Solutions, LLCPhone: 804-744-1545 Cell: 804-314-6262ICQ: 
1009605, 975313Email: [EMAIL PROTECTED] Web: www.b2bsol.com

sar

2003-07-31 Thread Henry Poras

Just got this email from my SysAdmin when I asked for access to sar. Anyone
know what he is talking about? We are on AIX 4 and 5.

I cannot give you direct access to the sar command.  Because of the
parameters
the command allows, it would be equivalent to giving full root access.

If you could give me some details on the kind of information you would like
to
be able to collect, maybe we could set up some kind of command to obtain
it.

Henry


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Henry Poras
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: read only tablespace

2003-07-31 Thread Rachel Carmichael

What we found is that it doesn't matter which tablespace the session
causing the wait is accessing. As explained to me (by Dan Fink I
believe), Oracle doesn't KNOW if that transaction will involve the
tablespace you are trying to make read-only or if it will not. So
rather than take a chance, the alter tablespace waits for all
transactions executing at the time it was issued to complete.


--- AK [EMAIL PROTECTED] wrote:
 Rachel ,
 Thanks for the Reply . On checking further I found that this session
 was
 waiting on a lock from another session . But the table or object
 which was
 locked by other session does not belong to this tablespace . Then why
 does
 the read only operation waiting for the lock to release ??  Does it
 mean
 that all transactions which started before issuing alter tablespace
 read
 only should be finished ??
 
 -ak
 
 
 - Original Message - 
 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
 Sent: Wednesday, July 30, 2003 5:44 PM
 
 
  Ah, one I have the answer to, as I had a similar question a while
 back.
 
  The alter tablespace read only is waiting for every query which
 started
  before the alter tablespace was issued to finish. Just in case one
 of
  them might write to that tablespace and therefore fail.
 
  so while the database does not HAVE to be quiesced before you issue
 an
  alter tablespace read only, it helps to prevent waits
 
 
  --- Tanel Poder [EMAIL PROTECTED] wrote:
   Hi!
  
   Alter tablespace read only performs checkpoint on datafiles
 belonging
   to this tablespace. But 10 minutes on an idle system is
 indicating
   some problems.
  
   Check this: select event, p1, p2, p3, state from v$session_wait
 where
   sid = sid of waiting session;
  
   You should get some indication, on what your alter tablespace
 command
   is waiting.
  
   Tanel.
  
 - Original Message - 
 From: AK
 To: Multiple recipients of list ORACLE-L
 Sent: Wednesday, July 30, 2003 10:34 PM
 Subject: read only tablespace
  
  
 why does it take long time to turn a tablespace read only . I
   issued the command 10 mins back , its still not returned .  There
 is
   almost no activity in db .
  
 8.1.7.4
 hp-ux
  
 -ak
 
 
  __
  Do you Yahoo!?
  Yahoo! SiteBuilder - Free, easy-to-use web site design software
  http://sitebuilder.yahoo.com
  -- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.net
  -- 
  Author: Rachel Carmichael
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- 858-538-5051 http://www.fatcity.com
  San Diego, California-- Mailing list and web hosting
 services
 
 -
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like
 subscribing).
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: AK
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 


__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Is Metalink Working

2003-07-31 Thread Barbara Baker



While Metalink is up and working, it's sporatically
dropping out.

A word to the wise.  If you're about to spend a chunk
of time updating a TAR, do it in a text editor, SAVE
it, copy it into your TAR, then update.  

If you spend 30 minutes updating your TAR, push the
update button, and get an action cancelled message
and lose everything, you're likely to say some VERY
bad words that might get you escorted out of the
building.

Um, not that I'd know . . .

Barb



__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Barbara Baker
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: rebuild index -initial extent - magic??!!

2003-07-31 Thread Avnish.Rastogi

Title: RE: rebuild index -initial extent - magic??!!



Rebuild will use the same initial extent as it was before but will change 
the next extent size. Either drop and recreate index 
orYou can also think about using Locally managed Uniform 
Extent size tablespace, that way you dont have to worry about specifying initial 
and next extent.

-Original Message-From: 
[EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]Sent: Thursday, July 31, 2003 
3:19 AMTo: Multiple recipients of list ORACLE-LSubject: 
RE: rebuild index -initial extent - magic??!!

  I did the following in Oracle RDBMS 9i: 
  _ 
  SQL alter index xsc_uk rebuild tablespace ax_le_small 
  storage (initial 128K  2 next 
  128K); SQL select 
  initial_extent,next_extent,index_name from dba_indexes  2 where index_name like 'XSC%'; 
   
  65536 131072 XSC_CLNT_FK_I  
  65536 131072 XSC_PK  
  131072 131072 XSC_UK _ 
  
  As I wish to use uniform extent sizing and I was given an 
  import that does have that. I am a little concerned about the initial 
  extent changing - what if there is data in the index? - how it could 
  possibly deallocate space if you wish to have a smaller extent size. It 
  was very quick. Did I really end up with new extents for XSC_UK each 
  128KDISCLAIMER:This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message.

Imort Parameter File Question

2003-07-31 Thread Jay

Hello:

Does anyone know if you can create a comment in a import parameter file?

If so could you provide a sample of the syntax.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jay
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Inlist Iterator and NULLs SOLVED

2003-07-31 Thread Wolfgang Breitling

Beacuse of the outer join, the optimizer had to ignore the inlist predicate 
and therefore the filter factor for the table became 1 (= all rows), 
manifested in TB_SEL 1..

At 06:29 AM 7/31/2003 -0800, you wrote:
Thanks to Wolfgang for spotting the problem. It was not the inlist 
iterator at all but an outer join! The NOT NULL predicate invalidated the 
outer join, so the optimizer was smart enough to make a different 
decision. I am still perplexed as to why the table access information was 
so radically different, but in light of the new finding, an explanation 
can be found.

The lesson learned here is to not to focus on a 'problem' until you fully 
understand the whole situation.

Daniel
Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Wolfgang Breitling
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Imort Parameter File Question

2003-07-31 Thread Bob Metelsky

# your comment goes here
# another comment
#  Bla bla

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bob Metelsky
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: sar

2003-07-31 Thread Hallas, John, Tech Dev

Normally sudo is used to grant limited permissions.

The SA would allow you to use sar and for you to access it you would type 
sar 
and be prompted for a password and you would enter the appropriate password.


John


-Original Message-
Sent: 31 July 2003 16:45
To: Multiple recipients of list ORACLE-L


Just got this email from my SysAdmin when I asked for access to sar. Anyone
know what he is talking about? We are on AIX 4 and 5.

I cannot give you direct access to the sar command.  Because of the
parameters
the command allows, it would be equivalent to giving full root access.

If you could give me some details on the kind of information you would like
to
be able to collect, maybe we could set up some kind of command to obtain
it.

Henry


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Henry Poras
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hallas, John, Tech Dev
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Imort Parameter File Question

2003-07-31 Thread DENNIS WILLIAMS

Jay - I don't think the exp and imp parameter files have provision for a
comment. But you could try common comment formats and see if you find one
that works. The person who wrote the parser might have added that but it
didn't end up in the documentation. I notice testing is a habit of the more
expert members of this list.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Thursday, July 31, 2003 11:34 AM
To: Multiple recipients of list ORACLE-L


Hello:

Does anyone know if you can create a comment in a import parameter file?

If so could you provide a sample of the syntax.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jay
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Oracle to MSSQL conversion?

An Oracle database with multiple applications using different schemas in
the same database would be close to the SQL Server model.

Ron Smith

-Original Message-
[mailto:[EMAIL PROTECTED] 
Sent: Thursday, July 31, 2003 10:55 AM
To: Multiple recipients of list ORACLE-L


Being more of a SQL 2000 DBA (I am experienced from SQL Server 6.5).

At my installation I have 5 SQL-2000 database machines and recently
acquired three Oracle 9i machines.

The limit is essentially a function of your storage area and the amount
of real memory available to the processor or processor array.

I'm trying to draw similarities between the RDBM concepts now as I learn
Oracle's idea of a database.

Maybe now is a good time for me to ask these question since it is
related to this thread's subject, can you say that an Oracle instance is
essentially the same as a MSSQL database?  I ask this because a MSSQL
server can support multiple databases which can be configured different
ways.


v/r

Stephen S. Wolfe, GS-11, DAFC
Data Services Manager
[EMAIL PROTECTED]
(813) 827-9974  DSN 651-9974



 -Original Message-
 From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]
 Sent: Thursday, July 31, 2003 7:59 AM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Oracle to MSSQL conversion?
 
 
 I have a question re. these conversions...
 
 If an Oracle database has 120 tablespaces, how does that
 translate in MSSQL speak?
 
 (One of the tablespaces is USERS, home of dozens of schemas;
 the others are either RB, SYSTEM, TEMP or application tablespaces)
 
 How many separate schemas-tablespaces can MSSQL hold per server?
 
 Patrice.
 
 -Original Message-
 Sent: Thursday, July 31, 2003 7:34 AM
 To: Multiple recipients of list ORACLE-L
 
 
 I know Microsoft is offering a new course called 'Microsoft
 SQL Server 2000 for Experienced Database Professionals'.  It 
 is aimed at DBAs with experience with Oracle, DB2, Sybase 
 etc. who want to know more about SQL Server.
 
 You can read more about this course at
 http://www.microsoft.com/traincert/syllabi/2723afinal.asp.
 
 Gudmundur
 
  Hello,
  
  There is alot of talk about multi-skilling/reskilling going on here 
  at my company. We use Oracle and MSSQL dbs. I have been wondering if

  anyone is aware of a resource that shows the oracle programming 
  technique and what the corresponding MSSQL programming technique is.

  ie
  Oracle defines variable   : MSSQL defines variable
  Oracle cursor looks like this   : MSSQL cursor looks like this.
  Oracle uses rollbacks: MSSQL uses MSSQL rollbacks
  etc
  Hope you all understand what I mean.
  
  TIA
  Denham Eva
  Oracle DBA
  Linux like TeePee... No Windows, No Gates and Apache inside!
  
  
  __
  ___
  This e-mail message has been scanned for Viruses and Content and 
  cleared by MailMarshal
  
  For more information please visit www.marshalsoftware.com 
  __
  ___
  
  ##
  ###
  Note:
  This message is for the named person's use only.  It may contain 
  confidential, proprietary or legally privileged information.  No 
  confidentiality or privilege is waived or lost by any 
  mistransmission.  If you receive this message in error, please 
  immediately delete it and all copies of it from your system, destroy

  any hard copies of it and notify the sender.  You must not, directly

  or indirectly, use, disclose, distribute, print, or copy any part of

  this message if you are not the intended recipient. TFMC and any of 
  its subsidiaries each reserve the right to monitor all e-mail
  communications through its networks.
  
  Any views expressed in this message are those of the individual 
  sender, except where the message states otherwise and the sender is 
  authorized to state them to be the views of any such entity.
  
  Thank You.
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.net
  --
  Author: Denham Eva
INET: [EMAIL PROTECTED]
  
  Fat City Network Services-- 858-538-5051 http://www.fatcity.com
  San Diego, California-- Mailing list and web 
 hosting services
  
 -
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
  the message BODY, include a line containing: UNSUB ORACLE-L (or the 
  name of mailing list you want to be removed from).  You may also 
  send the HELP command for other information (like subscribing).
  
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Gudmundur Bjarni Josepsson
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web

Re[2]: Is Metalink Working

2003-07-31 Thread Jonathan Gennick

Thursday, July 31, 2003, 12:09:24 PM, you wrote:
BB you're likely to say some VERY
BB bad words that might get you escorted out of the
BB building.

I thought those words were a necessary incantation, to make
our databases work. Else why would we say them so
oftengrin.

insert mental picture here of wizard bending over a steaming
cauldron, stirring up a fresh batch of data, mumbling all
the appropriate incantations, sprinkling in a bit of buffer
cache, a pinch of partitions, a RAC of lamb...

Best regards,

Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]

Join the Oracle-article list and receive one
article on Oracle technologies per month by 
email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, 
or send email to [EMAIL PROTECTED] and 
include the word subscribe in either the subject or body.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Gennick
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Oracle to MSSQL conversion?

2003-07-31 Thread Grant Allen

 Maybe now is a good time for me to ask these question since it is
 related to this thread's subject, can you say that an Oracle
 instance is
 essentially the same as a MSSQL database?  I ask this because a MSSQL
 server can support multiple databases which can be configured
 different
 ways.

But there are more things that the SQL Server database has controlled by its
instance than things it can set itself (e.g. performance parameters,
security settings, user sort space, processor affinity, connection handling
etc. etc. are all instance settings).  It's more accurate to say that an
Oracle instance is closer to a SQL Server instance than a database, but is
by no means exactly the same.  Oracle just doesn't have the concept of
multiple database support in one instance (and I mean database, not schema).
That's not necessarily a bad thing, just means they are different to SQL
Server (and DB2, Informix, Sybase and others which all have this).  I'll
stop there ... enough people on the list have heard my rant about this
before :-)

Ciao
Fuzzy
:-)

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Grant Allen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Oracle to MSSQL conversion?

2003-07-31 Thread Paul Baumgartel

An Oracle instance does not correlate to a SQL Server database.  

An Oracle instance is a running Oracle server, i.e., a set of
background processes and a System Global Area in memory.  It is what
permits applications to _access_ the database.  The database is on
disk, the instance in memory.

An Oracle _schema_ is analogous to a SQL Server database.

(BTW, what does v/r mean?)


--- Wolfe Stephen S GS-11 6 MDSS/SGSI [EMAIL PROTECTED]
wrote:
 Being more of a SQL 2000 DBA (I am experienced from SQL Server 6.5).
 
 At my installation I have 5 SQL-2000 database machines and recently
 acquired three Oracle 9i machines.
 
 The limit is essentially a function of your storage area and the
 amount
 of real memory available to the processor or processor array.
 
 I'm trying to draw similarities between the RDBM concepts now as I
 learn
 Oracle's idea of a database.
 
 Maybe now is a good time for me to ask these question since it is
 related to this thread's subject, can you say that an Oracle instance
 is
 essentially the same as a MSSQL database?  I ask this because a MSSQL
 server can support multiple databases which can be configured
 different
 ways.
 
 
 v/r
 
 Stephen S. Wolfe, GS-11, DAFC
 Data Services Manager
 [EMAIL PROTECTED]
 (813) 827-9974  DSN 651-9974
 
 
 
  -Original Message-
  From: Boivin, Patrice J [mailto:[EMAIL PROTECTED] 
  Sent: Thursday, July 31, 2003 7:59 AM
  To: Multiple recipients of list ORACLE-L
  Subject: RE: Oracle to MSSQL conversion?
  
  
  I have a question re. these conversions...
  
  If an Oracle database has 120 tablespaces, how does that 
  translate in MSSQL speak?
  
  (One of the tablespaces is USERS, home of dozens of schemas; 
  the others are either RB, SYSTEM, TEMP or application tablespaces)
  
  How many separate schemas-tablespaces can MSSQL hold per server?
  
  Patrice.
  
  -Original Message-
  Sent: Thursday, July 31, 2003 7:34 AM
  To: Multiple recipients of list ORACLE-L
  
  
  I know Microsoft is offering a new course called 'Microsoft 
  SQL Server 2000 for Experienced Database Professionals'.  It 
  is aimed at DBAs with experience with Oracle, DB2, Sybase 
  etc. who want to know more about SQL Server.
  
  You can read more about this course at 
  http://www.microsoft.com/traincert/syllabi/2723afinal.asp.
  
  Gudmundur
  
   Hello,
   
   There is alot of talk about multi-skilling/reskilling going
   on here at my company. We use Oracle and MSSQL dbs. 
   I have been wondering if anyone is aware of a resource that 
   shows the oracle programming technique and what the 
   corresponding MSSQL programming technique is. ie
   Oracle defines variable   : MSSQL defines variable
   Oracle cursor looks like this   : MSSQL cursor looks like this.
   Oracle uses rollbacks: MSSQL uses MSSQL rollbacks
   etc
   Hope you all understand what I mean.
   
   TIA
   Denham Eva
   Oracle DBA
   Linux like TeePee... No Windows, No Gates and Apache inside!
   
   
   __
   ___
   This e-mail message has been scanned for Viruses and Content
   and cleared 
   by MailMarshal
   
   For more information please visit www.marshalsoftware.com
   __
   ___
   
   ##
   ###
   Note:
   This message is for the named person's use only.  It may
   contain confidential, proprietary or legally privileged 
   information.  No confidentiality or privilege is waived or 
   lost by any mistransmission.  If you receive this message in 
   error, please immediately delete it and all copies of it from 
   your system, destroy any hard copies of it and notify the 
   sender.  You must not, directly or indirectly, use, disclose, 
   distribute, print, or copy any part of this message if you 
   are not the intended recipient. TFMC and any of its 
   subsidiaries each reserve the right to monitor all e-mail 
   communications through its networks.
   
   Any views expressed in this message are those of the
   individual sender, except where the message states otherwise 
   and the sender is authorized to state them to be the views of 
   any such entity.
   
   Thank You.
   --
   Please see the official ORACLE-L FAQ: http://www.orafaq.net
   -- 
   Author: Denham Eva
 INET: [EMAIL PROTECTED]
   
   Fat City Network Services-- 858-538-5051
 http://www.fatcity.com
   San Diego, California-- Mailing list and web 
  hosting services
   
 
 -
   To REMOVE yourself from this mailing list, send an E-Mail message
   to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
   and in the message BODY, include a line containing: UNSUB 
   ORACLE-L (or the name of mailing list you want to be removed 
   from).  You may also send the HELP command

RE: sar

2003-07-31 Thread Henry Poras

Thanks John. I've used sudo, just not sure where sar is equivilent to 'full
root access'.

Henry

-Original Message-
Hallas, John, Tech Dev
Sent: Thursday, July 31, 2003 12:49 PM
To: Multiple recipients of list ORACLE-L


Normally sudo is used to grant limited permissions.

The SA would allow you to use sar and for you to access it you would type
sar
and be prompted for a password and you would enter the appropriate password.


John


-Original Message-
Sent: 31 July 2003 16:45
To: Multiple recipients of list ORACLE-L


Just got this email from my SysAdmin when I asked for access to sar. Anyone
know what he is talking about? We are on AIX 4 and 5.

I cannot give you direct access to the sar command.  Because of the
parameters
the command allows, it would be equivalent to giving full root access.

If you could give me some details on the kind of information you would like
to
be able to collect, maybe we could set up some kind of command to obtain
it.

Henry


--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Henry Poras
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hallas, John, Tech Dev
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Henry Poras
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Imort Parameter File Question

2003-07-31 Thread Jay

Dennis:

I have tested through most of the common formats already, that is why I
asked for help from the list.
Your advise about testing is noted, but in this case based on incorrect
assumptions.
I used most of the major comments in PL/SQL, Java, etc.
Though I missed trying the #, which per Barbara's reply seems to be the
correct one.
In my next posting I will make sure that I list all steps taken.

Barbara was nice though to forward  the below:

 $ more export_to_null.par
 #  ===
 #  export_to_null
 #  ===
 userid=sys/password
 file=/dev/null
 log=export_to_null.log
 direct=y
 compress=n



- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, July 31, 2003 12:49 PM


 Jay - I don't think the exp and imp parameter files have provision for a
 comment. But you could try common comment formats and see if you find one
 that works. The person who wrote the parser might have added that but it
 didn't end up in the documentation. I notice testing is a habit of the
more
 expert members of this list.

 Dennis Williams
 DBA, 80%OCP, 100% DBA
 Lifetouch, Inc.
 [EMAIL PROTECTED]


 -Original Message-
 Sent: Thursday, July 31, 2003 11:34 AM
 To: Multiple recipients of list ORACLE-L


 Hello:

 Does anyone know if you can create a comment in a import parameter file?

 If so could you provide a sample of the syntax.
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Jay
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: DENNIS WILLIAMS
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jay
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Correct method of auto starting standby db

Hi!

Try:

recover managed standby database disconnect;

This should spawn a separate process for recovering.

Tanel.

- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, July 31, 2003 5:54 PM


 All,
 I have a question of how to auto start a standby database. IOW,
 it seems the logs are only applies if I issue the command
 Recover managed standby database;
 
 With thatcommand, the logs are applied, however, if I (or someone else)
 exits the cmd window the process stops
 
 So, how can I set this up to be automated?
 
 I need to keep the database in this state (I must be missing the
 obivious)
 
 Sqlplus /nolog
 Connect sys/*** as sysdba
 Startup mount;
 Alter databse mount standby database;
 
 Recover managed standby database;
 
 I used this doc as a base for my initSID.ora files and dosnt seem to
 mention the starting up on the db
 http://www.oracle-base.com/Articles/8i/StandbyDatabase.asp
 
 Thanks!
 bob
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Bob Metelsky
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Imort Parameter File Question

Hi!

I have used # for that.

Tanel.
- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, July 31, 2003 7:34 PM


 Hello:
 
 Does anyone know if you can create a comment in a import parameter file?
 
 If so could you provide a sample of the syntax.
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Jay
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: sar

2003-07-31 Thread Matthew Zito


Is sar on AIX setuid?  If so, that could be where the reluctance stems
from.

Thanks,
Matt

--
Matthew Zito
GridApp Systems
Email: [EMAIL PROTECTED]
Cell: 646-220-3551
Phone: 212-358-8211 x 359
http://www.gridapp.com

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On 
 Behalf Of Henry Poras
 Sent: Thursday, July 31, 2003 1:19 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: sar
 
 
 Thanks John. I've used sudo, just not sure where sar is 
 equivilent to 'full root access'.
 
 Henry
 
 -Original Message-
 Hallas, John, Tech Dev
 Sent: Thursday, July 31, 2003 12:49 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Normally sudo is used to grant limited permissions.
 
 The SA would allow you to use sar and for you to access it 
 you would type sar and be prompted for a password and you 
 would enter the appropriate password.
 
 
 John
 
 
 -Original Message-
 Sent: 31 July 2003 16:45
 To: Multiple recipients of list ORACLE-L
 
 
 Just got this email from my SysAdmin when I asked for access 
 to sar. Anyone know what he is talking about? We are on AIX 4 and 5.
 
 I cannot give you direct access to the sar command.  Because 
 of the parameters the command allows, it would be equivalent 
 to giving full root access.
 
 If you could give me some details on the kind of information 
 you would like to be able to collect, maybe we could set up 
 some kind of command to obtain it.
 
 Henry
 
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Henry Poras
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 
 and in the message BODY, include a line containing: UNSUB 
 ORACLE-L (or the name of mailing list you want to be removed 
 from).  You may also send the HELP command for other 
 information (like subscribing).
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Hallas, John, Tech Dev
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 
 and in the message BODY, include a line containing: UNSUB 
 ORACLE-L (or the name of mailing list you want to be removed 
 from).  You may also send the HELP command for other 
 information (like subscribing).
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Henry Poras
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 
 and in the message BODY, include a line containing: UNSUB 
 ORACLE-L (or the name of mailing list you want to be removed 
 from).  You may also send the HELP command for other 
 information (like subscribing).
 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Matthew Zito
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Imort Parameter File Question

2003-07-31 Thread Hately, Mike (LogicaCMG)

Had a couple of minutes so ...
The syntax you need is (cryptically enough) :

# Comment

Cheers,
Mike Hately

-Original Message-
Sent: 31 July 2003 16:50
To: Multiple recipients of list ORACLE-L


Jay - I don't think the exp and imp parameter files have provision for a
comment. But you could try common comment formats and see if you find one
that works. The person who wrote the parser might have added that but it
didn't end up in the documentation. I notice testing is a habit of the more
expert members of this list.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Thursday, July 31, 2003 11:34 AM
To: Multiple recipients of list ORACLE-L


Hello:

Does anyone know if you can create a comment in a import parameter file?

If so could you provide a sample of the syntax.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jay
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services



E mail Disclaimer

You agree that you have read and understood this disclaimer and you agree to be bound 
by its terms.

The information contained in this e-mail and any files transmitted with it (if any) 
are confidential and intended for the addressee only.  If you have received this  
e-mail in error please notify the originator.

This e-mail and any attachments have been scanned for certain viruses prior to sending 
but CE Electric UK Funding Company nor any of its associated companies from whom this 
e-mail originates shall be liable for any losses as a result of any viruses being 
passed on.

No warranty of any kind is given in respect of any information contained in this   
e-mail and you should be aware that that it might be incomplete, out of date or 
incorrect. It is therefore essential that you verify all such information with us 
before placing any reliance upon it.

CE Electric UK Funding Company
Lloyds Court
78 Grey Street
Newcastle upon Tyne
NE1 6AF
Registered in England and Wales: Number 3476201



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hately, Mike (LogicaCMG)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Oracle to MSSQL conversion?

I haven't heard of an SQL Server instance before... do you mean a SQL Server
server?

(this is getting a bit confusing)

Patrice.

-Original Message-
Sent: Thursday, July 31, 2003 1:19 PM
To: Multiple recipients of list ORACLE-L


 Maybe now is a good time for me to ask these question since it is
 related to this thread's subject, can you say that an Oracle
 instance is
 essentially the same as a MSSQL database?  I ask this because a MSSQL
 server can support multiple databases which can be configured
 different
 ways.

But there are more things that the SQL Server database has controlled by its
instance than things it can set itself (e.g. performance parameters,
security settings, user sort space, processor affinity, connection handling
etc. etc. are all instance settings).  It's more accurate to say that an
Oracle instance is closer to a SQL Server instance than a database, but is
by no means exactly the same.  Oracle just doesn't have the concept of
multiple database support in one instance (and I mean database, not schema).
That's not necessarily a bad thing, just means they are different to SQL
Server (and DB2, Informix, Sybase and others which all have this).  I'll
stop there ... enough people on the list have heard my rant about this
before :-)

Ciao
Fuzzy
:-)

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Grant Allen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Boivin, Patrice J
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: read only tablespace

2003-07-31 Thread AK

The same is not true when you take tablespace offline with normal option . I
just tested that if a transaction is pending then oracle waits before
marking tablespace rea only BUTTT if x-saction is pending and I issue
offline  normal it succeds . Doesn't offline normal also checkpoints
datafile ?

-ak


- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, July 31, 2003 9:09 AM


 What we found is that it doesn't matter which tablespace the session
 causing the wait is accessing. As explained to me (by Dan Fink I
 believe), Oracle doesn't KNOW if that transaction will involve the
 tablespace you are trying to make read-only or if it will not. So
 rather than take a chance, the alter tablespace waits for all
 transactions executing at the time it was issued to complete.


 --- AK [EMAIL PROTECTED] wrote:
  Rachel ,
  Thanks for the Reply . On checking further I found that this session
  was
  waiting on a lock from another session . But the table or object
  which was
  locked by other session does not belong to this tablespace . Then why
  does
  the read only operation waiting for the lock to release ??  Does it
  mean
  that all transactions which started before issuing alter tablespace
  read
  only should be finished ??
 
  -ak
 
 
  - Original Message - 
  To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
  Sent: Wednesday, July 30, 2003 5:44 PM
 
 
   Ah, one I have the answer to, as I had a similar question a while
  back.
  
   The alter tablespace read only is waiting for every query which
  started
   before the alter tablespace was issued to finish. Just in case one
  of
   them might write to that tablespace and therefore fail.
  
   so while the database does not HAVE to be quiesced before you issue
  an
   alter tablespace read only, it helps to prevent waits
  
  
   --- Tanel Poder [EMAIL PROTECTED] wrote:
Hi!
   
Alter tablespace read only performs checkpoint on datafiles
  belonging
to this tablespace. But 10 minutes on an idle system is
  indicating
some problems.
   
Check this: select event, p1, p2, p3, state from v$session_wait
  where
sid = sid of waiting session;
   
You should get some indication, on what your alter tablespace
  command
is waiting.
   
Tanel.
   
  - Original Message - 
  From: AK
  To: Multiple recipients of list ORACLE-L
  Sent: Wednesday, July 30, 2003 10:34 PM
  Subject: read only tablespace
   
   
  why does it take long time to turn a tablespace read only . I
issued the command 10 mins back , its still not returned .  There
  is
almost no activity in db .
   
  8.1.7.4
  hp-ux
   
  -ak
  
  
   __
   Do you Yahoo!?
   Yahoo! SiteBuilder - Free, easy-to-use web site design software
   http://sitebuilder.yahoo.com
   -- 
   Please see the official ORACLE-L FAQ: http://www.orafaq.net
   -- 
   Author: Rachel Carmichael
 INET: [EMAIL PROTECTED]
  
   Fat City Network Services-- 858-538-5051 http://www.fatcity.com
   San Diego, California-- Mailing list and web hosting
  services
  
  -
   To REMOVE yourself from this mailing list, send an E-Mail message
   to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
   the message BODY, include a line containing: UNSUB ORACLE-L
   (or the name of mailing list you want to be removed from).  You may
   also send the HELP command for other information (like
  subscribing).
  
  -- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.net
  -- 
  Author: AK
INET: [EMAIL PROTECTED]
 
  Fat City Network Services-- 858-538-5051 http://www.fatcity.com
  San Diego, California-- Mailing list and web hosting services
  -
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like subscribing).
 


 __
 Do you Yahoo!?
 Yahoo! SiteBuilder - Free, easy-to-use web site design software
 http://sitebuilder.yahoo.com
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Rachel Carmichael
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to

RE: Oracle to MSSQL conversion?

2003-07-31 Thread Wolfe Stephen S GS-11 6 MDSS/SGSI

I think I understand what you have said, Oracle runs an instance per
database where MSSQL is one instance running multiple databases.  Is
this right thinking?

v/r

Stephen S. Wolfe, GS-11, DAFC
Data Services Manager
[EMAIL PROTECTED]
(813) 827-9974  DSN 651-9974



 -Original Message-
 From: Grant Allen [mailto:[EMAIL PROTECTED] 
 Sent: Thursday, July 31, 2003 12:19 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Oracle to MSSQL conversion?
 
 
  Maybe now is a good time for me to ask these question since it is 
  related to this thread's subject, can you say that an 
 Oracle instance 
  is essentially the same as a MSSQL database?  I ask this because a 
  MSSQL server can support multiple databases which can be configured
  different
  ways.
 
 But there are more things that the SQL Server database has 
 controlled by its instance than things it can set itself 
 (e.g. performance parameters, security settings, user sort 
 space, processor affinity, connection handling etc. etc. are 
 all instance settings).  It's more accurate to say that an 
 Oracle instance is closer to a SQL Server instance than a 
 database, but is by no means exactly the same.  Oracle just 
 doesn't have the concept of multiple database support in one 
 instance (and I mean database, not schema). That's not 
 necessarily a bad thing, just means they are different to SQL 
 Server (and DB2, Informix, Sybase and others which all have 
 this).  I'll stop there ... enough people on the list have 
 heard my rant about this before :-)
 
 Ciao
 Fuzzy
 :-)
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Grant Allen
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 
 and in the message BODY, include a line containing: UNSUB 
 ORACLE-L (or the name of mailing list you want to be removed 
 from).  You may also send the HELP command for other 
 information (like subscribing).
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Wolfe Stephen S GS-11 6 MDSS/SGSI
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Oracle to MSSQL conversion?

2003-07-31 Thread Wolfe Stephen S GS-11 6 MDSS/SGSI

Yes, MSSQL is running as an instance and you can multiple instances on
the same server (that is W2K or 2003 server), each instance is SQL
server consuming it's predefined resources.  Each instance of MSSQL can
be servicing different databases.

v/r

Stephen S. Wolfe, GS-11, DAFC
Data Services Manager
[EMAIL PROTECTED]
(813) 827-9974  DSN 651-9974



 -Original Message-
 From: Boivin, Patrice J [mailto:[EMAIL PROTECTED] 
 Sent: Thursday, July 31, 2003 1:39 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Oracle to MSSQL conversion?
 
 
 I haven't heard of an SQL Server instance before... do you 
 mean a SQL Server server?
 
 (this is getting a bit confusing)
 
 Patrice.
 
 -Original Message-
 Sent: Thursday, July 31, 2003 1:19 PM
 To: Multiple recipients of list ORACLE-L
 
 
  Maybe now is a good time for me to ask these question since it is 
  related to this thread's subject, can you say that an 
 Oracle instance 
  is essentially the same as a MSSQL database?  I ask this because a 
  MSSQL server can support multiple databases which can be configured
  different
  ways.
 
 But there are more things that the SQL Server database has 
 controlled by its instance than things it can set itself 
 (e.g. performance parameters, security settings, user sort 
 space, processor affinity, connection handling etc. etc. are 
 all instance settings).  It's more accurate to say that an 
 Oracle instance is closer to a SQL Server instance than a 
 database, but is by no means exactly the same.  Oracle just 
 doesn't have the concept of multiple database support in one 
 instance (and I mean database, not schema). That's not 
 necessarily a bad thing, just means they are different to SQL 
 Server (and DB2, Informix, Sybase and others which all have 
 this).  I'll stop there ... enough people on the list have 
 heard my rant about this before :-)
 
 Ciao
 Fuzzy
 :-)
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Grant Allen
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 
 and in the message BODY, include a line containing: UNSUB 
 ORACLE-L (or the name of mailing list you want to be removed 
 from).  You may also send the HELP command for other 
 information (like subscribing).
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Boivin, Patrice J
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 
 and in the message BODY, include a line containing: UNSUB 
 ORACLE-L (or the name of mailing list you want to be removed 
 from).  You may also send the HELP command for other 
 information (like subscribing).
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Wolfe Stephen S GS-11 6 MDSS/SGSI
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Change nuber.+# to number

2003-07-31 Thread Liu, Jack




Hi,I want to get rid or 
those special char in a number string to a pure number, for an instance, from 
89_. or 99,9 to 89 and 999.Which function should I use in SqlPlus?Thanks 
a lot,

Jack

Change nuber.+# to 
number

Re: Set Role in Trigger

2003-07-31 Thread JApplewhite


Jared,

Yeah, I'm sure our Developers complain to their boss That dang DBA's
Jacking with my application again. ;-)

Actually, it would only take as long to generate the 50k triggers as it
would to loop through the list of tables in a PL/SQL procedure and
generate/execute the Dynamic SQL Create Trigger commands for those
tables.  The Before Statement Triggers would all have the same simple call
to a security package that checked the User's UserClass and allowed/failed
the DML.

Since tables are created by each Campus from time to time, I could have an
After Create Trigger on the App Schema and add that generic security
trigger to each new table.

As opposed to Triggers, I'm really excited about Granting/Revoking System
Privileges to control each User's access to the various sets of tables they
hit for different Schoolyears.  That way there's just a couple of triggers
for me to maintain, not 50,000, and the App's native security (incomplete
as it is) controls most of the access.  I'm just applying an extra,
transparent, layer.

Jack C. Applewhite
Database Administrator
Austin Independent School District
Austin, Texas
512.414.9715 (wk)
512.935.5929 (pager)
[EMAIL PROTECTED]



   
  
  Jared Still  
  
  [EMAIL PROTECTED]To:   Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED] 
  om  cc: 
  
  Sent by: Subject:  Re: Set Role in Trigger   
  
  [EMAIL PROTECTED]
  
  .com 
  
   
  
   
  
  07/31/2003 12:34 
  
  AM   
  
  Please respond to
  
  ORACLE-L 
  
   
  
   
  





Incredible amount of work you've had to do here Jack.

Now I can say I know Jack about roles in triggers.

Yeah, ok, sorry.  ;)

Jack, how long do you think it will take to create 50k triggers?

Jared

On Wed, 2003-07-30 at 12:54, [EMAIL PROTECTED] wrote:

 OK, here's what I've found so far.

 There is no way at all in Oracle8i (don't know about 9i or 10g) to
 enable/disable/affect a User's Role from within a Trigger.  Role
processing
 is automatically disabled in any Definer Rights PL/SQL module.  All
 Triggers can only be created to execute with Definer Rights.  So it
doesn't
 matter if the User owns the Trigger or any Invoker Rights procedure it
 calls - Role processing is disabled, period.  (Thanks to Roy Pardee for
 pointing me to MetaLink Note 106140.1, which lays it out pretty clearly.)
 FGAC and/or Application Context is also of no help in enabling/disabling
 Roles from within a Trigger.  Notice I said from within a Trigger -
 that's my requirement.  I can't add any code to call an Invoker Rights
 Stored Procedure to switch Roles from within the (3rd Party, remember)
App
 itself - that would have been easy.

 I tried to do an Alter User User Default Role TheRoleIWantToEnable
 from the Trigger.  First of all, it's got to be an Autonomous Transaction
 Trigger, since Alter User issues an implicit Commit.  I did that, but
even
 when the Trigger was owned by System, an Insufficient Privileges error
 was generated.  If the Trigger was owned by Sys, however, it fired
 successfully and the User's Default Roles were changed (as evidenced by
the
 User querying User_Role_Privs).  However,  the User's ENABLED Roles were
 unaffected for that session, which is just what the docs indicate.  The
 User's new Default Roles would be enabled at the next Login.  No help
 there.

 I thought about setting up different Schemas with only synonyms and
 different privileges on the

** find whether table or index being accessed

2003-07-31 Thread A Joshi

Hi,
 Is there an easy way to find out if a table or anindex is being used. I mean short of going thru all code or keeping looking at v$sqlarea. I mean even if code is covered there are always ad hoc SQL queries etc. Same for other objects like views etc. Is there a place where oracle stores objects accessed and any other related info.

Thanks


Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software

RE: Oracle to MSSQL conversion?

2003-07-31 Thread Nelson Flores

An SQL Server instance IS the Server... 

-Mensaje original-
De: Boivin, Patrice J [mailto:[EMAIL PROTECTED] 
Enviado el: jueves, 31 de julio de 2003 13:39
Para: Multiple recipients of list ORACLE-L
Asunto: RE: Oracle to MSSQL conversion?

I haven't heard of an SQL Server instance before... do you mean a SQL Server
server?

(this is getting a bit confusing)

Patrice.

-Original Message-
Sent: Thursday, July 31, 2003 1:19 PM
To: Multiple recipients of list ORACLE-L


 Maybe now is a good time for me to ask these question since it is
 related to this thread's subject, can you say that an Oracle
 instance is
 essentially the same as a MSSQL database?  I ask this because a MSSQL
 server can support multiple databases which can be configured
 different
 ways.

But there are more things that the SQL Server database has controlled by its
instance than things it can set itself (e.g. performance parameters,
security settings, user sort space, processor affinity, connection handling
etc. etc. are all instance settings).  It's more accurate to say that an
Oracle instance is closer to a SQL Server instance than a database, but is
by no means exactly the same.  Oracle just doesn't have the concept of
multiple database support in one instance (and I mean database, not schema).
That's not necessarily a bad thing, just means they are different to SQL
Server (and DB2, Informix, Sybase and others which all have this).  I'll
stop there ... enough people on the list have heard my rant about this
before :-)

Ciao
Fuzzy
:-)

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Grant Allen
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Boivin, Patrice J
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Nelson  Flores
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: That Veritas thing

2003-07-31 Thread Goulet, Dick

Title: Message



That 
point was not disclosed. Personally, I vote for the 
later.

Dick GouletSenior Oracle DBAOracle Certified 8i 
DBA 

  -Original Message-From: Orr, Steve 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, July 31, 2003 11:59 
  AMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  That Veritas thing
  Thanks for the " rumor gossip" Dick,
  
  Is 
  this in reference to the Veritas clustered file systems technology? Or the 
  Veritas Cluster Manager product? Or a file systems manager 
  person?
  
  Curiouser and curiouser...
  
  

-Original Message-From: Goulet, Dick 
[mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 9:19 
AMTo: Multiple recipients of list ORACLE-LSubject: RE: 
That Veritas thing
Folks,

 While we're on Veritas's backs, I recently (like 
Tuesday night) heard from an Oracle employee (to remain nameless) that 
Orbitz will be issuing a retraction of their claim that their Oracle RAC 
implementation was the root cause of the outage they had. Seems the 
true culprit is, guess who, as the file system manager. It is 
supposedly also causing other problems with non Oracle stuff 
too.

Dick GouletSenior Oracle DBAOracle Certified 8i 
DBA 

  -Original Message-From: Michael Kline 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 30, 2003 8:29 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  That Veritas thing
  The database 
  backup is only export.
  
  Once in a 
  while they are supposed to be doing a cold
  backup.
  
  Finally found 
  someone that said they can't use
  the Oracle 
  Veritas agent with Oracle 9.0.2 and
  Failsafe 
  and/or clustering. They have given them
  a case number 
  and are working on it. When he 
  brings up the 
  Oracle agent it crashes...
  
  Well, that's 
  why we aren't getting any
  backup... 
  except the export and MAYBE a cold
  backup once 
  in a while.
  
  Thanks 
  list.
  
  
  Michael Alan Kline, Sr.PrincipalConsultantBusiness to 
  Business Solutions, LLCPhone: 804-744-1545 Cell: 
  804-314-6262ICQ: 1009605, 975313Email: [EMAIL PROTECTED] Web: 
  www.b2bsol.com

RE: 9i-OCP Question

2003-07-31 Thread Jacques Kilchoer

Except that:
1) five disks was not one of the possible answers, and
2) we don't know that the database is in archivelog mode.
For the 9i OCP examination the correct answer is answer number 4 (4 disks). I'm 
willing to bet on it!

 -Original Message-
 From: Ron Yount [mailto:[EMAIL PROTECTED]
 
 Well Who knows what the author of the question intended, 
 but in the
 example of 2 (duplexed) redo log groups with archiving, they 
 speak of five
 disks.  One of EACH log member (not shared with log members of another
 group) and one for the archive log destination.
 
 That being said, I believe the answer to the question is A: 8
 
 -Original Message-
 Jacques Kilchoer
 Sent: Wednesday, July 30, 2003 9:19 PM
 To: Multiple recipients of list ORACLE-L
 
 
  -Original Message-
  From: Senthil Kumar [mailto:[EMAIL PROTECTED]
  
  What is the correct answer for this?
  
  Q If you have 2 redo log groups with 4 members each, how
  many disks does
  Oracle recommend
 to keep the redo log files?
  
  1. 8
  2. 2
  3. 1
  4. 4
 
 The question specifically says how many disks does Oracle 
 recommend...? It
 seems to me that the correct answer is answer number 4, 
 Oracle recommends 4
 disks. (Quote: When setting up a multiplexed online redo 
 log, place members
 of a group on different disks. If a single disk fails, then 
 ONLY ONE MEMBER
 of a group becomes unavailable... - capitalization mine) Therefore 4
 members - 4 disks.
 
 Here is a link to a relevant section from an Oracle manual.
 
 Oracle9i Database Administrator's Guide, Release 2 (9.2), Part Number
 A96521-01 
 Chapter 7 - Managing the Online Redo Log: Placing Online Redo 
 Log Members on
 Different Disks 
 
 http://download-west.oracle.com/docs/cd/B10501_01/server.920/a
 96521/onlinere
 do.htm#5414
 
 Placing Online Redo Log Members on Different Disks
 When setting up a multiplexed online redo log, place members 
 of a group on
 different disks. If a single disk fails, then only one member 
 of a group
 becomes unavailable to LGWR and other members remain 
 accessible to LGWR, so
 the instance can continue to function.
 
 If you archive the redo log, spread online redo log members 
 across disks to
 eliminate contention between the LGWR and ARCn background 
 processes. For
 example, if you have two groups of duplexed online redo log 
 members, place
 each member on a different disk and set your archiving 
 destination to a
 fifth disk. Consequently, there is never contention between 
 LGWR (writing to
 the members) and ARCn (reading the members).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jacques Kilchoer
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Change nuber.+# to number

2003-07-31 Thread Gorbounov,Vadim




Does it make a deal?

SQL select translate('#33', 
'1234567890#,_', '1234567890') from 
dual;

TR--33

  -Original Message-From: Liu, Jack 
  [mailto:[EMAIL PROTECTED]Sent: Thursday, July 31, 2003 2:10 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  Change nuber.+# to number
  Hi,I want to get rid or 
  those special char in a number string to a pure number, for an instance, from 
  89_. or 99,9 to 89 and 999.Which function should I use in 
  SqlPlus?Thanks a lot,
  
  Jack
  
  Change nuber.+# to 
  number

RE: Change nuber.+# to number

2003-07-31 Thread Eberhard, Jeff

One way that might work is to use the translate function.  For Example:

SQLr
  1* select
translate('numberstring',1||translate('numberstring','0123456789','
'),'1') from dual
Enter value for numberstring: 89_.
Enter value for numberstring: 89_.
old   1: select
translate('numberstring',1||translate('numberstring','0123456789','
'),'1') from dual
new   1: select translate('89_.',1||translate('89_.','0123456789',' '),'1')
from dual

TR
--
89

1 row selected.

SQLr
  1* select
translate('numberstring',1||translate('numberstring','0123456789','
'),'1') from dual
Enter value for numberstring: 99,9
Enter value for numberstring: 99,9
old   1: select
translate('numberstring',1||translate('numberstring','0123456789','
'),'1') from dual
new   1: select translate('99,9',1||translate('99,9','0123456789',' '),'1')
from dual

TRA
---
999

1 row selected.


HTH,
Jeff


-Original Message-
Sent: Thursday, July 31, 2003 12:10 PM
To: Multiple recipients of list ORACLE-L


Hi,
I want to get rid or those special char in a number string to a pure number,
for an instance, from 89_. or 99,9 to 89 and 999.
Which function should I use in SqlPlus?
Thanks a lot,

Jack

Change nuber.+# to number
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Eberhard, Jeff
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: That Veritas thing

2003-07-31 Thread Matthew Zito

Title: Message




I'd 
vote for the middle option. Veritas AC for RAC is hideously complex and 
there's about a million ways to be running on it even though the configis 
fundamentally broken. It could also be the clustered file system, of 
course, since cluster file systems are Hard Problems (tm).

Thanks,
Matt
--Matthew ZitoGridApp SystemsEmail: 
[EMAIL PROTECTED]Cell: 646-220-3551Phone: 212-358-8211 x 359http://www.gridapp.com 

  
  -Original Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of 
  Goulet, DickSent: Thursday, July 31, 2003 2:29 PMTo: 
  Multiple recipients of list ORACLE-LSubject: RE: That Veritas 
  thing
  That 
  point was not disclosed. Personally, I vote for the 
  later.
  
  Dick GouletSenior Oracle DBAOracle Certified 8i 
  DBA 
  
-Original Message-From: Orr, Steve 
[mailto:[EMAIL PROTECTED]Sent: Thursday, July 31, 2003 11:59 
AMTo: Multiple recipients of list ORACLE-LSubject: RE: 
That Veritas thing
Thanks for the " rumor gossip" Dick,

Is 
this in reference to the Veritas clustered file systems technology? Or the 
Veritas Cluster Manager product? Or a file systems manager 
person?

Curiouser and curiouser...


  
  -Original Message-From: Goulet, Dick 
  [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 9:19 
  AMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: That Veritas thing
  Folks,
  
   While we're on Veritas's backs, I recently (like 
  Tuesday night) heard from an Oracle employee (to remain nameless) that 
  Orbitz will be issuing a retraction of their claim that their Oracle RAC 
  implementation was the root cause of the outage they had. Seems the 
  true culprit is, guess who, as the file system manager. It is 
  supposedly also causing other problems with non Oracle stuff 
  too.
  
  Dick GouletSenior Oracle DBAOracle Certified 8i 
  DBA 
  
-Original Message-From: Michael Kline 
[mailto:[EMAIL PROTECTED]Sent: Wednesday, July 30, 2003 
8:29 PMTo: Multiple recipients of list 
ORACLE-LSubject: That Veritas thing
The 
database backup is only export.

Once in a 
while they are supposed to be doing a cold
backup.

Finally 
found someone that said they can't use
the Oracle 
Veritas agent with Oracle 9.0.2 and
Failsafe 
and/or clustering. They have given them
a case 
number and are working on it. When he 
brings up 
the Oracle agent it crashes...

Well, 
that's why we aren't getting any
backup... 
except the export and MAYBE a cold
backup once 
in a while.

Thanks 
list.


Michael Alan Kline, Sr.PrincipalConsultantBusiness to 
Business Solutions, LLCPhone: 804-744-1545 Cell: 
804-314-6262ICQ: 1009605, 975313Email: [EMAIL PROTECTED] Web: 
www.b2bsol.com

RE: where does omniback generates log of backup ?

Without a platform, version or other info, it's hard to say.  On an HP/UX
11.0 machine running Omniback II vA.04.10, at least, you can look thru man
omniintro to find the location of log files.  However, those logs don't
generally contain what was backed up.  That's stored in the Omniback
database.  You really need to RTFM before messing with this stuff.  You lose
your recovery if you lose that DB.

xomni has a GUI with a friendlier interface than most of the command-line
utils.

Rich Jesse   System/Database Administrator 
[EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA 


-Original Message-
Sent: Thursday, July 31, 2003 12:44 PM
To: Multiple recipients of list ORACLE-L
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

union all problems

2003-07-31 Thread Ed Lewis




Hi,
 We have a query which 
uses
a "union all". After upgrading 
to
a patch release of Oracle this query
no longer works. We get the
following error :
ERROR at line 1:ORA-03113: end-of-file on 
communication channel
ORA-24323: value not allowedError accessing package 
DBMS_APPLICATION_INFOERROR:ORA-03114: not connected to ORACLE

I've searched metalink, but have been unsuccessful
finding a solution.

As a quick fix, we changed the "union all" to a "union",
and that worked.
We'll still like to find the root cause though.

The environment is AIX 4.3.3. It worked with
Oracle 8.1.7.2, but after upgrading to 8.1.7.4
we get this error.

Has anyone experienced this ? thanks.

  ed

Oracle SCN Question

2003-07-31 Thread Nick Wagner

Internally, Oracle represents SCNs as a base and a wrap.  The wrap is a 16-bit number 
and the base is a 32-bit number.  A dump of a redo log file would display the SCN as 
0x..  However, the SCN is represented as a number in a number of the 
dynamic performance views (v$log.first_change# for example).  What does this numeric 
value represent?  Is this just the SCN base, or is it a combination of base and wrap.  
If the wrap is 1, 2, or 3, etc., what is the value displayed in the dynamic 
performance views for the SCN?

For example, if the SCN was 0x0002.0001, what would that evaluate to as a single 
number?

Thanks, 

Nick Wagner

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Nick Wagner
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

logging oracle error code and message into a table within procedu

2003-07-31 Thread Basavaraja, Ravindra

Hi All,

I want to log the oracle error code and messages that will be generated
within a procedure/trigger
into a table.

I know i can write this in the exception block.Does anyone has any sample
code to help me out.

thanks
ravindra
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Basavaraja, Ravindra
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: where does omniback generates log of backup ?

2003-07-31 Thread Nelson, Allan

So ya wanna do a little omniback eh?

Omnidb -rpt -last gets you all yesterday's backup sessions.  

What you will see here depends on how your shop decided to setup
backups.  Filesystem is one way.  Basically omniback backs you up mount
point by mount point.  Host based is the other way.  Backup the whole
machine in one session.  Sessions will look like 2003/07/31-1 and the
trailing digit will increment for sessions.

And now that you have your sessions

Omnidb -filesystem {your fqdn:/your-dir 'your label'} -session {from
previous command} -listdir {your-dir} gets you a list of files

Here's an example for this one:
Omnidb -filesystem mshpx.corp.fred.com:/d01 'prod-daily' -session
2003/01/16-3 -listdir /d01/prod would work if your daily backup was
called prod-daily and you wanted to look at a subdirectory named prod of
a mount point named /d01 you were backing up.

Omnidb -session {see above} -detail gets the list of filesystems backed
up

Omnidb -filesystem {see above} gets you the list of all sessions that
contain the filesystem

Omnidb -session {see above} -media shows the tapes in that session

Omnidb -session {see above} -report warning gets the whole list of
errors for that session

Omnidb -filesystem {see abov} -session {see above} -catalog shows ls -lR
listing of files

That 'your label' thing is easiest to get from xomni or the windows
variant.  It will be basically whatever you decided to name your backup
'prod-daily' is one from our shop.  Note the quotes are required.  There
is quite a bit more to the omnidb command but if you are using the
filesystem method of backup this will get you enough to answer your
questions or perhaps script a solution that checks the backups against
the database (this is what we did). Nicely enough you don't even have to
be root to execute this command.

Actually you wont loose your ability to recover if you loose that db.
You could import the tapes, but you really, really wouldn't want to
unless you have an exceptionally boring life.  A good backup scheme will
backup the omnidb daily too.

Allan

-Original Message-
Sent: Thursday, July 31, 2003 2:04 PM
To: Multiple recipients of list ORACLE-L


Without a platform, version or other info, it's hard to say.  On an
HP/UX 11.0 machine running Omniback II vA.04.10, at least, you can look
thru man omniintro to find the location of log files.  However, those
logs don't generally contain what was backed up.  That's stored in the
Omniback database.  You really need to RTFM before messing with this
stuff.  You lose your recovery if you lose that DB.

xomni has a GUI with a friendlier interface than most of the
command-line utils.

Rich Jesse   System/Database Administrator 
[EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA 


-Original Message-
Sent: Thursday, July 31, 2003 12:44 PM
To: Multiple recipients of list ORACLE-L
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).


__
This email is intended solely for the person or entity to which it is addressed and 
may contain confidential and/or privileged information.  Copying, forwarding or 
distributing this message by persons or entities other than the addressee is 
prohibited. If you have received this email in error, please contact the sender 
immediately and delete the material from any computer.  This email may have been 
monitored for policy compliance.  [021216]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Nelson, Allan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: logging oracle error code and message into a table within pro

Title: RE: logging oracle error code and message into a table within procedu





create or replace log_errors (in_errors varchar2, in_calls varchar2)
is
szerrors varchar2(1000) := dbms_utility.format_error_stack;
szCalls varchar2(1000) := dbms_utility.format_call_stack;
pragma autonomous_transaction;
begin
 szerrors := 
 insert into error_log (error_ts, ora_user, error_text)
 values (sysdate, user, szerrors);
 commit;
end;
/



begin
...
exception
 when others then
 log_errors;
 -- for benefit of the program ...
 raise;
end;
/


something like this should help ...
Raj

Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !



-Original Message-
From: Basavaraja, Ravindra [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 31, 2003 3:35 PM
To: Multiple recipients of list ORACLE-L
Subject: logging oracle error code and message into a table within
procedu



Hi All,


I want to log the oracle error code and messages that will be generated
within a procedure/trigger
into a table.


I know i can write this in the exception block.Does anyone has any sample
code to help me out.


thanks
ravindra
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Basavaraja, Ravindra
 INET: [EMAIL PROTECTED]


Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).



This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*2

Re: ** how to check version and problems

2003-07-31 Thread Pete Finnigan

Hi,

have a look at $ORACLE_BASE/oraInventory/logs/installActions.log.
hth

kind regards

Pete
-- 
Pete Finnigan
email:[EMAIL PROTECTED]
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Pete Finnigan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: logging oracle error code and message into a table within pro

Title: RE: logging oracle error code and message into a table within procedu



sorry  
should be ...

 
insert into error_log (error_ts, ora_user, error_text, call_stack)  values (sysdate, 
user, szerrors,szcalls); 

Raj
 
Rajendra dot Jamadagni at nospamespn dot 
com All Views expressed in this email 
are strictly personal. QOTD: Any clod 
can have facts, having an opinion is an art ! 

  -Original Message-From: Jamadagni, Rajendra 
  Sent: Thursday, July 31, 2003 3:45 PMTo: Multiple 
  recipients of list ORACLE-LSubject: RE: logging oracle error code 
  and message into a table within pro
  create or replace log_errors (in_errors varchar2, in_calls 
  varchar2) is szerrors 
  varchar2(1000) := dbms_utility.format_error_stack; szCalls varchar2(1000) := dbms_utility.format_call_stack; 
  pragma autonomous_transaction; begin  szerrors :=  insert into error_log (error_ts, ora_user, error_text) 
   values (sysdate, user, szerrors);  commit; end; / 
  begin ... exception  when others then 
   log_errors;  -- for benefit of the program ... 
   raise; end; / 
  something like this should help ... Raj  
  Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. 
  QOTD: Any clod can have facts, having an opinion is an art 
  ! 
  -Original Message- From: 
  Basavaraja, Ravindra [mailto:[EMAIL PROTECTED]] 
  Sent: Thursday, July 31, 2003 3:35 PM To: Multiple recipients of list ORACLE-L Subject: logging oracle error code and message into a table 
  within procedu 
  Hi All, 
  I want to log the oracle error code and messages that will be 
  generated within a procedure/trigger into a table. 
  I know i can write this in the exception block.Does anyone has 
  any sample code to help me out. 
  thanks ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.net 
  -- Author: Basavaraja, 
  Ravindra  INET: 
  [EMAIL PROTECTED] 
  Fat City Network Services -- 858-538-5051 http://www.fatcity.com 
  San Diego, 
  California -- Mailing list and web 
  hosting services - 
  To REMOVE yourself from this mailing list, send an E-Mail 
  message to: [EMAIL PROTECTED] (note EXACT spelling 
  of 'ListGuru') and in the message BODY, include a line 
  containing: UNSUB ORACLE-L (or the name of mailing 
  list you want to be removed from). You may also 
  send the HELP command for other information (like subscribing). 

*This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*1

where does omniback generates log of backup ?

2003-07-31 Thread AK

RE: Correct method of auto starting standby db

2003-07-31 Thread Bob Metelsky

Ok It looks like the disconnect is for 9i

From metalink

This recover command must be ended from a different session with
recover managed standby database cancel. There is a timeout=n option
to the recovery command which will cause recovery to end if a new
archive log is not received in n minutes. For example, recover managed
standby database timeout=10 will start the recovery command, but if
there is a 10 minute wait between the arrival of any two archive logs,
the command will end. 

You can execute the recover command in the background using the AT
command with just a one time execution. For example if it's 8:00 AM use:
at 8:05 sqlplus @file.sql. If you need further assistance with this,
please post a new thread in the Microsoft Server  Utilities forum. 

Oracle9i provides a 'disconnect' option when placing a database 
in managed recovery. This allows for managed recovery to run in the 
background. 


Looks like I have to schedule a job to run every hour with a time out of
n min

Thanks
Bob



 All,
   I have a question of how to auto start a standby 
 database. IOW, it seems the logs are only applies if I issue 
 the command Recover managed standby database;
 
 With thatcommand, the logs are applied, however, if I (or 
 someone else) exits the cmd window the process stops
 
 So, how can I set this up to be automated?
 
 I need to keep the database in this state (I must be missing the
 obivious)
 
 Sqlplus /nolog
 Connect sys/*** as sysdba
 Startup mount;
 Alter databse mount standby database;
 
 Recover managed standby database;
 
 I used this doc as a base for my initSID.ora files and dosnt 
 seem to mention the starting up on the db 
 http://www.oracle- base.com/Articles/8i/StandbyDatabase.asp
 
 
 Thanks!
 bob
 
 -- 
 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Bob Metelsky
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 
 and in the message BODY, include a line containing: UNSUB 
 ORACLE-L (or the name of mailing list you want to be removed 
 from).  You may also send the HELP command for other 
 information (like subscribing).
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bob Metelsky
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Imort Parameter File Question

2003-07-31 Thread DENNIS WILLIAMS

Jay
   I hope my reply didn't sound harsh. You are right, it is always a good
idea to briefly describe what you've tried since that will allow everyone to
make better use of their time. I was just trying to point out one of the
great benefits I've derived from the experts on this list (and I don't count
myself one of them by any means) is that they tend to think up quick,
ingenious tests. And I've learned something useful for import scripts
myself.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 
 


-Original Message-
Sent: Thursday, July 31, 2003 12:24 PM
To: Multiple recipients of list ORACLE-L


Dennis:

I have tested through most of the common formats already, that is why I
asked for help from the list.
Your advise about testing is noted, but in this case based on incorrect
assumptions.
I used most of the major comments in PL/SQL, Java, etc.
Though I missed trying the #, which per Barbara's reply seems to be the
correct one.
In my next posting I will make sure that I list all steps taken.

Barbara was nice though to forward  the below:

 $ more export_to_null.par
 #  ===
 #  export_to_null
 #  ===
 userid=sys/password
 file=/dev/null
 log=export_to_null.log
 direct=y
 compress=n



- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, July 31, 2003 12:49 PM


 Jay - I don't think the exp and imp parameter files have provision for a
 comment. But you could try common comment formats and see if you find one
 that works. The person who wrote the parser might have added that but it
 didn't end up in the documentation. I notice testing is a habit of the
more
 expert members of this list.

 Dennis Williams
 DBA, 80%OCP, 100% DBA
 Lifetouch, Inc.
 [EMAIL PROTECTED]


 -Original Message-
 Sent: Thursday, July 31, 2003 11:34 AM
 To: Multiple recipients of list ORACLE-L


 Hello:

 Does anyone know if you can create a comment in a import parameter file?

 If so could you provide a sample of the syntax.
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Jay
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: DENNIS WILLIAMS
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jay
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Oracle to MSSQL conversion?

: )

So an MS SQL server = an Oracle instance

An MS SQL database = (roughly speaking) an Oracle schema.

An MS SQL file set = (roughly speaking) an Oracle tablespace.

and data files are data files.

Is that correct?

What would be the point of installing two SQL Server servers on the same
box?  Similar to setting up 2 or more instances on one host?

Patrice.

-Original Message-
Sent: Thursday, July 31, 2003 2:14 PM
To: Multiple recipients of list ORACLE-L


An Oracle instance does not correlate to a SQL Server database.  

An Oracle instance is a running Oracle server, i.e., a set of
background processes and a System Global Area in memory.  It is what
permits applications to _access_ the database.  The database is on
disk, the instance in memory.

An Oracle _schema_ is analogous to a SQL Server database.

(BTW, what does v/r mean?)


--- Wolfe Stephen S GS-11 6 MDSS/SGSI [EMAIL PROTECTED]
wrote:
 Being more of a SQL 2000 DBA (I am experienced from SQL Server 6.5).
 
 At my installation I have 5 SQL-2000 database machines and recently
 acquired three Oracle 9i machines.
 
 The limit is essentially a function of your storage area and the
 amount
 of real memory available to the processor or processor array.
 
 I'm trying to draw similarities between the RDBM concepts now as I
 learn
 Oracle's idea of a database.
 
 Maybe now is a good time for me to ask these question since it is
 related to this thread's subject, can you say that an Oracle instance
 is
 essentially the same as a MSSQL database?  I ask this because a MSSQL
 server can support multiple databases which can be configured
 different
 ways.
 
 
 v/r
 
 Stephen S. Wolfe, GS-11, DAFC
 Data Services Manager
 [EMAIL PROTECTED]
 (813) 827-9974  DSN 651-9974
 
 
 
  -Original Message-
  From: Boivin, Patrice J [mailto:[EMAIL PROTECTED] 
  Sent: Thursday, July 31, 2003 7:59 AM
  To: Multiple recipients of list ORACLE-L
  Subject: RE: Oracle to MSSQL conversion?
  
  
  I have a question re. these conversions...
  
  If an Oracle database has 120 tablespaces, how does that 
  translate in MSSQL speak?
  
  (One of the tablespaces is USERS, home of dozens of schemas; 
  the others are either RB, SYSTEM, TEMP or application tablespaces)
  
  How many separate schemas-tablespaces can MSSQL hold per server?
  
  Patrice.
  
  -Original Message-
  Sent: Thursday, July 31, 2003 7:34 AM
  To: Multiple recipients of list ORACLE-L
  
  
  I know Microsoft is offering a new course called 'Microsoft 
  SQL Server 2000 for Experienced Database Professionals'.  It 
  is aimed at DBAs with experience with Oracle, DB2, Sybase 
  etc. who want to know more about SQL Server.
  
  You can read more about this course at 
  http://www.microsoft.com/traincert/syllabi/2723afinal.asp.
  
  Gudmundur
  
   Hello,
   
   There is alot of talk about multi-skilling/reskilling going
   on here at my company. We use Oracle and MSSQL dbs. 
   I have been wondering if anyone is aware of a resource that 
   shows the oracle programming technique and what the 
   corresponding MSSQL programming technique is. ie
   Oracle defines variable   : MSSQL defines variable
   Oracle cursor looks like this   : MSSQL cursor looks like this.
   Oracle uses rollbacks: MSSQL uses MSSQL rollbacks
   etc
   Hope you all understand what I mean.
   
   TIA
   Denham Eva
   Oracle DBA
   Linux like TeePee... No Windows, No Gates and Apache inside!
   
   
   __
   ___
   This e-mail message has been scanned for Viruses and Content
   and cleared 
   by MailMarshal
   
   For more information please visit www.marshalsoftware.com
   __
   ___
   
   ##
   ###
   Note:
   This message is for the named person's use only.  It may
   contain confidential, proprietary or legally privileged 
   information.  No confidentiality or privilege is waived or 
   lost by any mistransmission.  If you receive this message in 
   error, please immediately delete it and all copies of it from 
   your system, destroy any hard copies of it and notify the 
   sender.  You must not, directly or indirectly, use, disclose, 
   distribute, print, or copy any part of this message if you 
   are not the intended recipient. TFMC and any of its 
   subsidiaries each reserve the right to monitor all e-mail 
   communications through its networks.
   
   Any views expressed in this message are those of the
   individual sender, except where the message states otherwise 
   and the sender is authorized to state them to be the views of 
   any such entity.
   
   Thank You.
   --
   Please see the official ORACLE-L FAQ: http://www.orafaq.net
   -- 
   Author: Denham Eva
 INET: [EMAIL PROTECTED]
   
   Fat City Network Services-- 858-538-5051

RE: upgrade to 9i

2003-07-31 Thread Cunningham, Gerald

Mladen you're crackin me up, dude! That looks good except for the
reading part...

-Original Message-
Sent: Wednesday, July 30, 2003 12:19 PM
To: Multiple recipients of list ORACLE-L


No, that's the wrong way. The right way is to read first 3 pages, then
try it out, using your production database, naturally, and when it
fails, ask the questions on this list. Do not forget to put something
like *** NEED URGENT HELP *** in the message subject, because that
gives me an adrenaline rush.

On 2003.07.30 11:14, Freeman Robert - IL wrote:
 I'd also suggest that you read the migration guide before you do any 
 upgrade.
 
 RF
 
 -Original Message-
 To: Multiple recipients of list ORACLE-L
 Sent: 7/30/2003 8:09 AM
 
 See doc ID 214887.1
 
 -Original Message-
 Sent: Tuesday, July 29, 2003 5:54 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Hi
 where can I find steps ( procedure ) for upgrading from 8.1.7 to 9i .
 
 Thanks,
 -ak
 
 
 
 Privileged/Confidential information may be contained in this message. 
 The information contained in this message is intended only for the use

 of the recipient(s) named above and their co-workers who are working 
 on the same matter.
 
 
 The recipient of this information is prohibited from disclosing the 
 information to any other party unless this disclosure has been 
 authorized in advance.
 
 
 If you are not intended recipient of this message or any agent 
 responsible for delivery of the message to the intended recipient, you

 are hereby notified that any disclosure, copying, distribution or 
 action taken in reliance on the contents of this message is strictly 
 prohibited. You should immediately destroy this message and kindly 
 notify the sender by reply E-Mail.
 
 
 Please advise immediately if you or your employer does not consent to 
 Internet E-Mail for messages of this kind. Opinions, conclusions and 
 other information in this message that do not relate to the official 
 business of the firm shall be understood as neither given nor endorsed

 by it.
 
 
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Freeman Robert - IL
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in 
 the message BODY, include a line containing: UNSUB ORACLE-L (or the 
 name of mailing list you want to be removed from).  You may also send 
 the HELP command for other information (like subscribing).
 

-- 
Mladen Gogala
Oracle DBA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
message BODY, include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from).  You may also send the HELP
command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Cunningham, Gerald
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Viewing the trigger source code

If you look at the source of the ALL_TRIGGERS view (at least in 8i), you'll
see that the CREATE ANY TRIGGER priv is needed for a schema to see triggers
of another schema.  Since this probably isn't what you want, you have some
options:

1)  GRANT SELECT ON DBA_TRIGGERS TO your_schema;

2)  Reverse engineer the ALL_TRIGGERS view, removing the restriction and
calling it something else like OUR_TRIGGERS.  Put this view in a
non-SYS/non-SYSTEM DBA schema of yours and GRANT SELECT where necessary.

3)  Modify the ALL_TRIGGERS view directly, removing the restriction and
waiting for the appropriate rant from Mladen about not modifying the data
dictionary.  And I'd agree with him -- don't do this.

Enjoy!
Rich

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech Inc, Sussex, WI USA


 -Original Message-
 From: IT - Database (Do Not Use) 
 [mailto:[EMAIL PROTECTED]
 Sent: Thursday, July 31, 2003 2:59 PM
 To: Multiple recipients of list ORACLE-L
 Subject: Viewing the trigger source code
 
 
 My brain is not working todayI cannot figure out how to 
 allow one user
 to look at the source code (i.e. trigger_body) for a trigger owned by
 another user.  The fact that there is an all_triggers view leads me to
 believe that it must be possiblebut I can't figure out 
 how to do it and
 I have RTFM and I can't find any references there either.  
 Can anyone help
 me out?
 
 TIA
 Debbie
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

upgrade 805 to 8174, type#10 objects

2003-07-31 Thread Barbara Baker

List:
I'm testing an upgrade of a database from 8.0.5 to
8.1.7.4 (Solaris 2.6).  

I have 3 objects in the 8.0.5 database that are type#
10 in obj$.  The objects do not show up at all in
dba_objects.  The objects apparently came from someone
applying statspack to an 8.0.5 database.

8.0.5 doesn't care about these objects.  (As far as I
can tell, the objects have been in the database as
type# 10 for over a year with no complaints.)  8.1.7
cares a lot.  The upgrade to 8.1.7.0 causes crashes
due to these objects (bug 2143767) I can work around
this by adding event 10052 to init then patching up to
8.1.7.4   When I get to 8.1.7.4, there are messages in
my alert log about these objects.  Doesn't seem to
cause harm, but it's annoying.

Oracle (via tar) suggested forcing smon to clean up
the objects (oradebug wakeup).  This did not work.

There are no dependencies against these objects that I
can find.
(Note that the real views have different object
numbers.)

My question:  Can you think of any reason not to
delete the objects from obj$ before I start the
upgrade?  (I know deleting from obj$ is not a good
idea.  But I don't have any other ideas.)

Anything you think I might have overlooked that would
cause smon to NOT clean up these objects?

I really want a clean install on this one.
Thanks a bunch!
Barb

PL/SQL Release 8.0.5.2.0 - Production

SQL select owner, object_type, object_id,
object_name,
  2  status
  3  from dba_objects
  4  where object_name like
'V%$BUFFER_POOL_STATISTICS'
  5 or object_name like 'V%$TEMPFILE'
  6 or object_name like 'V%$TEMPSTAT'
  7  /

 OBJECTOBJECT
OWNERTYPE  ID OBJECT_NAME 
  STATUS
 -- -
-- ---
SYS  VIEW  288476 V_$TEMPFILE 
  VALID
SYS  VIEW  288474 V_$TEMPSTAT 
  VALID

SQL select owner, object_name, object_type,object_id
  2  from dba_objects
  3  where object_id=288485
  4  or object_id=288484
  5  or object_id=13885;

no rows selected

SQL select obj#, owner#,name, type#, status
  2  from obj$
  3  where obj#=288484
  4  or obj#=288485
  5  or obj#=13885;

  OBJ#  OWNER# NAME  TYPE# 
STATUS
-- ---  --
---
 13885   0 V$BUFFER_POOL_STATISTICS 10
  1
288485   0 V$TEMPSTAT   10
  1
288484   0 V$TEMPFILE   10
  1


SQL select * from dependency$ where d_obj#=13885 or
d_obj#=288484
  2or d_obj#=288485;

no rows selected



__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Barbara Baker
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: HELP! Index Debate!


Please help resolve this dispute. 
We have a query that runs over 5 hours.  Sections of the query are
listed below.

The table QOH_DAY_FACT table had only on index and that was on the
TIME_ID column.  I propose adding an index with PROD_ID, WHS_ID, LOT_ID,
WHS_LOC, TIME_ID and QUALITY_ID.  My test shows the runtime was reduced
to about 1.5 hours. 

The developer said all the columns in the index except PROD_ID were
being ignored.  He says there should be six separate indexes, one for
each column before Oracle will use them.

Also, does the order of the columns in the index have to match the order
of the columns in the WHERE CLAUS or is it more important to match the
WHERE CLAUS to the data content (least number of rows first)?

I will be running more tests, but I would like some input on this if
anyone has an opinion.

Thanks!
Ron


select T1.COUNTRY_NAME c1
  , T2.PRODTN_PROC_NAME c2
  , T2.PLANT_NAME c3
  , T1.WHS_NAME c4
  , T1.WHS_CMPLX_NAME c5
  , T3.WHS_LOC_NAME c6
  , T4.GRADE_DESC c7
  , T4.PACK_DESC c8
  , T5.FULL_DT c9
  , T6.QOH_MT c10...

from DWMART.DISTRIB_FCLTY_DIM T1
  , DWMART.MFG_FCLTY_DIM T2
  , DWMART.DISTRIB_LOC_DIM T3
  , DWMART.TIME_DIM T5
  , DWMART.QUALITY_DIM T7
  , DWMART.QOH_DAY_FACT T6
  , DWMART.PROD_DIM T4 
where T6.PROD_ID=T4.PROD_ID(+)
   and T6.WHS_ID=T1.WHS_ID
   and T6.LOT_ID=T2.LOT_ID
   and T6.WHS_LOC_ID=T3.WHS_LOC_ID
   and T6.TIME_ID=T5.TIME_ID
   and T6.QUALITY_ID=T7.QUALITY_ID 
order by c9 asc
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Smith, Ron L.
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: HELP! Index Debate!

Title: RE: HELP! Index Debate!





How does one know that only one column is being used in an index and others are being ignored ... ?? This is new to me.


Raj

Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !



-Original Message-
From: Smith, Ron L. [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 31, 2003 4:34 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: HELP! Index Debate!




Please help resolve this dispute. 
We have a query that runs over 5 hours. Sections of the query are
listed below.


The table QOH_DAY_FACT table had only on index and that was on the
TIME_ID column. I propose adding an index with PROD_ID, WHS_ID, LOT_ID,
WHS_LOC, TIME_ID and QUALITY_ID. My test shows the runtime was reduced
to about 1.5 hours. 


The developer said all the columns in the index except PROD_ID were
being ignored. He says there should be six separate indexes, one for
each column before Oracle will use them.


Also, does the order of the columns in the index have to match the order
of the columns in the WHERE CLAUS or is it more important to match the
WHERE CLAUS to the data content (least number of rows first)?


I will be running more tests, but I would like some input on this if
anyone has an opinion.


Thanks!
Ron



select T1.COUNTRY_NAME c1
 , T2.PRODTN_PROC_NAME c2
 , T2.PLANT_NAME c3
 , T1.WHS_NAME c4
 , T1.WHS_CMPLX_NAME c5
 , T3.WHS_LOC_NAME c6
 , T4.GRADE_DESC c7
 , T4.PACK_DESC c8
 , T5.FULL_DT c9
 , T6.QOH_MT c10...


from DWMART.DISTRIB_FCLTY_DIM T1
 , DWMART.MFG_FCLTY_DIM T2
 , DWMART.DISTRIB_LOC_DIM T3
 , DWMART.TIME_DIM T5
 , DWMART.QUALITY_DIM T7
 , DWMART.QOH_DAY_FACT T6
 , DWMART.PROD_DIM T4 
where T6.PROD_ID=T4.PROD_ID(+)
 and T6.WHS_ID=T1.WHS_ID
 and T6.LOT_ID=T2.LOT_ID
 and T6.WHS_LOC_ID=T3.WHS_LOC_ID
 and T6.TIME_ID=T5.TIME_ID
 and T6.QUALITY_ID=T7.QUALITY_ID 
order by c9 asc
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Smith, Ron L.
 INET: [EMAIL PROTECTED]


Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).



*This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*1

RE: HELP! Index Debate!

Title: Message

No
answer for that.

-Original Message-From: Jamadagni,
Rajendra [mailto:[EMAIL PROTECTED] Sent: Thursday, July
31, 2003 3:44 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: HELP! Index Debate!
How does one know that only one column is being used in an
index and others are being ignored ... ?? This is new to me.
Raj
Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art
!
-Original Message- From:
Smith, Ron L. [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 31, 2003 4:34 PM To:
Multiple recipients of list ORACLE-L Subject: RE:
HELP! Index Debate!
Please help resolve this dispute. We
have a query that runs over 5 hours. Sections of the query are
listed below.
The table QOH_DAY_FACT table had only on index and that was on
the TIME_ID column. I propose adding an index
with PROD_ID, WHS_ID, LOT_ID, WHS_LOC, TIME_ID and
QUALITY_ID. My test shows the runtime was reduced to about 1.5 hours.
The developer said all the columns in the index except PROD_ID
were being ignored. He says there should be six
separate indexes, one for each column before Oracle
will use them.
Also, does the order of the columns in the index have to match
the order of the columns in the WHERE CLAUS or is it
more important to match the WHERE CLAUS to the data
content (least number of rows first)?
I will be running more tests, but I would like some input on
this if anyone has an opinion.
Thanks! Ron
select T1."COUNTRY_NAME" "c1" ,
T2."PRODTN_PROC_NAME" "c2" , T2."PLANT_NAME"
"c3" , T1."WHS_NAME" "c4" , T1."WHS_CMPLX_NAME" "c5" ,
T3."WHS_LOC_NAME" "c6" , T4."GRADE_DESC"
"c7" , T4."PACK_DESC" "c8" , T5."FULL_DT" "c9" , T6."QOH_MT"
"c10"...
from "DWMART"."DISTRIB_FCLTY_DIM" T1 , "DWMART"."MFG_FCLTY_DIM" T2 ,
"DWMART"."DISTRIB_LOC_DIM" T3 ,
"DWMART"."TIME_DIM" T5 , "DWMART"."QUALITY_DIM"
T7 , "DWMART"."QOH_DAY_FACT" T6
, "DWMART"."PROD_DIM" T4 where
T6."PROD_ID"=T4."PROD_ID"(+) and
T6."WHS_ID"=T1."WHS_ID" and
T6."LOT_ID"=T2."LOT_ID" and
T6."WHS_LOC_ID"=T3."WHS_LOC_ID" and
T6."TIME_ID"=T5."TIME_ID" and
T6."QUALITY_ID"=T7."QUALITY_ID" order by "c9"
asc -- Please see the official
ORACLE-L FAQ: http://www.orafaq.net --
Author: Smith, Ron L.
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego,
California -- Mailing list and web
hosting services -
To REMOVE yourself from this mailing list, send an E-Mail
message to: [EMAIL PROTECTED] (note EXACT spelling
of 'ListGuru') and in the message BODY, include a line
containing: UNSUB ORACLE-L (or the name of mailing
list you want to be removed from). You may also
send the HELP command for other information (like subscribing).

RE: ** find whether table or index being accessed

2003-07-31 Thread DENNIS WILLIAMS

A - For tables, you can turn on auditing. If you are on Oracle9i, there is a
monitoring feature for indexes you can turn on.



Dennis Williams 
DBA, 80%OCP, 100% DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

-Original Message-
Sent: Thursday, July 31, 2003 12:49 PM
To: Multiple recipients of list ORACLE-L


Hi,
   Is there an easy way to find out if a table or an index is being used. I
mean short of going thru all code or keeping looking at v$sqlarea. I mean
even if code is covered there are always ad hoc SQL queries etc. Same for
other objects like views etc. Is there a place where oracle stores objects
accessed and any other related info.
 
Thanks
 
 



  _  

Do you Yahoo!?
Yahoo!  http://us.rd.yahoo.com/evt=10469/*http://sitebuilder.yahoo.com
SiteBuilder - Free, easy-to-use web site design software

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: HELP! Index Debate!

2003-07-31 Thread Ron Rogers

Ron,
 It has been my understanding that in order for the conpound index to
be used the query had to match the order the index was created. Multiple
indexes would not do a whole lot of good for you just make the optmizer
work harder to figure things out. It would add a confusion factor other
wise how would there be a relationship between each column in the index.
 An Index on column col1 and a second index on col2 would have a
different tree that an index on col1,col2.
 With the additional index (compound or not) on the PROD_ID the
execution time will decrease as it will use the index scan for the join
condition in the where clause T6.PROD_ID=T4.PROD_ID(+) . Before
there was no index and the full table scan resulted.
 Looking at the where clause and in this case the developer might be
correct as the where clause referres to the T6 table = to multiple other
tables different columns.
Ron

 [EMAIL PROTECTED] 07/31/03 04:34PM 

Please help resolve this dispute. 
We have a query that runs over 5 hours.  Sections of the query are
listed below.

The table QOH_DAY_FACT table had only on index and that was on the
TIME_ID column.  I propose adding an index with PROD_ID, WHS_ID,
LOT_ID,
WHS_LOC, TIME_ID and QUALITY_ID.  My test shows the runtime was
reduced
to about 1.5 hours. 

The developer said all the columns in the index except PROD_ID were
being ignored.  He says there should be six separate indexes, one for
each column before Oracle will use them.

Also, does the order of the columns in the index have to match the
order
of the columns in the WHERE CLAUS or is it more important to match the
WHERE CLAUS to the data content (least number of rows first)?

I will be running more tests, but I would like some input on this if
anyone has an opinion.

Thanks!
Ron


select T1.COUNTRY_NAME c1
  , T2.PRODTN_PROC_NAME c2
  , T2.PLANT_NAME c3
  , T1.WHS_NAME c4
  , T1.WHS_CMPLX_NAME c5
  , T3.WHS_LOC_NAME c6
  , T4.GRADE_DESC c7
  , T4.PACK_DESC c8
  , T5.FULL_DT c9
  , T6.QOH_MT c10...

from DWMART.DISTRIB_FCLTY_DIM T1
  , DWMART.MFG_FCLTY_DIM T2
  , DWMART.DISTRIB_LOC_DIM T3
  , DWMART.TIME_DIM T5
  , DWMART.QUALITY_DIM T7
  , DWMART.QOH_DAY_FACT T6
  , DWMART.PROD_DIM T4 
where T6.PROD_ID=T4.PROD_ID(+)
   and T6.WHS_ID=T1.WHS_ID
   and T6.LOT_ID=T2.LOT_ID
   and T6.WHS_LOC_ID=T3.WHS_LOC_ID
   and T6.TIME_ID=T5.TIME_ID
   and T6.QUALITY_ID=T7.QUALITY_ID 
order by c9 asc
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Smith, Ron L.
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ron Rogers
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: If you replied... Optimizer Mode question with regard v$sqlar

2003-07-31 Thread Johnson, Michael



 All my e-mail was sys$hosed last night so could you please resend any and
 all responses to this since last night.
 
 Anybody run into a situation where you see optimizer_mode equal
 multiple_children_present  when the optimizer_mode is set to choose in the
 init*.ora file  ?
 
 If so,  did you follow up on it and try and determine why this was the
 case and your results ?   There is very little information on Metalink
 regarding this issue.
 
 Thank you for your time in advance.
 
 Mike
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Johnson, Michael 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: HELP! Index Debate!