RE: Where 1 = 1

[Iulian . ILIES]

I sometime used this kind of aproach when I dinamically build the WHERE
expression.
Something like this:

where_condition := ' WHERE 1 = 1 '
LOOP
   where_condition := ' AND ' || new_condition
END LOOP
The point is if there are any condition to add the first condition is always
true so it won't affect the final where_condition. The same is when there
aren't any condition to add. 
And in some cases there are really no conditions to add, thus your final
query will have only a condition like ' WHERE 1 = 1 '. 

If you need to connect all the intermediate condition by OR operator
probably you will use the 
WHERE 1 = 0.

I hope I'll make my point clear enough and of course is any related to your
case. Maybe if you show us the entire query, someone can tell you more about
it.

Regards 
Iulian Ilies



-Original Message-
Sent: Friday, October 26, 2001 2:20 AM
To: Multiple recipients of list ORACLE-L


**
This email has been tested for viruses by F-Secure Antivirus
administered by IT Network Department.
**

I was monitoring a load test of my company's new
application when I came across something interesting. 
One of the more monstrous queries had the following as
part of its WHERE clause: 'AND 1 = 1'

Has anyone seen this used before?  What is it supposed
to achieve?  

__
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ed Bittel
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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 is confidential and 
may be legally privileged. It is intended solely for the use of the 
individual or entity to whom it is addressed and others authorised to 
receive it. If you are not the intended recipient you are hereby 
notified that any disclosure, copying, distribution or taking action in 
reliance of the contents of this information is strictly prohibited and 
may be unlawful. Mobil Rom is neither liable for the proper, complete 
transmission of the information contained in this communication nor 
any delay in its receipt.
**
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Instance Name in Sql Prompt

[nlzanen1]

Hi,


To overcome the connect within a session not changing the prompt  a created
a script (connect.sql) and put it in the directory from SQL_PATH registry
entry. When I want to change the connection i type @connect i.s.o connect



accept username prompt "Type username :";
accept password prompt "Type Password (hidden) :" hide;
accept sid prompt "Type instance name (SID) :";
connect &username/&password@&sid;
@d:\oracle\ora80\Plus80\glogin.sql;
undefine username;
undefine password;
undefine sid;
rem CLEAR SCREEN;


Jack




"Ramon Estevez" <[EMAIL PROTECTED]>@fatcity.com on 25-10-2001
22:15:21

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


To:   Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL)

Thanks to Kevin and all that reply.

I noticed when doing a connect inside a session.

This will help.

Ramon E. Estevez
[EMAIL PROTECTED]
Dominican Republic
809-565-3121
 -Mensaje original-
 De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Kevin Lange
 Enviado el: Thursday, 25 October, 2001 11:10 AM
 Para: Multiple recipients of list ORACLE-L
 Asunto: RE: Instance Name in Sql Prompt

 Ramon;
   In your startup directory on SQL Plus, you can automatically run a
 script that will setup the environment like you want it.  Its called
 LOGIN.SQL.

 Here is a copy of mine:

 set termout on
 set pagesize 0
 set echo off
 set feedback off
 set sqlprompt ''
 spool c:\temp.sql
 select 'set sqlprompt '''||name||' > '';' from v$database;
 spool off
 @c:\temp.sql
 set pagesize 35
 set feedback on
 set termout off
 What this does is to take the name of the database from v$database and
 create a temporary SQL file, then runs it.  This will set my prompt to

 INSTANCE_NAME >

 where INSTANCE_NAME is the name of the database.

 For example, if I log onto DEV then the SQLPROMPT will be

 DEV >

 Hope you can use it.

 Kevin

 p.s. ...  Remember that  this only works for the initialization of SQL
 Plus.  If you do a connect inside of your session then the prompt will
 not change.
  -Original Message-
  From: Ramon Estevez [mailto:[EMAIL PROTECTED]]
  Sent: Thursday, October 25, 2001 9:35 AM
  To: Multiple recipients of list ORACLE-L
  Subject: Instance Name in Sql Prompt

  Hi Friends,

  Excuse me for this dumb question,  how do I display the instance
  name in the
  sql prompt.  Have 3 DB and would like to know to which one I am
  connected.

  I mean something like that.

  DBA1 >
  DBA2 >
  DB01 >

  Regards,

  Ramon E. Estevez
  [EMAIL PROTECTED]
  Dominican Republic
  809-565-3121




=
De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
uitsluitend bestemd voor de geadresseerde. Openbaarmaking,
vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan
derden is, behoudens voorafgaande schriftelijke toestemming van Ernst &
Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en
volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch
voor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen dat een
verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten
worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden.

Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u
vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender
en het origineel en eventuele kopieën te verwijderen en te vernietigen.

Ernst & Young hanteert bij de uitoefening van haar werkzaamheden algemene
voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De
algemene voorwaarden worden u op verzoek kosteloos toegezonden.
=
The information contained in this communication is confidential and is
intended solely for the use of the individual or entity to whom it is
addressed. You should not copy, disclose or distribute this communication
without the authority of Ernst & Young. Ernst & Young is neither liable for
the proper and complete transmission of the information contained in this
communication nor for any delay in its receipt. Ernst & Young does not
guarantee that the integrity of this communication has been maintained nor
that the communication is free of viruses, interceptions or interference.

If you are not the intended recipient of this communication please return
the communication to the sender and delete and destroy all cop

RE: Speaking the same language

[Robertson Lee - lerobe]

Mark,

If you do get anything I would love a copy please.

Hemmed in by the SQLServer is cheaper brigade.

-Original Message-
Sent: 25 October 2001 18:00
To: Multiple recipients of list ORACLE-L


Hi Djordje,

You are right in saying that the terminology within SQLServer and Sybase are
very similar - in fact I don't know of any differences.. They are both bred
from the same monster back in the days of Ashton Tate :)

I would make one change with your list:

In SQLServer and Sybase, an Oracle Tablespace is called a Database, not a
filegroup. So an Oracle schema is not a Database.

=
Oracle  SqlServer
DB2 Sybase
=
DatabaseServer
Sys schema  Primary File group
Tablespace  Database
SYSTEM tablespace   Master database
other schemas   "Data" File group
Temp tablespace TempDB database
Redo log file   Log file
Database block  Page
Extent  Extent (8 pages -> 64K).
(multiple of blocks)Can be shared by logical objects.
SessionsProcesses
Data dictionary System catalogue
=
Data dictionary views   System catalogue tables
=
dba_objects sysobjects
dba_tab_columns syscolumns
dba_indexes sysindexes
dba_users   sysusers
dba_data_files  sysfiles
v$lock  syslocks
v$session   sysprocesses

There are a few more, but they don't jump to mind at the moment, and I'm off
home now to spend some time with my little girl :)

I'd be interested in a more complete list if you do come up with one. Maybe
I could post it to a web site? hmmm..

HTH

Mark

-Original Message-
Jankovic
Sent: Wednesday, October 24, 2001 23:10
To: Multiple recipients of list ORACLE-L


We need to communicate inside a team made of DBAs that support different
database platforms: oracle, sql*server, Sybase, adabase (Am I wrong that
sql*server and sybase terminology is pretty much the same?).  There are some
terminology differences between different databases (to start with the word
"database" that means different in oracle and sql*server world).  I have
tried to compile a start terminology difference list.  If you could
contribute to the list you can send an e-mail to me directly, I would
compile the list and send the compiled version to the list.  If you don't
hear back from me that probably means that the list was not very responsive
:-(.  Also, please let me know if you think some terminology is wrong in
this list.

Thanks.

Djordje Jankovic
[EMAIL PROTECTED]


Oracle  SqlServer
DB2

DatabaseServer
Schema  Database
Sys schema  Master database
Tablespace  File group
SYSTEM tablespace   Primary data file
other tablespaces   Secondary data files
Redo log file   Log file
Database block  Page
Extent  Extent (8 pages -> 64K).
(multiple of blocks)  Can be shared by logical objects.
Data dictionary System catalog


Data dictionary views   System catalog tables
dba_objects sysobjects
dba_tab_columns syscolumns
dba_indexes sysindexes
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Djordje Jankovic
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Mark Leith
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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 is
confidential, is intended only for the use of th

RE: Move tablespace with no downtime?

[Jeremiah Wilton]

Yeah seems like a moot point.  Why would you try this with tempfiles
anyway?  With tempfiles you just add and drop to your heart's content.

Any kind of maintenance you might want to do to a temporary
tablespace, regardless of the file type used, can be easily
accomplished without downtime, by creating a second temporary
tablespace and assigning all the users to it while you make any
changes to the original one.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Thu, 25 Oct 2001, [iso-8859-1] Connor McDonald wrote:

> True - but with tempfiles that is just about
> instantaneous anyway.
>
>  --- Glenn Travis <[EMAIL PROTECTED]> wrote: > FYI:
>  This will not work with TEMP tablespaces which
> > are locally managed.  You must drop the tablespace
> > and recreate it with the new filename.  Check
> > Metalink - it is documented that temporary datafiles
> > (tempfiles) cannot be renamed.
> >
> > > -Original Message-
> > > From: Jeremiah Wilton
> > [mailto:[EMAIL PROTECTED]]
> > > Sent: Thursday, October 25, 2001 11:40 AM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: Re: Move tablespace with no downtime?
> > >
> > >
> > > Here's a trick I like to reduce the downtime
> > associated with moving
> > > large datafiles:
> > >
> > > 1. Place the tablespace that contains the file(s)
> > you want to move
> > >into backup mode:
> > >- alter tablespace  begin backup;
> > >
> > > 2. Copy the file(s):
> > >- cp  
> > >- If you are moving multiple files, you can do
> > this in parallel
> > >
> > > 3. Take the tablespace out of backup mode:
> > >- alter tablespace  end backup;
> > >
> > > 4. (Now the very brief downtile begins)
> > >Take the tablespace offline immediate
> > >- alter tablespace  offline immediate;
> > >
> > > 5. Issue the rename:
> > >- alter database rename file  to
> > ;
> > >
> > > 6. Recover the new file(s) or the whole tablespace
> > (should be quite
> > >brief)
> > >- recover [datafile|tablespace] ;
> > >
> > > 7. (Now the very brief downtime ends)
> > >Bring the tablespace online again:
> > >- alter tablespace  online;
> > >
> > > --
> > > Jeremiah Wilton
> > > http://www.speakeasy.net/~jwilton
> > >
> > > On Thu, 25 Oct 2001, Rachel Carmichael wrote:
> > >
> > > > depends on what you mean by downtime.
> > > >
> > > > yes you can do it without taking down the
> > database and the instance,
> > > > no, you can't do it without at least taking the
> > tablespace offline.
> > > >
> > > > alter tablespace x offline;
> > > > in os, make a copy of all datafiles in the new
> > location
> > > > alter database move file 'y' to 'z';
> > > >   
> > > > alter tablespace online;
> > > >
> > > >
> > > > --- Greg Moore <[EMAIL PROTECTED]> wrote:
> > > > > Can I move a tablespace and all it's
> > associated datafiles to a new
> > > > > disk
> > > > > device with no downtime?

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

date format in ksh

[Suhen Pather]

List,

 

Sorry to deviate from the topic, but

I am writing a korn shell script that would exit if the date
format is

incorrect.

 

I just need something to compare the date format passed  in with DD-MON-.

 

Eg. 

I am passing an argument to my ksh script being the date.

If the date is in any other format but DD-MON- the ksh
must exit.

 

Eg.  sh test.ksh 02/05/1999

 

It must exit.

 

The only format excepted should be 

sh test.ksh 02-MON-

 

TIA

 

Regards

Suhen

 

 

RE: Unable to rebuild database from hot backup

[Johnston, Tim]

Title: RE: Unable to rebuild database from hot backup





My understanding the when you perform a "recover database using backup controlfile", the stop SCN in the controlfile is set to infinity...  Therefore, you never "finish" media recovery since you never encounter the stop SCN...  You can not simply cancel a "recover database using backup controlfile" since Oracle is expecting you perform a complete recovery ( since your not using the UNTIL CANCEL/TIME/CHANGE ) and canceling a complete recovery leaves the stop SCN in the controlfile at infinity...  Therefore, the recovery is never complete and you will always receive the "needs media recovery message"...  But, if you "recover using backup controlfile until cancel" and then cancel, that is the signal to Oracle that your are performing an incomplete recovery and the stop SCN in the controlfile is set to the SCN you have recovered through...  At this point you can do an alter open resetlogs to open the database ( as long as you have applied enough logs to insure a consistent database )...

Tim


-Original Message-
From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 10:15 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Unable to rebuild database from hot backup



maybe the problem was never in the file but in the controlfile in the
backup?


standby assumes that the scn in the datafile header will be out of date
and that you will be recovering up to or past the scn in the standby
controlfile and that that is okay.



--- "Miller, Jay" <[EMAIL PROTECTED]> wrote:
> Another piece of information:
> 
> On the basis of "it couldn't hurt to try" I recopied everything but
> instead
> of using the regular control file I used the standby control file.  I
> then
> mounted it in standby mode, issued the recover standby database
> command,
> activated the standby, shutdown, and opened the database.  It worked
> fine.
> 
> Why would it work with a standby controlfile and not with the regular
> control file?  I have my QC database working but I'm really puzzled.
> 
> Jay Miller
> 
> -Original Message-
> Sent: Thursday, October 25, 2001 7:05 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Okay, this is weird.
> 
> I'm trying to rebuilding my QC database from a hot backup.  As
> always, I
> copied all the hot backup files, all the archive logs from the period
> of the
> hot backup and the control files.
> 
> After doing
> recover database using backup controlfile;
> 
> I got 
> SVRMGR> alter database open resetlogs;
> alter database open resetlogs
> *
> ORA-01113: file 1 needs media recovery
> ORA-01110: data file 1: '/data1/nyccp/systnyccp.dbf
> 
> Thinking that perhaps I just needed to apply more logs I went on to
> apply
> another 12 hours worth of archive logs.  I still get the same error. 
> 
> 
> Now I'm really concerned that my hot backup is invalid for some
> reason.
> Does anyone have any suggestions for what else I can look at?
> 
> TIA,
> Jay Miller
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Miller, Jay
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California    -- Public Internet access / Mailing
> Lists
> 
> 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.com
> -- 
> Author: Miller, Jay
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California    -- Public Internet access / Mailing
> Lists
> 
> 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!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    -- Public Internet access / Mailing Lists

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, inclu

Re: Where 1 = 1

[Jeff Herrick]

Hi Ed

It's useful in when generating DML on the fly and you
don't have the inclination or the ability to determine
if there are any other user-supplied (or otherwise generated)
predicates or where/when the last predicate has been
found. i.e.

1) Generate first part of Select (select foo from bar)
2) determine if there is at least one predicate and output 'WHERE'
3) loop thru predicates (from another table or a list box
   construct)
4) tack on the 'AND 1=1;' if you did step 3
5) prepare and execute the DML

HTH

Jeff Herrick
Jeff Herrick & Associates



On Thu, 25 Oct 2001, Ed Bittel wrote:

> I was monitoring a load test of my company's new
> application when I came across something interesting. 
> One of the more monstrous queries had the following as
> part of its WHERE clause: 'AND 1 = 1'
> 
> Has anyone seen this used before?  What is it supposed
> to achieve?  
> 

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Unable to rebuild database from hot backup

[Rachel Carmichael]

maybe the problem was never in the file but in the controlfile in the
backup?

standby assumes that the scn in the datafile header will be out of date
and that you will be recovering up to or past the scn in the standby
controlfile and that that is okay.


--- "Miller, Jay" <[EMAIL PROTECTED]> wrote:
> Another piece of information:
> 
> On the basis of "it couldn't hurt to try" I recopied everything but
> instead
> of using the regular control file I used the standby control file.  I
> then
> mounted it in standby mode, issued the recover standby database
> command,
> activated the standby, shutdown, and opened the database.  It worked
> fine.
> 
> Why would it work with a standby controlfile and not with the regular
> control file?  I have my QC database working but I'm really puzzled.
> 
> Jay Miller
> 
> -Original Message-
> Sent: Thursday, October 25, 2001 7:05 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Okay, this is weird.
> 
> I'm trying to rebuilding my QC database from a hot backup.  As
> always, I
> copied all the hot backup files, all the archive logs from the period
> of the
> hot backup and the control files.
> 
> After doing
> recover database using backup controlfile;
> 
> I got 
> SVRMGR> alter database open resetlogs;
> alter database open resetlogs
> *
> ORA-01113: file 1 needs media recovery
> ORA-01110: data file 1: '/data1/nyccp/systnyccp.dbf
> 
> Thinking that perhaps I just needed to apply more logs I went on to
> apply
> another 12 hours worth of archive logs.  I still get the same error. 
> 
> 
> Now I'm really concerned that my hot backup is invalid for some
> reason.
> Does anyone have any suggestions for what else I can look at?
> 
> TIA,
> Jay Miller
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Miller, Jay
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> 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.com
> -- 
> Author: Miller, Jay
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> 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!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Unable to rebuild database from hot backup

[Johnston, Tim]

Title: RE: Unable to rebuild database from hot backup





Hi Jay,


  When you perform a "recover database using backup controlfile" you are performing an incomplete recovery...  Do a recover database using backup controlfile until cancel...  Cancel...  Then open resetlogs...

Tim


-Original Message-
From: Miller, Jay [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 7:05 PM
To: Multiple recipients of list ORACLE-L
Subject: Unable to rebuild database from hot backup



Okay, this is weird.


I'm trying to rebuilding my QC database from a hot backup.  As always, I
copied all the hot backup files, all the archive logs from the period of the
hot backup and the control files.


After doing
recover database using backup controlfile;


I got 
SVRMGR> alter database open resetlogs;
alter database open resetlogs
*
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/data1/nyccp/systnyccp.dbf


Thinking that perhaps I just needed to apply more logs I went on to apply
another 12 hours worth of archive logs.  I still get the same error.  


Now I'm really concerned that my hot backup is invalid for some reason.
Does anyone have any suggestions for what else I can look at?


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


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    -- Public Internet access / Mailing Lists

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: URGENT -- db already exist ???

[DBarbour]

Gotta love Microsoft.  Here's some instructions I got off this list from
"Novice DBA" a while back on how to properly delete an Oracle Database on
NT/2000:

Clearing up the System after an incomplete or improper installation of
Oracle


-

Database Installation involves a set of procedures which need to be
followed
in order to have a proper working installation. If we follow these
procedures the Installation will be fine and usually problems related to
improper installation do not arise. But it is not always possible to get a
proper installation for the first time. This document is a troubleshooting
guide which would help to clear off the mess created by an improper
installation in a WindowsNT system.

First we need to know that During installation Oracle writes into certain
directories (which we would have specified during installation) and also
into the WindowsNT registry. WindowsNT registry is a repository of
information about all the installed products and configurations on that
system. When we are installing Oracle a directory is created in the
registry
which is name oracle which is present in the HKEY_LOCAL_MACHINE/SOFTWARE/

In the case of an improper installation the problems faced are
· We may not be able to uninstall the incomplete installation
· We may succeed in uninstalling the incomplete installation but yet face
problems with WindowsNT Services.
· Every time we log into WindowsNT we may get an error 'at least one system
service failed to start' which may be an Oracle service from the earlier
installation.
· We may get an error while creating a database 'the database with the name
you specified already exists please chose another name' which again may be
attributed to an improper un-installation.(I am not pretty  comfortable
with
the Oracle's Un-installation utility because I feel it does not uninstall
everything)


Keeping the above points in mind it would be better if we know where
exactly
to look in case we are faced with such problems. When oracle is installed
it
makes entries in the following places
1. The first and the foremost- the directory in which we install the Oracle
database (say D:\Ora8i)
2. The second is the inventory it maintains in the directory c:\program
files\oracle
3. The third HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE in the registry
4. The other place is HKEY_LOCAL_MACHINE/SYSTEM . Inside this entry there
are three nodes controlset1,controlset2 and currentcontrolset. These nodes
in turn have 4 nodes out of which 2 are important to us. They are Enum and
Services. The Enum node has got two nodes out of which the 'root' node is
of
great interest to us because it stores details about all the services that
are running on a WindowsNT system. The other node of interest from the
controlsets is Services. The services node has got a list of services
running on a WindowsNT system.

In case we need to clean up the system after an incomplete installation we
can follow the following steps
Delete the home directory where Oracle is installed
Delete the folder C:\program files\oracle Note:- This clears off
information
about any other Oracle utility installed on that system.
Delete the registry entry HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE Warning:- This
clears off information about any other Oracle utility installed on that
system and you may not be able to run those programs again.
Delete the Oracle Related services from
HKEY_LOCAL_MACHINE/SYSTEM/CONTROLSETx/ENUM/ROOT/ . They will be named with
a
prefix LEGACY_ORACLE... Note:- You will have to use regedt32.exe to invoke
registry editor and not regedit. You will have to use the security menu and
give permissions to yourself before deleting these entries. Else it will
not
work . It is to be noted that there are three control sets and all the
three
(in reality any 2) need to be cleared off these un-necessary entries.
Delete the Oracle Related services from
HKEY_LOCAL_MACHINE/SYSTEM/CONTROLSETx/SERVICES . They will have a prefix
'Oracle'.



I have also attached a document  having the same contents
Jared will this get a chance ??
joking??
coz
I am a
novice

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002


   

Leslie Lu  

   
ahoo.com>cc:   

Sent by: Subject: URGENT -- db already exist ???   

[EMAIL PROTECTED] 

om 

RE: Unable to rebuild database from hot backup

[DBarbour]

I'm not sure if the error Jay is getting can be caused by this, but I got
bit by it way back - make sure the tablespace that the file is for was
taken out of backup mode.  If it wasn't, you can apply redo logs all day
long and it will never become current.

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002


   

John Kanagaraj 

   
[EMAIL PROTECTED]>   cc:   

Sent by: Subject: RE: Unable to rebuild database 
from hot backup   
[EMAIL PROTECTED] 

om 

   

   

10/25/2001 

06:55 PM   

Please respond 

to ORACLE-L

   

   





Jay,

It is reasonable to assume that your hot backup is NOT ok ;-)

This is *possibly* because this particular file (or maybe more files to
come) wasn't backed up for a while. Can you look at the timestamp of this
file (and other files) in the backup that you restored? That should give
you
a clue... I think this is what's happening here: Oracle needs to make sure
as many logs as needed should be applied to this 'old' file so that the SCN
on this particular file matches the latest one found in the system.dbf, so
you need to keep applying from that point in time until now Another
clue
is to trace your archive logs - look at the one that you started applying.
The time on that one is probably the time that your backup of that
particular file became invalid

Hth,
John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

Listen to great commercial-free christian music 24x7 at www.klove.com

** The opinions and statements above are entirely my own and not
those of my employer or clients **




> -Original Message-
> From: Miller, Jay [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 25, 2001 4:05 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Unable to rebuild database from hot backup
>
>
> Okay, this is weird.
>
> I'm trying to rebuilding my QC database from a hot backup.
> As always, I
> copied all the hot backup files, all the archive logs from
> the period of the
> hot backup and the control files.
>
> After doing
> recover database using backup controlfile;
>
> I got
> SVRMGR> alter database open resetlogs;
> alter database open resetlogs
> *
> ORA-01113: file 1 needs media recovery
> ORA-01110: data file 1: '/data1/nyccp/systnyccp.dbf
>
> Thinking that perhaps I just needed to apply more logs I went
> on to apply
> another 12 hours worth of archive logs.  I still get the same error.
>
> Now I'm really concerned that my hot backup is invalid for
> some reason.
> Does anyone have any suggestions for what else I can look at?
>
> TIA,
> Jay Miller
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Miller, Jay
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> 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.com
--
Author: John Kanagaraj
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
--

Where 1 = 1

[Ed Bittel]

I was monitoring a load test of my company's new
application when I came across something interesting. 
One of the more monstrous queries had the following as
part of its WHERE clause: 'AND 1 = 1'

Has anyone seen this used before?  What is it supposed
to achieve?  

__
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ed Bittel
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Classes

[Rachel Carmichael]

I know Cary is signed up to teach on the geek cruise next year (May 2-9
out of San Diego). Gaja will also be there, I know they are trying to
get Craig and I think Don Burleson is signed up? (Him I'm not sure of).


--- Greg Moore <[EMAIL PROTECTED]> wrote:
> Classes by Cary Millsap (hotsos.com) or Craig Shallahamer
> (orapub.com) would
> be pretty cool.  These two guys are on the cutting edge of Oracle
> performance tuning.
> 
> Millsap's classes appear to be oriented toward his online service,
> which
> they charge for.  I have no idea how valuable is class would be if
> your
> company decided not to pay for his service.
> 
> Craig's classes focus on his toolset, which is available free.
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Greg Moore
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> 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!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: INITRANS storage parameter

[Kimberly Smith]

Look up the alter table command and see.  If its there then you should
be able to, providing no one is actively using the table.

-Original Message-
Sent: Thursday, October 25, 2001 4:10 PM
To: Multiple recipients of list ORACLE-L


Hi,

I have 8.1.7.1 running on HP-UX.  One of my table is heavily being updated
and I see blocking locks.  I have recalled that if I change the INITRANS
value from 1 to 2, the blocking locks should go away.  Question I have is
can I modify it in the fly without dropping and recreating the table.

Thanks
Bing

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Wong, Bing
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Kimberly Smith
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Unable to rebuild database from hot backup

[Kimberly Smith]

Looks like to me you want to put a until cancel on your recover clause.
Or until time or until scn.  Tell it to stop at a particular spot
otherwise it expects a full recovery.

-Original Message-
Sent: Thursday, October 25, 2001 4:55 PM
To: Multiple recipients of list ORACLE-L


Jay,

It is reasonable to assume that your hot backup is NOT ok ;-)

This is *possibly* because this particular file (or maybe more files to
come) wasn't backed up for a while. Can you look at the timestamp of this
file (and other files) in the backup that you restored? That should give you
a clue... I think this is what's happening here: Oracle needs to make sure
as many logs as needed should be applied to this 'old' file so that the SCN
on this particular file matches the latest one found in the system.dbf, so
you need to keep applying from that point in time until now Another clue
is to trace your archive logs - look at the one that you started applying.
The time on that one is probably the time that your backup of that
particular file became invalid

Hth,
John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

Listen to great commercial-free christian music 24x7 at www.klove.com 

** The opinions and statements above are entirely my own and not
those of my employer or clients **




> -Original Message-
> From: Miller, Jay [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 25, 2001 4:05 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Unable to rebuild database from hot backup
> 
> 
> Okay, this is weird.
> 
> I'm trying to rebuilding my QC database from a hot backup.  
> As always, I
> copied all the hot backup files, all the archive logs from 
> the period of the
> hot backup and the control files.
> 
> After doing
> recover database using backup controlfile;
> 
> I got 
> SVRMGR> alter database open resetlogs;
> alter database open resetlogs
> *
> ORA-01113: file 1 needs media recovery
> ORA-01110: data file 1: '/data1/nyccp/systnyccp.dbf
> 
> Thinking that perhaps I just needed to apply more logs I went 
> on to apply
> another 12 hours worth of archive logs.  I still get the same error.  
> 
> Now I'm really concerned that my hot backup is invalid for 
> some reason.
> Does anyone have any suggestions for what else I can look at?
> 
> TIA,
> Jay Miller
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Miller, Jay
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> 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.com
-- 
Author: John Kanagaraj
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Kimberly Smith
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Unable to rebuild database from hot backup

[Miller, Jay]

Another piece of information:

On the basis of "it couldn't hurt to try" I recopied everything but instead
of using the regular control file I used the standby control file.  I then
mounted it in standby mode, issued the recover standby database command,
activated the standby, shutdown, and opened the database.  It worked fine.

Why would it work with a standby controlfile and not with the regular
control file?  I have my QC database working but I'm really puzzled.

Jay Miller

-Original Message-
Sent: Thursday, October 25, 2001 7:05 PM
To: Multiple recipients of list ORACLE-L


Okay, this is weird.

I'm trying to rebuilding my QC database from a hot backup.  As always, I
copied all the hot backup files, all the archive logs from the period of the
hot backup and the control files.

After doing
recover database using backup controlfile;

I got 
SVRMGR> alter database open resetlogs;
alter database open resetlogs
*
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/data1/nyccp/systnyccp.dbf

Thinking that perhaps I just needed to apply more logs I went on to apply
another 12 hours worth of archive logs.  I still get the same error.  

Now I'm really concerned that my hot backup is invalid for some reason.
Does anyone have any suggestions for what else I can look at?

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Miller, Jay
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Unable to rebuild database from hot backup

[Khedr, Waleed]

I think you have to alter the old database backup the control file to trace
file and then use this trace file after modification and editing to open the
new database.

-Original Message-
Sent: Thursday, October 25, 2001 7:05 PM
To: Multiple recipients of list ORACLE-L


Okay, this is weird.

I'm trying to rebuilding my QC database from a hot backup.  As always, I
copied all the hot backup files, all the archive logs from the period of the
hot backup and the control files.

After doing
recover database using backup controlfile;

I got 
SVRMGR> alter database open resetlogs;
alter database open resetlogs
*
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/data1/nyccp/systnyccp.dbf

Thinking that perhaps I just needed to apply more logs I went on to apply
another 12 hours worth of archive logs.  I still get the same error.  

Now I'm really concerned that my hot backup is invalid for some reason.
Does anyone have any suggestions for what else I can look at?

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Khedr, Waleed
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Link to DB2

[Khedr, Waleed]

Title: RE: Link to DB2



Small 
web application connected to DB2 and URL that will send a XML file to Oracle 
when it it's requested from Oracle Server might be good 
solution.
 
Regards,
Waleed

  -Original Message-From: Johnston, Tim 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, October 25, 2001 
  7:25 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: Link to DB2
  Out 
  of curiosity, is the DB2 database on NT, Unix or a mainframe?  My DB2 
  knowledge is more on the mainframe side and the Unix/NT implementations may be 
  easier to deal with...  But, that being said
   
  If 
  you need the data in a real time manner then the Transparent Gateway may 
  be your best bet...
   
  http://technet.oracle.com/products/gateways/content.html
   
  Alternatively, you could connect to the DB2 database from your web app 
  using DRDA (Basically the Net8 equivalent for DB2...  I 
  think it stands for Distributed Remote Database Access) and extract the 
  information...  Process it and then store it in the Oracle 
  database...  Last time I dealt with this there were some third party 
  vendors that offered ODBC drivers but IBM did not have one that shipped with 
  the product...  I assume that they have probably come a long way in this 
  area over the last couple years...
   
  Also, if this is a batch task that happens in the background on 
  periodic intervals, then you may be able to implement another 
  solution...  An example would be...  Unload the data from DB2 using 
  whatever solutions you have available ( i.e. a DB2 utility, QMF, a custom 
  program ) and place it into a flat file...  Then use SQL*Loader 
  to load the information into a staging table on the Oracle side...  
  Process the data and insert it into the "real" tables and don't forget to 
  cleanup the staging table... 
   
  :-)
   
  Hope 
  this helps...
   
  Tim
  
-Original Message-From: Hamid Alavi 
[mailto:[EMAIL PROTECTED]]Sent: Thursday, October 25, 2001 
5:26 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: Link to DB2
Tim,
 
We 
have an oracle database(8.1.6) on NT2k and we need retrieve some records 
from another database DB2 and after some processing on these records store 
it in our database, these all will be doing thru an web base 
application.
I 
am looking for the best solution to link the oracle to DB2, don't know ODBC 
or JDBC will work or may be we need some gateway or third part software, I 
have no idea.
 

  -Original Message-From: Johnston, Tim 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, October 25, 2001 
  2:06 PMTo: Multiple recipients of list 
  ORACLE-LSubject: RE: Link to DB2
  That probably depends on what you need the link 
  for...  Can you further define the requirement of what you are trying 
  to do?
  Tim 
  PS - I have no experience with them but Oracle does offer 
  Transparent Gateways to other dbms platforms...  I'm not 100% sure 
  but I think DB2 is one of them...  But depending on your needs it may 
  be more or less then you really need...
  -Original Message- From: 
  Hamid Alavi [mailto:[EMAIL PROTECTED]] 
  Sent: Thursday, October 25, 2001 4:01 PM To: Multiple recipients of list ORACLE-L Subject: Link to DB2 
  List, 
  What's the best solution for linking oracle to DB2 
  Oracle 8.1.6 on NT2K 
  Hamid Alavi Office 818 
  737-0526 Cell    818 
  402-1987 
  The information contained in this message and any 
  attachments is intended only for the use of the 
  individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt 
  from disclosure under applicable law. If you have 
  received this message in error, you are prohibited 
  from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete 
  the original message from your system. 
  -- Please see the official 
  ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi   INET: [EMAIL PROTECTED] 
  Fat City Network Services    -- (858) 
  538-5051  FAX: (858) 538-5051 San Diego, 
  California    -- Public Internet 
  access / Mailing Lists  
  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 message and any 
attachments is intended only for the use of the individual or entity to 
which it is addressed, and may contain information that is PRI

Re: Java in the database

[Jared . Still]

PL/SQL in the database, Perl everywhere else.

Jared



   

"Boivin, Patrice   

J"  To: Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>
<[EMAIL PROTECTED]   cc:

mpo.gc.ca>  Subject: Java in the database  

Sent by:   

[EMAIL PROTECTED]   

   

   

10/25/01 10:16 AM  

Please respond to  

ORACLE-L   

   

   





Out of curiosity, is anyone using the java engine for procedural code, or
are most people still using PL/SQL?

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED] 

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
--
Author:
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

INITRANS storage parameter

[Wong, Bing]

Hi,

I have 8.1.7.1 running on HP-UX.  One of my table is heavily being updated
and I see blocking locks.  I have recalled that if I change the INITRANS
value from 1 to 2, the blocking locks should go away.  Question I have is
can I modify it in the fly without dropping and recreating the table.

Thanks
Bing

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Wong, Bing
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Unable to rebuild database from hot backup

[John Kanagaraj]

Jay,

It is reasonable to assume that your hot backup is NOT ok ;-)

This is *possibly* because this particular file (or maybe more files to
come) wasn't backed up for a while. Can you look at the timestamp of this
file (and other files) in the backup that you restored? That should give you
a clue... I think this is what's happening here: Oracle needs to make sure
as many logs as needed should be applied to this 'old' file so that the SCN
on this particular file matches the latest one found in the system.dbf, so
you need to keep applying from that point in time until now Another clue
is to trace your archive logs - look at the one that you started applying.
The time on that one is probably the time that your backup of that
particular file became invalid

Hth,
John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

Listen to great commercial-free christian music 24x7 at www.klove.com 

** The opinions and statements above are entirely my own and not
those of my employer or clients **




> -Original Message-
> From: Miller, Jay [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 25, 2001 4:05 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Unable to rebuild database from hot backup
> 
> 
> Okay, this is weird.
> 
> I'm trying to rebuilding my QC database from a hot backup.  
> As always, I
> copied all the hot backup files, all the archive logs from 
> the period of the
> hot backup and the control files.
> 
> After doing
> recover database using backup controlfile;
> 
> I got 
> SVRMGR> alter database open resetlogs;
> alter database open resetlogs
> *
> ORA-01113: file 1 needs media recovery
> ORA-01110: data file 1: '/data1/nyccp/systnyccp.dbf
> 
> Thinking that perhaps I just needed to apply more logs I went 
> on to apply
> another 12 hours worth of archive logs.  I still get the same error.  
> 
> Now I'm really concerned that my hot backup is invalid for 
> some reason.
> Does anyone have any suggestions for what else I can look at?
> 
> TIA,
> Jay Miller
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Miller, Jay
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> 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.com
-- 
Author: John Kanagaraj
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Link to DB2

[Johnston, Tim]

Title: RE: Link to DB2



Out of 
curiosity, is the DB2 database on NT, Unix or a mainframe?  My DB2 
knowledge is more on the mainframe side and the Unix/NT implementations may be 
easier to deal with...  But, that being said
 
If you 
need the data in a real time manner then the Transparent Gateway may be 
your best bet...
 
http://technet.oracle.com/products/gateways/content.html
 
Alternatively, you could connect to the DB2 database from your web app 
using DRDA (Basically the Net8 equivalent for DB2...  I think it 
stands for Distributed Remote Database Access) and extract the 
information...  Process it and then store it in the Oracle 
database...  Last time I dealt with this there were some third party 
vendors that offered ODBC drivers but IBM did not have one that shipped with the 
product...  I assume that they have probably come a long way in this area 
over the last couple years...
 
Also, 
if this is a batch task that happens in the background on periodic intervals, 
then you may be able to implement another solution...  An example 
would be...  Unload the data from DB2 using whatever solutions you have 
available ( i.e. a DB2 utility, QMF, a custom program ) and place it into 
a flat file...  Then use SQL*Loader to load the information into 
a staging table on the Oracle side...  Process the data and insert it into 
the "real" tables and don't forget to cleanup the staging table... 

 
:-)
 
Hope 
this helps...
 
Tim

  -Original Message-From: Hamid Alavi 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, October 25, 2001 
  5:26 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: Link to DB2
  Tim,
   
  We 
  have an oracle database(8.1.6) on NT2k and we need retrieve some records from 
  another database DB2 and after some processing on these records store it in 
  our database, these all will be doing thru an web base 
  application.
  I am 
  looking for the best solution to link the oracle to DB2, don't know ODBC or 
  JDBC will work or may be we need some gateway or third part software, I have 
  no idea.
   
  
-Original Message-From: Johnston, Tim 
[mailto:[EMAIL PROTECTED]]Sent: Thursday, October 25, 2001 
2:06 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: Link to DB2
That probably depends on what you need the link for...  
Can you further define the requirement of what you are trying to 
do?
Tim 
PS - I have no experience with them but Oracle does offer 
Transparent Gateways to other dbms platforms...  I'm not 100% sure but 
I think DB2 is one of them...  But depending on your needs it may be 
more or less then you really need...
-Original Message- From: 
Hamid Alavi [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, October 25, 2001 4:01 PM To: Multiple recipients of list ORACLE-L Subject: Link to DB2 
List, 
What's the best solution for linking oracle to DB2 
Oracle 8.1.6 on NT2K 
Hamid Alavi Office 818 
737-0526 Cell    818 402-1987 

The information contained in this message and any 
attachments is intended only for the use of the 
individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt 
from disclosure under applicable law. If you have 
received this message in error, you are prohibited 
from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete 
the original message from your system. 
-- Please see the official ORACLE-L 
FAQ: http://www.orafaq.com -- Author: Hamid Alavi   INET: [EMAIL PROTECTED] 
Fat City Network Services    -- (858) 
538-5051  FAX: (858) 538-5051 San Diego, 
California    -- Public Internet 
access / Mailing Lists  
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 message and any 
  attachments is intended only for the use of the individual or entity to which 
  it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL 
  and exempt from disclosure under applicable law. If you have received this 
  message in error, you are prohibited from copying, distributing, or using the 
  information. Please contact the sender immediately by return e-mail and delete 
  the original message from your system.

Re: Temporary table

[Peter Gram]

Hi

I don't understand why you need to create the table and drop the table ? 
If you don't create/drop the table it sounds to me that Global Temporary 
Tables is the thing for you to use. If you have to waste resources on 
creating/droping tables in Oracle there is know easy way to do this, 
beware that in Oracle DDL statements (create, drop .. ) do a implicit 
commit;

Harvinder Singh wrote:

>Hi,
>
>In our application we need to create temporary table for life of a session
>and drop it after the session.
>we need this table to be session specific ...2 sessions connected as same
>schema user should be able to create
>table with the same name..
>for example user1. connected as scott  create table with name tab1..then
>user2 connected as scott should also be
>able to create table with name tab1...and we want table tab1 to be dropped
>as soon as user1 and user2 will discconnect
>We need to populate this temporary table in particular session and use it to
>join with other tables and then drop after the session.
>How can we implement this...
>global temporary table does not allow to be created twice in 1 schema..they
>r schema specific...
>
>Thanks
>-Harvinder
>

-- 
Regards

Peter Gram

Miracle A/S 
http://MiracleAS.dk 
Tel: +45 2527 7107



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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

Unable to rebuild database from hot backup

[Miller, Jay]

Okay, this is weird.

I'm trying to rebuilding my QC database from a hot backup.  As always, I
copied all the hot backup files, all the archive logs from the period of the
hot backup and the control files.

After doing
recover database using backup controlfile;

I got 
SVRMGR> alter database open resetlogs;
alter database open resetlogs
*
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/data1/nyccp/systnyccp.dbf

Thinking that perhaps I just needed to apply more logs I went on to apply
another 12 hours worth of archive logs.  I still get the same error.  

Now I'm really concerned that my hot backup is invalid for some reason.
Does anyone have any suggestions for what else I can look at?

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Temporary table

[Khedr, Waleed]

Either you have to read more about global temporary tables or you have to
give more details about your question.

-Original Message-
Sent: Thursday, October 25, 2001 6:35 PM
To: Multiple recipients of list ORACLE-L


Hi,

In our application we need to create temporary table for life of a session
and drop it after the session.
we need this table to be session specific ...2 sessions connected as same
schema user should be able to create
table with the same name..
for example user1. connected as scott  create table with name tab1..then
user2 connected as scott should also be
able to create table with name tab1...and we want table tab1 to be dropped
as soon as user1 and user2 will discconnect
We need to populate this temporary table in particular session and use it to
join with other tables and then drop after the session.
How can we implement this...
global temporary table does not allow to be created twice in 1 schema..they
r schema specific...

Thanks
-Harvinder
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Harvinder Singh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Khedr, Waleed
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

Temporary table

[Harvinder Singh]

Hi,

In our application we need to create temporary table for life of a session
and drop it after the session.
we need this table to be session specific ...2 sessions connected as same
schema user should be able to create
table with the same name..
for example user1. connected as scott  create table with name tab1..then
user2 connected as scott should also be
able to create table with name tab1...and we want table tab1 to be dropped
as soon as user1 and user2 will discconnect
We need to populate this temporary table in particular session and use it to
join with other tables and then drop after the session.
How can we implement this...
global temporary table does not allow to be created twice in 1 schema..they
r schema specific...

Thanks
-Harvinder
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Harvinder Singh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Database link in the same DB

[Scott Shafer]

See my reply.  It does help with testing certain processes in our
development environment.

--Scott


> "Koivu, Lisa" wrote:
> 
> Why on earth would you want to do that??  I mean I'm bored and all but
> it hasn't occurred to me to do this!
> 
> Lisa Koivu
> Oracle Database Monkey and Certified Couch Potato.
> Fairfield Resorts, Inc.
> 954-935-4117
> 
>  -Original Message-
>  From:   Aldi Barco [SMTP:[EMAIL PROTECTED]]
>  Sent:   Thursday, October 25, 2001 5:31 PM
>  To: Multiple recipients of list ORACLE-L
>  Subject:Database link in the same DB
> 
>  Hi Listers,
> 
>  Can we create and use database link within the same database ?
>  I have created one but still error when use it for select
>  statement.
>  It's OK for database link to different database.

_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Database link in the same DB

[Scott Shafer]

I was able to do this on HPUX, Oracle 7.3.4 by creting a tnsnames.ora
entry like the one below:

_LOOP = (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(PORT=1601)
(HOST=127.0.0.1))(CONNECT_DATA=(SID=)))

and using it for 'USING' clause of the dblink.  the IP address 127.0.0.1
is our localhost/loopback entry in /etc/hosts like so:

127.0.0.1   localhost   loopback

YMMV,

Scott Shafer
San Antonio, TX


Aldi Barco wrote:
> 
> Hi Listers,
> 
> Can we create and use database link within the same database ?
> I have created one but still error when use it for select statement.
> It's OK for database link to different database.
> 
> Thanks.
> 
> Aldi
> 
> _
> Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Aldi Barco
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> 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!?
Get your free @yahoo.com address at http://mail.yahoo.com

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Link to DB2

[Kevin Lange]

Title: RE: Link to DB2



Hamid;
  
We have have very good success using Oracles Transparent Gateway for 
DRDA.
 
We 
even had replication happening from the DB2 database down to the Oracle database 
with no problems.  
 
We 
started with it on Oracle 7.3.4 back in '97 and, the last time I asked the 
current DBA at that company, its been upgraded and working just fine on 
8.1.7.
 
Kevin

  -Original Message-From: Johnston, Tim 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, October 25, 2001 
  4:06 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: Link to DB2
  That probably depends on what you need the link for...  
  Can you further define the requirement of what you are trying to 
do?
  Tim 
  PS - I have no experience with them but Oracle does offer 
  Transparent Gateways to other dbms platforms...  I'm not 100% sure but I 
  think DB2 is one of them...  But depending on your needs it may be more 
  or less then you really need...
  -Original Message- From: Hamid 
  Alavi [mailto:[EMAIL PROTECTED]] 
  Sent: Thursday, October 25, 2001 4:01 PM To: Multiple recipients of list ORACLE-L Subject: Link to DB2 
  List, 
  What's the best solution for linking oracle to DB2 
  Oracle 8.1.6 on NT2K 
  Hamid Alavi Office 818 737-0526 
  Cell    818 402-1987 
  The information contained in this message and any attachments 
  is intended only for the use of the individual or 
  entity to which it is addressed, and may contain 
  information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in 
  error, you are prohibited from copying, distributing, 
  or using the information. Please contact the sender 
  immediately by return e-mail and delete the original 
  message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 
  Author: Hamid Alavi   
  INET: [EMAIL PROTECTED] 
  Fat City Network Services    -- (858) 
  538-5051  FAX: (858) 538-5051 San Diego, 
  California    -- Public Internet access 
  / Mailing Lists  
  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: Solaris 2.6/8.1.6/Security (Kinda Long)

[DBarbour]

Skip the public synonym on the local admin view?  Create a synonym(not
public) for the view, then grant select on it to adm.

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002


   
   
"Vergara,  
   
Michael (TEM)"   To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>  
 Subject: Solaris 2.6/8.1.6/Security 
(Kinda Long) 
Sent by:   
   
[EMAIL PROTECTED] 
   
om 
   
   
   
   
   
10/25/2001 
   
02:35 PM   
   
Please respond 
   
to ORACLE-L
   
   
   
   
   




Gurus:

This is a question about security, and query-ability.

I have a remote database;  let's call it REMOTE.  I have local
users who want to query REMOTE, but I cannot create additional
users there without incurring undue amounts of heartache (not to
mention heartburn!).

I created a local database called SHADOW.  The SHADOW database has
a DBA-level user who owns a private database link to REMOTE.
SHADOW also has local users defined who wish to query REMOTE.

As DBA in SHADOW, I created a view (as SELECT *) of one of the
tables on REMOTE.  I then created a public synonym to this view,
and granted select to the local user.

No worries.  So far...so good.

Now an admin-level user wants access to a different table
on REMOTE.  So I did the same thing as for the local non-admin
user.  Created a view.  Created a public synonym.  Granted
all to the admin user.  Now, however, the local non-admin
user can see and query the admin's table!  This is not what
I want!

All privileges are granted through ROLES, the local user
gets the 'RO' role, and the admin user gets 'ADM' role.  How
can I stop the local non-admin user from seeing (and updating,
since that view allows updates) the admin's table?

Thanks,
Mike

---
===
Michael P. Vergara
Oracle DBA
Guidant Corporation
(909) 914-2304

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Vergara, Michael (TEM)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Database link in the same DB

[Koivu, Lisa]

Title: RE: Database link in the same DB





Why on earth would you want to do that??  I mean I'm bored and all but it hasn't occurred to me to do this!


Lisa Koivu
Oracle Database Monkey and Certified Couch Potato.
Fairfield Resorts, Inc.
954-935-4117



-Original Message-
From:   Aldi Barco [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, October 25, 2001 5:31 PM
To: Multiple recipients of list ORACLE-L
Subject:    Database link in the same DB


Hi Listers,


Can we create and use database link within the same database ?
I have created one but still error when use it for select statement.
It's OK for database link to different database.


Thanks.


Aldi


_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp


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


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    -- Public Internet access / Mailing Lists

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: URGENT -- db already exist ???

[Khedr, Waleed]

Try running oradim

-Original Message-
Sent: Thursday, October 25, 2001 5:10 PM
To: Multiple recipients of list ORACLE-L


Hi all,

I created a 815 database on NT4.  Since there is
something wrong with it, I used db config assist to
delete it.  When I tried to create a database with
exactly the same name, I got message that "db already
exist."  I already deleted entried in tnsnames and
listener.ora.  I must use that particular name.  Where
else does the name got logged?

Thank you!

Leslie

__
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Leslie Lu
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Khedr, Waleed
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Move tablespace with no downtime?

[Connor McDonald]

True - but with tempfiles that is just about
instantaneous anyway.  

Cheers
Connor

 --- Glenn Travis <[EMAIL PROTECTED]> wrote: > FYI:
 This will not work with TEMP tablespaces which
> are locally managed.  You must drop the tablespace
> and recreate it with the new filename.  Check
> Metalink - it is documented that temporary datafiles
> (tempfiles) cannot be renamed.
> 
> > -Original Message-
> > From: Jeremiah Wilton
> [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, October 25, 2001 11:40 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: Move tablespace with no downtime?
> > 
> > 
> > Here's a trick I like to reduce the downtime
> associated with moving
> > large datafiles:
> > 
> > 1. Place the tablespace that contains the file(s)
> you want to move
> >into backup mode:
> >- alter tablespace  begin backup;
> > 
> > 2. Copy the file(s):
> >- cp  
> >- If you are moving multiple files, you can do
> this in parallel
> > 
> > 3. Take the tablespace out of backup mode:
> >- alter tablespace  end backup;
> > 
> > 4. (Now the very brief downtile begins)
> >Take the tablespace offline immediate
> >- alter tablespace  offline immediate;
> > 
> > 5. Issue the rename:
> >- alter database rename file  to
> ;
> > 
> > 6. Recover the new file(s) or the whole tablespace
> (should be quite
> >brief)
> >- recover [datafile|tablespace] ;
> > 
> > 7. (Now the very brief downtime ends)
> >Bring the tablespace online again:
> >- alter tablespace  online;
> > 
> > --
> > Jeremiah Wilton
> > http://www.speakeasy.net/~jwilton
> > 
> > On Thu, 25 Oct 2001, Rachel Carmichael wrote:
> > 
> > > depends on what you mean by downtime.
> > >
> > > yes you can do it without taking down the
> database and the instance,
> > > no, you can't do it without at least taking the
> tablespace offline.
> > >
> > > alter tablespace x offline;
> > > in os, make a copy of all datafiles in the new
> location
> > > alter database move file 'y' to 'z';
> > >   
> > > alter tablespace online;
> > >
> > >
> > > --- Greg Moore <[EMAIL PROTECTED]> wrote:
> > > > Can I move a tablespace and all it's
> associated datafiles to a new
> > > > disk
> > > > device with no downtime?
> > > >
> > > > --
> > > > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > > > --
> > > > Author: Greg Moore
> > > >   INET: [EMAIL PROTECTED]
> > > >
> > > > Fat City Network Services-- (858) 538-5051
>  FAX: 
> > (858) 538-5051
> > > > San Diego, California-- Public
> Internet access / Mailing
> > > > Lists
> > > > 
> >
>

> > > > 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!?
> > > Make a great connection at Yahoo! Personals.
> > > http://personals.yahoo.com
> > > --
> > > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > > --
> > > Author: Rachel Carmichael
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- (858) 538-5051 
> FAX: (858) 538-5051
> > > San Diego, California-- Public Internet
> access / 
> > Mailing Lists
> > >
>

> > > 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.com
> > -- 
> > Author: Jeremiah Wilton
> >   INET: [EMAIL PROTECTED]
> > 
> > Fat City Network Services-- (858) 538-5051 
> FAX: (858) 538-5051
> > San Diego, California-- Public Internet
> access / Mailing Lists
> >
>

> > 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.com
> -- 
> Author: Glenn Travis
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> ac

Re: Update invalid trigger_text in DBA_TRIGGERS?

[Charlie Mengler]

This is just a heads up warning which may or may not be relevant.
In V7.3 I know that Oracle had a NASTY habit of silently discarding
the pair of outer parenthesis around the WHEN clause. The net result
is/was that the trigger would NOT be successfully re-created!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Charlie Mengler
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: URGENT -- db already exist ???

[Vergara, Michael (TEM)]

It's in the Registry.  You will need to use 'oradim' or one of it's
variants to delete this SID from the system.

HTH,
Mike

---
===
Michael P. Vergara
Oracle DBA
Guidant Corporation
(909) 914-2304


-Original Message-
Sent: Thursday, October 25, 2001 2:10 PM
To: Multiple recipients of list ORACLE-L


Hi all,

I created a 815 database on NT4.  Since there is
something wrong with it, I used db config assist to
delete it.  When I tried to create a database with
exactly the same name, I got message that "db already
exist."  I already deleted entried in tnsnames and
listener.ora.  I must use that particular name.  Where
else does the name got logged?

Thank you!

Leslie

__
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Leslie Lu
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Vergara, Michael (TEM)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

Database link in the same DB

[Aldi Barco]

Hi Listers,

Can we create and use database link within the same database ?
I have created one but still error when use it for select statement.
It's OK for database link to different database.

Thanks.

Aldi

_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Update invalid trigger_text in DBA_TRIGGERS?

[Rachel Carmichael]

um, shameless plu here:

Oracle SQL & PL/SQL Annotated Archives has a script to create sql for
triggers, and it can be used to generate for all triggers owned by a
schema

end of shameless plug


--- Larry Elkins <[EMAIL PROTECTED]> wrote:
> David,
> 
> I would lean towards generating a script for all the triggers (if you
> don't
> already have them), doing a global replace on that, and then
> executing the
> script. TOAD, for example, can easily generate a single script for
> you
> containing all the create or replace trigger statements in a schema.
> And
> while I don't have one handy, I'm sure other list members have
> scripts to
> dump trigger source code where you could accomplish your same goal.
> 
> Regards,
> 
> Larry G. Elkins
> [EMAIL PROTECTED]
> 214.954.1781
> 
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
> > [EMAIL PROTECTED]
> > Sent: Thursday, October 25, 2001 2:12 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Update invalid trigger_text in DBA_TRIGGERS?
> >
> >
> >
> > I've got 885 triggers with hard-coded fully qualified table names
> in
> > DBA_TRIGGERS.  Problem is, the vendor changed the ownership on
> these
> > tables, and now I've got 885 invalid triggers.  I'd just like to
> run my
> > grand scheme (not to be confused with schema) past you folks,
> > give you the
> > chance to realize just what an idiot I am, and offer brilliant
> > alternatives
> > that'll cause lasting envy, jealousy, and self-pity - mostly
> because the
> > suggestions will be simpler, and might actually work.
> >
> > So much for the introduction.  I thought I'd just go into
> DBA_TRIGGERS and
> > run a replace against the trigger_text.  Since trigger_text is a
> long data
> > type, I don't believe I can use a straight update ..  set ...
> replace() in
> > SQL PLUS.  My plan therefore is to write a quick PL/SQL piece that
> will
> > select the long column into a varchar2, do the replace, then update
> the
> > long column with the edited varchar2 variable.
> >
> > Is this a realistic strategy?
> >
> >
> >
> > David A. Barbour
> > Oracle DBA, OCP
> > AISD
> > 512-414-1002
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author:
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing
> Lists
> >
> 
> > 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.com
> -- 
> Author: Larry Elkins
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> 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!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

Rep:Link to DB2

[adba]

It depends.  In some cases you might be ok writing
flat files and using SQLLOADER.  There are gateways
to DB2, we are using DRDA.  You set up the
information about the gateway in the tnsnames, and
create a database link to the DB2 database.

HTH
Mike Boligan

-Message d'origine-
De: Hamid Alavi <[EMAIL PROTECTED]>
A: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
Date: 25/10/01
Objet: Link to DB2

List,

What's the best solution for linking oracle to DB2
Oracle 8.1.6 on NT2K




Hamid Alavi
Office 818 737-0526
Cell818 402-1987

The information contained in this message and any
attachments is intended
only for the use of the individual or entity to which
it is addressed, and
may contain information that is PRIVILEGED,
CONFIDENTIAL and exempt from
disclosure under applicable law. If you have received
this message in error,
you are prohibited from copying, distributing, or
using the information.
Please contact the sender immediately by return
e-mail and delete the
original message from your system.
-- 
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
-- 
Author: Hamid Alavi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX:
(858) 538-5051
San Diego, California-- Public Internet
access / Mailing Lists
-
---
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).


You too can have your own email address from Eurosport.
http://www.eurosport.com





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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Link to DB2

[Hamid Alavi]

Title: RE: Link to DB2



Tim,
 
We 
have an oracle database(8.1.6) on NT2k and we need retrieve some records from 
another database DB2 and after some processing on these records store it in our 
database, these all will be doing thru an web base 
application.
I am 
looking for the best solution to link the oracle to DB2, don't know ODBC or JDBC 
will work or may be we need some gateway or third part software, I have no 
idea.
 

  -Original Message-From: Johnston, Tim 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, October 25, 2001 
  2:06 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: Link to DB2
  That probably depends on what you need the link for...  
  Can you further define the requirement of what you are trying to 
do?
  Tim 
  PS - I have no experience with them but Oracle does offer 
  Transparent Gateways to other dbms platforms...  I'm not 100% sure but I 
  think DB2 is one of them...  But depending on your needs it may be more 
  or less then you really need...
  -Original Message- From: Hamid 
  Alavi [mailto:[EMAIL PROTECTED]] 
  Sent: Thursday, October 25, 2001 4:01 PM To: Multiple recipients of list ORACLE-L Subject: Link to DB2 
  List, 
  What's the best solution for linking oracle to DB2 
  Oracle 8.1.6 on NT2K 
  Hamid Alavi Office 818 737-0526 
  Cell    818 402-1987 
  The information contained in this message and any attachments 
  is intended only for the use of the individual or 
  entity to which it is addressed, and may contain 
  information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in 
  error, you are prohibited from copying, distributing, 
  or using the information. Please contact the sender 
  immediately by return e-mail and delete the original 
  message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi   INET: [EMAIL PROTECTED] 
  Fat City Network Services    -- (858) 
  538-5051  FAX: (858) 538-5051 San Diego, 
  California    -- Public Internet access 
  / Mailing Lists  
  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 message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system.

Re: Classes

[Greg Moore]

Classes by Cary Millsap (hotsos.com) or Craig Shallahamer (orapub.com) would
be pretty cool.  These two guys are on the cutting edge of Oracle
performance tuning.

Millsap's classes appear to be oriented toward his online service, which
they charge for.  I have no idea how valuable is class would be if your
company decided not to pay for his service.

Craig's classes focus on his toolset, which is available free.

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: i need check fragmentation of index

[Deepak Thapliyal]

hi @lex
one of the good ways to check this is to do a analyze
index .. validate structure and look at the statistics
from index_stats

Deepak

--- Alexander Ordonez <[EMAIL PROTECTED]> wrote:
> hi gurus, how check the fragmentation on index...??
> ahy idea???
> please i need your help!!
> 
> @lex
>

>   Lic. Alexander Ordóñez Arroyo 
>   Caja Costarricense del Seguro Social  
>   
>   Soporte Técnico - División de Informática 
>
>   Telefono: 295-2004, San José, Costa Rica  
>  
>   [EMAIL PROTECTED]Icq# 30173325
> 
>

> The true is out there in WWW
> 
> 
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Alexander Ordonez
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>

> 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!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deepak Thapliyal
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Solaris 2.6/8.1.6/Security (Kinda Long)

[Henry Poras]

Mike,
Somewhere on SHADOW, the users have SELECT, ... privileges on the admin
table. This is either granted directly or through a role or some system
privilege. Dig  around in DBA_SYS_PRIVS, DBA_TAB_PRIVS, and DBA_ROLE_PRIVS
and you should find the problem.

Henry

-Original Message-
Sent: Thursday, October 25, 2001 3:35 PM
To: Multiple recipients of list ORACLE-L


Gurus:

This is a question about security, and query-ability.

I have a remote database;  let's call it REMOTE.  I have local 
users who want to query REMOTE, but I cannot create additional 
users there without incurring undue amounts of heartache (not to
mention heartburn!).

I created a local database called SHADOW.  The SHADOW database has
a DBA-level user who owns a private database link to REMOTE.  
SHADOW also has local users defined who wish to query REMOTE.

As DBA in SHADOW, I created a view (as SELECT *) of one of the 
tables on REMOTE.  I then created a public synonym to this view,
and granted select to the local user.

No worries.  So far...so good.

Now an admin-level user wants access to a different table
on REMOTE.  So I did the same thing as for the local non-admin
user.  Created a view.  Created a public synonym.  Granted 
all to the admin user.  Now, however, the local non-admin
user can see and query the admin's table!  This is not what
I want!

All privileges are granted through ROLES, the local user
gets the 'RO' role, and the admin user gets 'ADM' role.  How
can I stop the local non-admin user from seeing (and updating,
since that view allows updates) the admin's table?

Thanks,
Mike

---
===
Michael P. Vergara
Oracle DBA
Guidant Corporation
(909) 914-2304

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Vergara, Michael (TEM)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Henry Poras
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Cross(-eyed) Platform RPC

[Mohan, Ross]

CM - 

I *think* this is functionally identical but linguistically
different than "client/server" RPC calls. The rsh is supported
( i ::think::, Unix goo-roo's help me, here) by udp/ip as is
rpc calling, but...is strictly remote execution without the
richness the RPC connection offers. 

Of course, I am probably just smoking WAY to much Oracle cRAC. 

thanks for your thoughts...it keeps the juice going (but then
again, you probably didn't need that level of detail. )

:-)

- RM


rm -rf /bin/laden

-Original Message-
Sent: Thursday, October 25, 2001 4:55 PM
To: Multiple recipients of list ORACLE-L


I'm supporting Siebel; where the database is Oracle running on
Solaris while the Siebel "application server" software runs on
an NT box. As part of the DB shutdown script an "rsh" is issued
to the NT box to stop the application server s/w prior to bringing
down the DB. In the DB startup script the application server
is started after the DB comes up. 

I've successfully tested starting from NT & invoking a script
on Solaris, but don't have anything just yet in production 
that uses this capability.

HTH & YMMV!

> "Mohan, Ross" wrote:
> 
> Probably a bit "OT" here, butanyone have any pithy rejoinders
> about doing cross platform RPC...or how MS RPC is different from,
> say, ONC/Sun RPC?
> 
> I am about to get into something where this will matter, and I am just
> dipping a toe in the water.
> 
> thanks in advance for any thoughts, including those scurrilous off topic
comments!
> 
> ;-)
> 
> - Ross Mohan

-- 
Charlie Mengler Maintenance Warehouse  
[EMAIL PROTECTED]10641 Scripps Summit Ct.
858-831-2229San Diego, CA 92131
NOTHING is impossible for the person who does not have to do it!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Charlie Mengler
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

URGENT -- db already exist ???

[Leslie Lu]

Hi all,

I created a 815 database on NT4.  Since there is
something wrong with it, I used db config assist to
delete it.  When I tried to create a database with
exactly the same name, I got message that "db already
exist."  I already deleted entried in tnsnames and
listener.ora.  I must use that particular name.  Where
else does the name got logged?

Thank you!

Leslie

__
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Leslie Lu
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Update invalid trigger_text in DBA_TRIGGERS?

[Mercadante, Thomas F]

David,

Sorry about my soap-box.  But I've been in your situation, and it stinks!.

I quick-wrote the following script to help you out.  It uses UTL_FILE, so
you will need to place an entry in your init.ora file, pointing to a
directory on your server.  The init.ora parameter you need to set is:

utl_file_dir= L:\u0001\oracle\admin\WTWD\Utl  ( or some
such directory)


You can the try running the script, and it will create a recreate_trig.sql
file within the directory you use.

Here is the script: Note - I only tested this for a few triggers, so your
mileage may vary.  At least it gives you a start:

DECLARE
CURSOR c1 IS
   SELECT trigger_name,triggering_event,
  trigger_type, trigger_body,table_Name
  FROM USER_TRIGGERS
  WHERE TABLE_name='WTW_ACTVTY_SUPP_SERV_ALIAS';
file_handle UTL_FILE.FILE_TYPE;
loc_trigger_body VARCHAR2(32000);
BEGIN

 
file_handle:=UTL_FILE.FOPEN('L:\u0001\oracle\admin\WTWD\Utl','recreate_trig.
sql', 'W');

FOR c1_rec IN c1 LOOP
  loc_trigger_body := c1_rec.trigger_body;
--  dbms_output.put_line('CREATE OR REPLACE TRIGGER {newowner}.' ||
c1_rec.trigger_name);
  utl_file.PUT_LINE(file_handle,'CREATE OR REPLACE TRIGGER {newowner}.' ||
c1_rec.trigger_name);
  utl_file.PUT_LINE(file_handle,SUBSTR(c1_rec.trigger_type,1,7)|| ' ' ||
c1_rec.triggering_event || 
' on ' || c1_rec.table_name);
  utl_file.PUT_LINE(file_handle,'FOR ' || SUBSTR(c1_rec.trigger_type,8,20));
  utl_file.PUT_LINE(file_handle,loc_trigger_body);
  utl_file.PUT_LINE(file_handle,'/');
  utl_file.PUT_LINE(file_handle,' ');
END LOOP;
  utl_file.FCLOSE(file_handle);
END;
/

Good Luck - and gives that vendor hell!

Tom Mercadante
Oracle Certified Professional


-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 3:12 PM
To: Multiple recipients of list ORACLE-L



I've got 885 triggers with hard-coded fully qualified table names in
DBA_TRIGGERS.  Problem is, the vendor changed the ownership on these
tables, and now I've got 885 invalid triggers.  I'd just like to run my
grand scheme (not to be confused with schema) past you folks,  give you the
chance to realize just what an idiot I am, and offer brilliant alternatives
that'll cause lasting envy, jealousy, and self-pity - mostly because the
suggestions will be simpler, and might actually work.

So much for the introduction.  I thought I'd just go into DBA_TRIGGERS and
run a replace against the trigger_text.  Since trigger_text is a long data
type, I don't believe I can use a straight update ..  set ... replace() in
SQL PLUS.  My plan therefore is to write a quick PL/SQL piece that will
select the long column into a varchar2, do the replace, then update the
long column with the edited varchar2 variable.

Is this a realistic strategy?



David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Check if a value in one table doesnt exist

[schmoldt]

Another approach, assuming ID is an index in table2:

select *
from table1 t1
where exists (select 'X' from table2 t2 where t1.id = t2.id)

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 25, 2001 3:00 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Check if a value in one table doesnt exist
> 
> 
> Hallo you  DBA'
> 
> Can anyone give me a good example on a sql select statement 
> checking if  any value in id field in table one exists in 
> table two's id field?Table two also contains the 
> corresponding id field but with other field names besides. Like this
> 
> Table 1: Id Name  Year
> Table 2: :Id   City   Country
> 
> Thanks in advance
> 
> Roland Sköldblom
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> 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.com
--
Author:
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Cross Platform RPC

[Charlie Mengler]

I'm supporting Siebel; where the database is Oracle running on
Solaris while the Siebel "application server" software runs on
an NT box. As part of the DB shutdown script an "rsh" is issued
to the NT box to stop the application server s/w prior to bringing
down the DB. In the DB startup script the application server
is started after the DB comes up. 

I've successfully tested starting from NT & invoking a script
on Solaris, but don't have anything just yet in production 
that uses this capability.

HTH & YMMV!

> "Mohan, Ross" wrote:
> 
> Probably a bit "OT" here, butanyone have any pithy rejoinders
> about doing cross platform RPC...or how MS RPC is different from,
> say, ONC/Sun RPC?
> 
> I am about to get into something where this will matter, and I am just
> dipping a toe in the water.
> 
> thanks in advance for any thoughts, including those scurrilous off topic comments!
> 
> ;-)
> 
> - Ross Mohan

-- 
Charlie Mengler Maintenance Warehouse  
[EMAIL PROTECTED]10641 Scripps Summit Ct.
858-831-2229San Diego, CA 92131
NOTHING is impossible for the person who does not have to do it!
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Charlie Mengler
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Link to DB2

[Johnston, Tim]

Title: RE: Link to DB2





That probably depends on what you need the link for...  Can you further define the requirement of what you are trying to do?

Tim


PS - I have no experience with them but Oracle does offer Transparent Gateways to other dbms platforms...  I'm not 100% sure but I think DB2 is one of them...  But depending on your needs it may be more or less then you really need...

-Original Message-
From: Hamid Alavi [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 4:01 PM
To: Multiple recipients of list ORACLE-L
Subject: Link to DB2



List,


What's the best solution for linking oracle to DB2
Oracle 8.1.6 on NT2K





Hamid Alavi
Office 818 737-0526
Cell    818 402-1987


The information contained in this message and any attachments is intended
only for the use of the individual or entity to which it is addressed, and
may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from
disclosure under applicable law. If you have received this message in error,
you are prohibited from copying, distributing, or using the information.
Please contact the sender immediately by return e-mail and delete the
original message from your system.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hamid Alavi
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    -- Public Internet access / Mailing Lists

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: Update invalid trigger_text in DBA_TRIGGERS?

[Henry Poras]

Can you use synonyms?

Henry

-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 3:12 PM
To: Multiple recipients of list ORACLE-L



I've got 885 triggers with hard-coded fully qualified table names in
DBA_TRIGGERS.  Problem is, the vendor changed the ownership on these
tables, and now I've got 885 invalid triggers.  I'd just like to run my
grand scheme (not to be confused with schema) past you folks,  give you the
chance to realize just what an idiot I am, and offer brilliant alternatives
that'll cause lasting envy, jealousy, and self-pity - mostly because the
suggestions will be simpler, and might actually work.

So much for the introduction.  I thought I'd just go into DBA_TRIGGERS and
run a replace against the trigger_text.  Since trigger_text is a long data
type, I don't believe I can use a straight update ..  set ... replace() in
SQL PLUS.  My plan therefore is to write a quick PL/SQL piece that will
select the long column into a varchar2, do the replace, then update the
long column with the edited varchar2 variable.

Is this a realistic strategy?



David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Henry Poras
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Why does ittake long time?

[Greg Moore]

Title: RE: Why does ittake long time?



Also, there's no WHERE clause condition that joins 
the two tables.  So you're getting a Cartesian product.  Is that what 
you want?  It might be the reason the query is taking so 
long

  - Original Message - 
  From: 
  Nirmal Kumar 
  Muthu Kumaran 
  To: Multiple recipients of list ORACLE-L 
  Sent: Thursday, October 25, 2001 5:50 
  AM
  Subject: RE: Why does ittake long 
  time?
  
  Have you checked, whether the query 
  will be using the indexes, if u have any... 
  Nirmal, 
  
-Original Message- From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] 
Sent:   Thursday, October 25, 2001 2:26 PM To: Multiple recipients of list ORACLE-L Subject:    Why does ittake long time? 
Hallo, 
Why does this query take so longtime to run...At 
least 20 minutes it is just  a simple count... 
(Embedded image moved to file: 
pic24685.pcx) 
Thanks in advance 
Roland Sköldblom << File: Paintbrush 
>> 

RE: Clocks rolling back?

[Deshpande, Kirti]

Check out following note on Metalink : 

Note:1013279.6  HOW DOES DAYLIGHT SAVINGS TIME AFFECT THE DATABASE?

HTH,

Regards
- Kirti Deshpande 
  Verizon Information Services
   http://www.superpages.com


> -Original Message-
> Sent: Thursday, October 25, 2001 10:25 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Are there any issues with Oracle that I should know about when the clocks
> roll back this weekend?
> 
> Rick Stephenson
> Oracle/Sybase Database Administrator
> [EMAIL PROTECTED]
> Ovid Technologies, Inc.
> 9350 South 150 East, Suite 300
> Sandy, UT 84070
> (801) 304-3000 ext. 2593
> 
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Classes

[Gary Weber]

Rachel, Dorothy (sorry Ross, I couldn't resist)

The instructor of the Parallel Server class I mentioned was Mary Jane
Bryksa. I took the class in Iselyn, New Jersey center. Just looked at
paperwork, it wasn't last year, but January of this year.

Gary Weber
Senior DBA
Charles Jones, LLC||Superior Information Services, LLC
609-530-1144, ext 5529

-Original Message-
Carmichael
Sent: Thursday, October 25, 2001 4:07 PM
To: Multiple recipients of list ORACLE-L


Gary,

Okay, who was the instructor?

Rachel
--- Gary Weber <[EMAIL PROTECTED]> wrote:
> Dave,
>
> Parallel Server class ruled my world last year :)
>
> Instructor was excellent. She had in-depth knowledge and a good sense
> of
> humor.
>
> Gary Weber
> Senior DBA
> Charles Jones, LLC||Superior Information Services, LLC
> 609-530-1144, ext 5529
>
> -Original Message-
> Turner
> Sent: Thursday, October 25, 2001 3:21 PM
> To: Multiple recipients of list ORACLE-L
>
>
> I've taken all the standard Oracle database administration classes
> such as perf tuning, backup and recovery, replication, etc. What I am
> looking for is a really good class that's more advanced. Does anyone
> have a killer class they recommend?
>
> Thanks, Dave Turner
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: David Turner
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> 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.com
> --
> Author: Gary Weber
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> 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!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Gary Weber
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Classes

[Mohan, Ross]

lol...GMTA

-Original Message-
Sent: Thursday, October 25, 2001 4:07 PM
To: Multiple recipients of list ORACLE-L


Gary,

Okay, who was the instructor?

Rachel
--- Gary Weber <[EMAIL PROTECTED]> wrote:
> Dave,
> 
> Parallel Server class ruled my world last year :)
> 
> Instructor was excellent. She had in-depth knowledge and a good sense
> of
> humor.
> 
> Gary Weber
> Senior DBA
> Charles Jones, LLC||Superior Information Services, LLC
> 609-530-1144, ext 5529
> 
> -Original Message-
> Turner
> Sent: Thursday, October 25, 2001 3:21 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> I've taken all the standard Oracle database administration classes
> such as perf tuning, backup and recovery, replication, etc. What I am
> looking for is a really good class that's more advanced. Does anyone
> have a killer class they recommend?
> 
> Thanks, Dave Turner
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: David Turner
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> 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.com
> -- 
> Author: Gary Weber
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> 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!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Move tablespace with no downtime?

[Glenn Travis]

FYI:  This will not work with TEMP tablespaces which are locally managed.  You must 
drop the tablespace and recreate it with the new filename.  Check Metalink - it is 
documented that temporary datafiles (tempfiles) cannot be renamed.

> -Original Message-
> From: Jeremiah Wilton [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, October 25, 2001 11:40 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Move tablespace with no downtime?
> 
> 
> Here's a trick I like to reduce the downtime associated with moving
> large datafiles:
> 
> 1. Place the tablespace that contains the file(s) you want to move
>into backup mode:
>- alter tablespace  begin backup;
> 
> 2. Copy the file(s):
>- cp  
>- If you are moving multiple files, you can do this in parallel
> 
> 3. Take the tablespace out of backup mode:
>- alter tablespace  end backup;
> 
> 4. (Now the very brief downtile begins)
>Take the tablespace offline immediate
>- alter tablespace  offline immediate;
> 
> 5. Issue the rename:
>- alter database rename file  to ;
> 
> 6. Recover the new file(s) or the whole tablespace (should be quite
>brief)
>- recover [datafile|tablespace] ;
> 
> 7. (Now the very brief downtime ends)
>Bring the tablespace online again:
>- alter tablespace  online;
> 
> --
> Jeremiah Wilton
> http://www.speakeasy.net/~jwilton
> 
> On Thu, 25 Oct 2001, Rachel Carmichael wrote:
> 
> > depends on what you mean by downtime.
> >
> > yes you can do it without taking down the database and the instance,
> > no, you can't do it without at least taking the tablespace offline.
> >
> > alter tablespace x offline;
> > in os, make a copy of all datafiles in the new location
> > alter database move file 'y' to 'z';
> >   
> > alter tablespace online;
> >
> >
> > --- Greg Moore <[EMAIL PROTECTED]> wrote:
> > > Can I move a tablespace and all it's associated datafiles to a new
> > > disk
> > > device with no downtime?
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Greg Moore
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- (858) 538-5051  FAX: 
> (858) 538-5051
> > > San Diego, California-- Public Internet access / Mailing
> > > Lists
> > > 
> 
> > > 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!?
> > Make a great connection at Yahoo! Personals.
> > http://personals.yahoo.com
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Rachel Carmichael
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / 
> Mailing Lists
> > 
> > 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.com
> -- 
> Author: Jeremiah Wilton
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> 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.com
-- 
Author: Glenn Travis
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

Cross Platform RPC

[Mohan, Ross]

Title: RE: Weirdness



Probably a bit "OT" here, butanyone have any pithy 
rejoinders
about 
doing cross platform RPC...or how MS RPC is different from, 
say, 
ONC/Sun RPC?
 
I am 
about to get into something where this will matter, and I am 
just
dipping a toe in the water. 
 
thanks 
in advance for any thoughts, including those scurrilous off topic 
comments!
 
;-)
 
- Ross 
Mohan

RE: Instance Name in Sql Prompt

[Ramon Estevez]

Thanks 
David, Jack it works !!
 
 
 
Ramon E. 
Estevez
[EMAIL PROTECTED]
Dominican Republic
809-565-3121

  -Mensaje original-De: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]En nombre de David WagonerEnviado 
  el: Thursday, 25 October, 2001 10:22 AMPara: Multiple 
  recipients of list ORACLE-LAsunto: RE: Instance Name in Sql 
  Prompt
  
  Add 
  the following to your login.sql or glogin.sql 
  file:
   
  set 
  serveroutput on
  set termout 
  off
  column 
  instance new_value prompt_instance
  select 
  substr(instance_name, 1, 10)instance
  from 
  v$instance
  /
  set sqlprompt 
  "&&prompt_instance> "
  set termout 
  on
   
   
  HTH,
   
  david
   
  David B. 
  Wagoner
  Database 
  Administrator
  Arsenal 
  Digital Solutions Worldwide Inc.
  4815 
  Emperor Blvd., Suite 110
  Durham, 
  NC 27703
  Tel. 
  (919) 941-4645
  Fax 
  (919) 474-0735
  Email 
  mailto:[EMAIL PROTECTED]
  Web 
  http://www.arsenaldigital.com/
   
    
  ***  NOTICE  ***
  This 
  e-mail message is confidential, intended only for the named recipient(s) above 
  and may contain information that is privileged, 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 the sender at (919) 941-4645 and 
  delete this e-mail message from your computer.  Thank you.
   
  -Original 
  Message-From: Ramon 
  Estevez [mailto:[EMAIL PROTECTED]]Sent: Thursday, October 25, 2001 10:35 
  AMTo: Multiple recipients of 
  list ORACLE-LSubject: 
  Instance Name in Sql Prompt
   
  Hi 
  Friends,
   
  Excuse me for this 
  dumb question,  how do I display the instance name in 
  the
  sql 
  prompt.  Have 3 DB and would like to know to which one I am 
  connected.
   
  I 
  mean something like that.
   
  DBA1 
  >
  DBA2 
  >
  DB01 
  >
   
  Regards,
   
  Ramon 
  E. Estevez
  [EMAIL PROTECTED]
  Dominican 
  Republic
  809-565-3121
   

Re: Move tablespace with no downtime?

[Greg Moore]

Rachel and Jeremiah,

Thanks very much.

What about creating a new tablespace on the new disk device and then:

alter table scott.emp move tablespace ;

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Instance Name in Sql Prompt

[Ramon Estevez]

Thanks to 
Kevin and all that reply.
 
I noticed 
when doing a connect inside a session.
 
This will 
help.
 
Ramon E. 
Estevez
[EMAIL PROTECTED]
Dominican Republic
809-565-3121

  -Mensaje original-De: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]En nombre de Kevin LangeEnviado el: 
  Thursday, 25 October, 2001 11:10 AMPara: Multiple recipients of 
  list ORACLE-LAsunto: RE: Instance Name in Sql 
  Prompt
  Ramon;
    In your startup directory on SQL Plus, you can automatically run 
  a script that will setup the environment like you want it.  Its called 
  LOGIN.SQL.
   
  Here 
  is a copy of mine:
   
  set 
  termout onset pagesize 0set echo offset feedback offset 
  sqlprompt ''spool c:\temp.sqlselect 'set sqlprompt '''||name||' > 
  '';' from v$database;spool off@c:\temp.sqlset pagesize 35set 
  feedback onset termout off
  What 
  this does is to take the name of the database from v$database and create a 
  temporary SQL file, then runs it.  This will set my prompt to 
  
   
  INSTANCE_NAME > 
   
  where INSTANCE_NAME is the name of the database.
   
  For 
  example, if I log onto DEV then the SQLPROMPT will be
   
  DEV 
  > 
   
  Hope 
  you can use it.
   
  Kevin
   
  p.s. 
  ...  Remember that  this only works for the initialization of SQL 
  Plus.  If you do a connect inside of your session then the prompt will 
  not change.
  
-Original Message-From: Ramon Estevez 
[mailto:[EMAIL PROTECTED]]Sent: Thursday, October 25, 
2001 9:35 AMTo: Multiple recipients of list 
ORACLE-LSubject: Instance Name in Sql Prompt
Hi 
Friends,
 
Excuse me for this 
dumb question,  how do I display the instance name in 
the
sql prompt.  
Have 3 DB and would like to know to which one I am 
connected.
 
I mean something like 
that.
 
DBA1 
>
DBA2 
>
DB01 
>
 
Regards,
 
Ramon E. 
Estevez
[EMAIL PROTECTED]
Dominican Republic
809-565-3121
 

RE: Classes

[Mohan, Ross]

Location and Name, please?

-Original Message-
Sent: Thursday, October 25, 2001 3:40 PM
To: Multiple recipients of list ORACLE-L


Dave,

Parallel Server class ruled my world last year :)

Instructor was excellent. She had in-depth knowledge and a good sense of
humor.

Gary Weber
Senior DBA
Charles Jones, LLC||Superior Information Services, LLC
609-530-1144, ext 5529
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Classes

[Rachel Carmichael]

Gary,

Okay, who was the instructor?

Rachel
--- Gary Weber <[EMAIL PROTECTED]> wrote:
> Dave,
> 
> Parallel Server class ruled my world last year :)
> 
> Instructor was excellent. She had in-depth knowledge and a good sense
> of
> humor.
> 
> Gary Weber
> Senior DBA
> Charles Jones, LLC||Superior Information Services, LLC
> 609-530-1144, ext 5529
> 
> -Original Message-
> Turner
> Sent: Thursday, October 25, 2001 3:21 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> I've taken all the standard Oracle database administration classes
> such as perf tuning, backup and recovery, replication, etc. What I am
> looking for is a really good class that's more advanced. Does anyone
> have a killer class they recommend?
> 
> Thanks, Dave Turner
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: David Turner
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> 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.com
> -- 
> Author: Gary Weber
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> 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!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Object-Oriented Tools

[Carle, William T (Bill), NLCIO]

Dennis,

Unfortunately, we already well embedded into the object-oriented world.
Upper management wants to think they are progressive and leading edge and
they want to use these new tools whether or not they are the best choice.


Bill Carle
AT&T
Database Administrator
816-995-3922
[EMAIL PROTECTED]

 -Original Message-
Sent:   Thursday, October 25, 2001 1:29 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Object-Oriented Tools

Bill - I have been interested in this because we are starting to develop in
Java. The feedback I have been getting is that what you are describing
hasn't worked out in the long run. My interpretation is that relational
techniques are quite robust and mature, and it is not difficult for
object-oriented programmers to adapt to the relational schema (should be
limited to a few objects). Most applications have non-object-oriented tools
that need access also. Appreciate anyone else's experiences.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Thursday, October 25, 2001 11:50 AM
To: Multiple recipients of list ORACLE-L


Hi,

We use a product called Persistence that takes C++ code and makes the
Oracle (or any relational) database look like an object-oriented database.
Does anyone else use these sorts of tools? I'm not an object-oriented guru
by any means so forgive me if I sound a bit vague. Isn't Oracle capable of
doing the same thing? What is the best tool for this?


Bill Carle
AT&T
Database Administrator
816-995-3922
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Carle, William T (Bill), NLCIO
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Carle, William T (Bill), NLCIO
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Object-Oriented Tools

[Johnston, Tim]

Title: RE: Object-Oriented Tools



You 
could also code your own data access layer from within the 
application...  That way all database access is done through this 
limited set of code...  Which is nice if you ever need to do things 
like change the schema, fix a bug or migrate to a new 
DBMS...
 
Tim

  -Original Message-From: Aponte, Tony 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, October 25, 2001 2:29 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  Object-Oriented Tools
  We used it many moons ago with version 7.32.  It turned 
  out to be more complicated to administer and code than we ever anticipated so 
  it was put to pasture.  You're right in that many of the OO functionality 
  is included in the newer versions,  and what's not can be provided with 
  Java in the database.  We acquired it as a means to keep the database 
  access code agnostic of the DBMS used but it suffered from (self-inflicted) 
  poor implementation.  Eventually, the conclusion was reached that the 
  cost of this agnosticism was ridiculous and the whole Persistence layer was 
  eliminated from the application.  The client connections go straight to 
  the database via Net8.  One additional side-effect was that we can use 
  all of the Oracle security features available where as before the application 
  handled the user account privileges in the Persistence layer.  This gave 
  us visibility over who/what/where/how data was being manipulated.
  HTH Tony Aponte 
  -Original Message- From: 
  Carle, William T (Bill), NLCIO [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 25, 2001 12:50 PM To: 
  Multiple recipients of list ORACLE-L Subject: 
  Object-Oriented Tools 
  Hi, 
      We use a product called Persistence that 
  takes C++ code and makes the Oracle (or any 
  relational) database look like an object-oriented database. Does anyone else use these sorts of tools? I'm not an object-oriented 
  guru by any means so forgive me if I sound a bit 
  vague. Isn't Oracle capable of doing the same thing? 
  What is the best tool for this? 
  Bill Carle AT&T Database Administrator 816-995-3922 
  [EMAIL PROTECTED] 
  -- Please see the official ORACLE-L 
  FAQ: http://www.orafaq.com 
  -- Author: Carle, William T (Bill), 
  NLCIO   INET: [EMAIL PROTECTED] 
  Fat City Network Services    -- (858) 
  538-5051  FAX: (858) 538-5051 San Diego, 
  California    -- Public Internet access 
  / Mailing Lists  
  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: Weirdness

[Johnston, Tim]

Title: RE: Weirdness





Maybe you post the explain plans from the two scenarios with the statistics of your run times?  Did you run the test multiple times?  Was there any other activity on the system while running your tests?

Tim


-Original Message-
From: Kimberly Smith [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 1:17 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Weirdness



That is my whole question.  I did make it an IOT and performance
suffered.  I was surprised by that.


-Original Message-
Sent: Thursday, October 25, 2001 9:36 AM
To: Multiple recipients of list ORACLE-L



Kimberly - Have you considered making this an index-organized table?
Available in the most recent versions of Oracle.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]



-Original Message-
Sent: Thursday, October 25, 2001 11:16 AM
To: Multiple recipients of list ORACLE-L



Its one index with all the columns.  This is why I was thinking it would
be the same or similar performance.  The execution path is fine and 
considering how many rows I am dealing with the execution is more then
fine.  I was trying to reduce storage and speed up the loads a bit.


-Original Message-
Sent: Thursday, October 25, 2001 1:40 AM
To: Multiple recipients of list ORACLE-L



Depends whether each column has a separate index on it, or all columns are
in a single concatenated index.  An IOT is like the latter - it's only going
to help if you are always using the same (or similar) access path.  


Oracle doesn't go to a table if it can get all the values it needs from an
index.  So, I suspect that the performance of an IOT may not be any better
than a suitable concatenated index.  It simply saves you from storing the
data twice.


> -Original Message-
> From: Kimberly Smith [mailto:[EMAIL PROTECTED]]
> Sent: 24 October 2001 18:55
> To: Multiple recipients of list ORACLE-L
> Subject: Weirdness
> 
> 
> Oracle 8.1.7.1 on HPUX 11 
> 
> I have a table that I have just indexed every column.  This 
> has improved the
> query performance however, its going to slow down the load.  
> Thing that has
> me confused is that I tried this as an IOT and it actually 
> hurt performance.
> This table is joined to another table 3xs.  The table I made 
> an IOT has >2
> million rows and the other table has >6 million rows.  
> Shouldn't the IOT
> table have had similar performance to having every column indexed?
> 
> 
> 
> 
> Kimberly Smith
> GMD Fujitsu
> Database Administrator
> (503) 669-6050
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Kimberly Smith
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California    -- Public Internet access / Mailing Lists
> 
> 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 message (including any attachments) is confidential and may be 
legally privileged.  If you are not the intended recipient, you should 
not disclose, copy or use any part of it - please delete all copies 
immediately and notify the Hays Group Email Helpdesk at
[EMAIL PROTECTED]
Any information, statements or opinions contained in this message
(including any attachments) are given by the author.  They are not 
given on behalf of Hays unless subsequently confirmed by an individual
other than the author who is duly authorised to represent Hays.
 
A member of the Hays plc group of companies.
Hays plc is registered in England and Wales number 2150950.
Registered Office Hays House Millmead Guildford Surrey GU2 4HJ.
**


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Lord, David - C&S
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    -- Public Internet access / Mailing Lists

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.com
-- 
Author: Kimberly Smith
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego

RE: Update invalid trigger_text in DBA_TRIGGERS?

[Larry Elkins]

David,

I would lean towards generating a script for all the triggers (if you don't
already have them), doing a global replace on that, and then executing the
script. TOAD, for example, can easily generate a single script for you
containing all the create or replace trigger statements in a schema. And
while I don't have one handy, I'm sure other list members have scripts to
dump trigger source code where you could accomplish your same goal.

Regards,

Larry G. Elkins
[EMAIL PROTECTED]
214.954.1781

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
> [EMAIL PROTECTED]
> Sent: Thursday, October 25, 2001 2:12 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Update invalid trigger_text in DBA_TRIGGERS?
>
>
>
> I've got 885 triggers with hard-coded fully qualified table names in
> DBA_TRIGGERS.  Problem is, the vendor changed the ownership on these
> tables, and now I've got 885 invalid triggers.  I'd just like to run my
> grand scheme (not to be confused with schema) past you folks,
> give you the
> chance to realize just what an idiot I am, and offer brilliant
> alternatives
> that'll cause lasting envy, jealousy, and self-pity - mostly because the
> suggestions will be simpler, and might actually work.
>
> So much for the introduction.  I thought I'd just go into DBA_TRIGGERS and
> run a replace against the trigger_text.  Since trigger_text is a long data
> type, I don't believe I can use a straight update ..  set ... replace() in
> SQL PLUS.  My plan therefore is to write a quick PL/SQL piece that will
> select the long column into a varchar2, do the replace, then update the
> long column with the edited varchar2 variable.
>
> Is this a realistic strategy?
>
>
>
> David A. Barbour
> Oracle DBA, OCP
> AISD
> 512-414-1002
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> 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.com
-- 
Author: Larry Elkins
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

Link to DB2

[Hamid Alavi]

List,

What's the best solution for linking oracle to DB2
Oracle 8.1.6 on NT2K




Hamid Alavi
Office 818 737-0526
Cell818 402-1987

The information contained in this message and any attachments is intended
only for the use of the individual or entity to which it is addressed, and
may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from
disclosure under applicable law. If you have received this message in error,
you are prohibited from copying, distributing, or using the information.
Please contact the sender immediately by return e-mail and delete the
original message from your system.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hamid Alavi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Update invalid trigger_text in DBA_TRIGGERS?

[Mercadante, Thomas F]

David,

Are you saying the vendor did not provide you with new triggers?

And you haven't sent them a *blistering* email saying that they just
corrupted your production database?

Some things are DBA's problems.  Things that a vendor does to THEIR system
is not one of them.  This is like saying that they changed the names of all
of the database tables in their application, and now you are supposed to
change them in the database.

I agree with Lisa and Rachel - do NOT change anything in the database via
the tables represented by DBA_TRIGGERS.  If you break anything, the vendor
and Oracle will both wash their hands and tell you to restore from a prior
version.

You could try Rachel's suggestion (try it on a couple of triggers and see
what happens).

But the correct thing is to follow Lisa's advice.  The triggers need to be
migrated to the new Oracle schema.

Hope this helps.

Tom Mercadante
Oracle Certified Professional


-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 3:12 PM
To: Multiple recipients of list ORACLE-L



I've got 885 triggers with hard-coded fully qualified table names in
DBA_TRIGGERS.  Problem is, the vendor changed the ownership on these
tables, and now I've got 885 invalid triggers.  I'd just like to run my
grand scheme (not to be confused with schema) past you folks,  give you the
chance to realize just what an idiot I am, and offer brilliant alternatives
that'll cause lasting envy, jealousy, and self-pity - mostly because the
suggestions will be simpler, and might actually work.

So much for the introduction.  I thought I'd just go into DBA_TRIGGERS and
run a replace against the trigger_text.  Since trigger_text is a long data
type, I don't believe I can use a straight update ..  set ... replace() in
SQL PLUS.  My plan therefore is to write a quick PL/SQL piece that will
select the long column into a varchar2, do the replace, then update the
long column with the edited varchar2 variable.

Is this a realistic strategy?



David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Update invalid trigger_text in DBA_TRIGGERS?

[Khedr, Waleed]

Title: RE: Update invalid trigger_text in DBA_TRIGGERS?



Or use 
dynamic SQL like execute immedite 'create or replace 
trigger.'

  -Original Message-From: Koivu, Lisa 
  [mailto:[EMAIL PROTECTED]]Sent: Thursday, October 25, 2001 
  3:28 PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: Update invalid trigger_text in DBA_TRIGGERS?
  David I may be the only one to say this 
  but updating the code directly in the database like that gives me the 
  willies.  Again you may be a database god  and me, the pawn 
  afraid of God Oracle.
  Guess I'd take the strategy of yanking the 
  code out, doing the replace on the code, storing the code in a file somewhere 
  and then running the code with the create or replace trigger 
  statements...
  Heck try it and share your results with 
  us.  
  Lisa Koivu Oracle Database 
  Monkey and Major Couch Potato. Fairfield 
  Resorts, Inc. 954-935-4117 
  
-Original Message- From:   [EMAIL PROTECTED] 
[SMTP:[EMAIL PROTECTED]] Sent:   Thursday, 
October 25, 2001 3:12 PM To: Multiple recipients of list ORACLE-L Subject:    Update invalid trigger_text in DBA_TRIGGERS? 

I've got 885 triggers with hard-coded fully 
qualified table names in DBA_TRIGGERS.  Problem is, the vendor changed the ownership on 
these tables, and now I've got 885 
invalid triggers.  I'd just like to run my grand scheme (not to be confused with schema) past you folks,  
give you the chance to realize just what 
an idiot I am, and offer brilliant alternatives that'll cause lasting envy, jealousy, and self-pity - mostly because 
the suggestions will be simpler, and 
might actually work. 
So much for the introduction.  I thought I'd 
just go into DBA_TRIGGERS and run a 
replace against the trigger_text.  Since trigger_text is a long 
data type, I don't believe I can use a 
straight update ..  set ... replace() in SQL PLUS.  My plan therefore is to write a quick PL/SQL piece 
that will select the long column into a 
varchar2, do the replace, then update the long column with the edited varchar2 variable. 
Is this a realistic strategy? 
David A. Barbour Oracle DBA, OCP AISD 
512-414-1002 
-- Please see 
the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 
  INET: 
[EMAIL PROTECTED] 
Fat City Network Services    -- 
(858) 538-5051  FAX: (858) 538-5051 San Diego, California    -- 
Public Internet access / Mailing Lists  
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: Classes

[Gary Weber]

Dave,

Parallel Server class ruled my world last year :)

Instructor was excellent. She had in-depth knowledge and a good sense of
humor.

Gary Weber
Senior DBA
Charles Jones, LLC||Superior Information Services, LLC
609-530-1144, ext 5529

-Original Message-
Turner
Sent: Thursday, October 25, 2001 3:21 PM
To: Multiple recipients of list ORACLE-L


I've taken all the standard Oracle database administration classes
such as perf tuning, backup and recovery, replication, etc. What I am
looking for is a really good class that's more advanced. Does anyone
have a killer class they recommend?

Thanks, Dave Turner
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: David Turner
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Gary Weber
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Update invalid trigger_text in DBA_TRIGGERS?

[Rachel Carmichael]

um, wouldn't it be easier to create synonyms (under the original owner)
for the table names that point to the new owner and table? and do the
appropriate grants?


--- [EMAIL PROTECTED] wrote:
> 
> I've got 885 triggers with hard-coded fully qualified table names in
> DBA_TRIGGERS.  Problem is, the vendor changed the ownership on these
> tables, and now I've got 885 invalid triggers.  I'd just like to run
> my
> grand scheme (not to be confused with schema) past you folks,  give
> you the
> chance to realize just what an idiot I am, and offer brilliant
> alternatives
> that'll cause lasting envy, jealousy, and self-pity - mostly because
> the
> suggestions will be simpler, and might actually work.
> 
> So much for the introduction.  I thought I'd just go into
> DBA_TRIGGERS and
> run a replace against the trigger_text.  Since trigger_text is a long
> data
> type, I don't believe I can use a straight update ..  set ...
> replace() in
> SQL PLUS.  My plan therefore is to write a quick PL/SQL piece that
> will
> select the long column into a varchar2, do the replace, then update
> the
> long column with the edited varchar2 variable.
> 
> Is this a realistic strategy?
> 
> 
> 
> David A. Barbour
> Oracle DBA, OCP
> AISD
> 512-414-1002
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: 
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> 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!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

Solaris 2.6/8.1.6/Security (Kinda Long)

[Vergara, Michael (TEM)]

Gurus:

This is a question about security, and query-ability.

I have a remote database;  let's call it REMOTE.  I have local 
users who want to query REMOTE, but I cannot create additional 
users there without incurring undue amounts of heartache (not to
mention heartburn!).

I created a local database called SHADOW.  The SHADOW database has
a DBA-level user who owns a private database link to REMOTE.  
SHADOW also has local users defined who wish to query REMOTE.

As DBA in SHADOW, I created a view (as SELECT *) of one of the 
tables on REMOTE.  I then created a public synonym to this view,
and granted select to the local user.

No worries.  So far...so good.

Now an admin-level user wants access to a different table
on REMOTE.  So I did the same thing as for the local non-admin
user.  Created a view.  Created a public synonym.  Granted 
all to the admin user.  Now, however, the local non-admin
user can see and query the admin's table!  This is not what
I want!

All privileges are granted through ROLES, the local user
gets the 'RO' role, and the admin user gets 'ADM' role.  How
can I stop the local non-admin user from seeing (and updating,
since that view allows updates) the admin's table?

Thanks,
Mike

---
===
Michael P. Vergara
Oracle DBA
Guidant Corporation
(909) 914-2304

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Vergara, Michael (TEM)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Classes

[K Gopalakrishnan]

Hi,

If you are interested you can look for DSI Seminar series..
Data Server Internals.

Search for 'internals' in http://www.oracle.com/education.



Best Regards,
K Gopalakrishnan
Bangalore, INDIA
+ (91) 98451 78868

-Original Message-
Sent: Thursday, October 25, 2001 12:21 PM
To: Multiple recipients of list ORACLE-L

I've taken all the standard Oracle database administration classes
such as perf tuning, backup and recovery, replication, etc. What I am
looking for is a really good class that's more advanced. Does anyone
have a killer class they recommend?

Thanks, Dave Turner
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: David Turner
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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!?
Get your free @yahoo.com address at http://mail.yahoo.com

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Update invalid trigger_text in DBA_TRIGGERS?

[Koivu, Lisa]

Title: RE: Update invalid trigger_text in DBA_TRIGGERS?





David I may be the only one to say this but updating the code directly in the database like that gives me the willies.  Again you may be a database god  and me, the pawn afraid of God Oracle.

Guess I'd take the strategy of yanking the code out, doing the replace on the code, storing the code in a file somewhere and then running the code with the create or replace trigger statements...

Heck try it and share your results with us.  


Lisa Koivu
Oracle Database Monkey and Major Couch Potato.
Fairfield Resorts, Inc.
954-935-4117



-Original Message-
From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, October 25, 2001 3:12 PM
To: Multiple recipients of list ORACLE-L
Subject:    Update invalid trigger_text in DBA_TRIGGERS?



I've got 885 triggers with hard-coded fully qualified table names in
DBA_TRIGGERS.  Problem is, the vendor changed the ownership on these
tables, and now I've got 885 invalid triggers.  I'd just like to run my
grand scheme (not to be confused with schema) past you folks,  give you the
chance to realize just what an idiot I am, and offer brilliant alternatives
that'll cause lasting envy, jealousy, and self-pity - mostly because the
suggestions will be simpler, and might actually work.


So much for the introduction.  I thought I'd just go into DBA_TRIGGERS and
run a replace against the trigger_text.  Since trigger_text is a long data
type, I don't believe I can use a straight update ..  set ... replace() in
SQL PLUS.  My plan therefore is to write a quick PL/SQL piece that will
select the long column into a varchar2, do the replace, then update the
long column with the edited varchar2 variable.


Is this a realistic strategy?




David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002


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


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    -- Public Internet access / Mailing Lists

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: Clocks rolling back?

[Paul Del Mastro]

On Alpha OpenVMS there is the system time differential factor.

[EMAIL PROTECTED] wrote:
> 
> Are there any issues with Oracle that I should know about when the clocks
> roll back this weekend?
> 
> Rick Stephenson
> Oracle/Sybase Database Administrator
> [EMAIL PROTECTED]
> Ovid Technologies, Inc.
> 9350 South 150 East, Suite 300
> Sandy, UT 84070
> (801) 304-3000 ext. 2593
> 
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> 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).

-- 
Paul  Del Mastro
City of Raleigh
222 W. Hargett Street
Raleigh, N.C. 27601
(919) 890-3018
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Del Mastro
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

Classes

[David Turner]

I've taken all the standard Oracle database administration classes
such as perf tuning, backup and recovery, replication, etc. What I am 
looking for is a really good class that's more advanced. Does anyone
have a killer class they recommend?

Thanks, Dave Turner
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: David Turner
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

Update invalid trigger_text in DBA_TRIGGERS?

[DBarbour]

I've got 885 triggers with hard-coded fully qualified table names in
DBA_TRIGGERS.  Problem is, the vendor changed the ownership on these
tables, and now I've got 885 invalid triggers.  I'd just like to run my
grand scheme (not to be confused with schema) past you folks,  give you the
chance to realize just what an idiot I am, and offer brilliant alternatives
that'll cause lasting envy, jealousy, and self-pity - mostly because the
suggestions will be simpler, and might actually work.

So much for the introduction.  I thought I'd just go into DBA_TRIGGERS and
run a replace against the trigger_text.  Since trigger_text is a long data
type, I don't believe I can use a straight update ..  set ... replace() in
SQL PLUS.  My plan therefore is to write a quick PL/SQL piece that will
select the long column into a varchar2, do the replace, then update the
long column with the edited varchar2 variable.

Is this a realistic strategy?



David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Commit trigger

[Aponte, Tony]

Title: RE: Commit trigger






This triggered a thought.  Why not use a trigger to insert a row into a "commit notification table".  The row will be visible only upon commit.  A separate session can poll the "commit notification table".

Also, how about Advanced Queues?  I believe the messages can be made visible only upon commit.  The trigger can enqueue a message while the consumer will only see the message after the producer commits.

Tony Aponte


-Original Message-

From: Igor Neyman [mailto:[EMAIL PROTECTED]]

Sent: Thursday, October 25, 2001 2:11 PM

To: Multiple recipients of list ORACLE-L

Subject: Re: Commit trigger



Witold,


Writing into a text file, using UTL_FILE, from within table 'insert' (or

'update', or 'delete')  trigger is a part of the transaction.

So, if changes are not committed, nothing will be written into a text file.

Should work fine for you.


Igor Neyman, OCP DBA

Perceptron, Inc.

(734)414-4627

[EMAIL PROTECTED]



- Original Message -

To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>

Sent: Thursday, October 25, 2001 1:50 PM



> Thanks for the reply.

>

> I guess more details may be helpful.

> I need to get data from one table into a text file. The file needs to

> be generated only once after any changes to the table.

>

> It's easy enough to write a program that queries the table and

> generates a file but I thought about automating the process so that

> the user does not need to run any program. I thought about writing

> a PL/SQL using the UTL_FILE package to generate the file (it's a

> small table). But I would want the trigger to fire only when changes

> are commited, not on every insert, update, or delete. And I need

> only the commited data. I guess I was wondering if there was a

> way to write something like COMMIT_CHANGES_TO_A_TABLE

> trigger.

>

> I guess I will end up with small program but if there was a way to

> do it it would be a good learning.

>

> Thanks

>

> Witold

>

>

> On 25 Oct 2001, at 8:30, Amar Kumar Padhi wrote:

>

> > I am sorry, I actually couldn't understand your query?

> > Do you want a gobal trigger for commit and rollback that would fire

> > irrespective of the change involved at table/view level? Afaik, there is

no

> > such trigger.

> > Normally, your table/view level triggers would fire as per the event and

> > apply the change only when commit is done. Same way the changes done via

a

> > trigger would be removed on rollback.

> >

> > Please let the list know what you would actually intend to do if such an

> > option is provided.

> >

> > rgds

> > amar

> >

> >

> >

> > -Original Message-

> > Sent: Thursday, October 25, 2001 7:45 PM

> > To: Multiple recipients of list ORACLE-L

> >

> >

> > Hello

> >

> > My life would be easier ;-) if there was a commit (and rollback)

> > trigger - Oracle 8i. I did some research and found various database-

> > level triggers but couldn't find COMMIT and ROLLBACK event

> > triggers. Can one actually write a code that would be fired only at

> > COMMIT and/or ROLLBACK event?

> >

> > Thanks

> >

> > Witold

> > --

> > Please see the official ORACLE-L FAQ: http://www.orafaq.com

> > --

> > Author: Witold Iwaniec

> >   INET: [EMAIL PROTECTED]

> >

> > Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

> > San Diego, California    -- Public Internet access / Mailing Lists

> > 

> > 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.com

> --

> Author: Witold Iwaniec

>   INET: [EMAIL PROTECTED]

>

> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

> San Diego, California    -- Public Internet access / Mailing Lists

> 

> 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.com

-- 

Author: Igor Neyman

  INET: [EMAIL PROTECTED]


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

San Diego, California    -- Public Internet access / Mailing Lists



To REMOVE yourself from this mailing list, send an E-Mail message

to: [EMAIL PROTECTED] (note E

RE: Commit trigger

[Khedr, Waleed]

I do not think this is right even I did not use it.
If this is right then this means that the whole operation is buffered until
it gets committed which contradicts with FFLUSH.

For the original question: a Table trigger + PL/SQL package to memorize the
visit to the trigger and avoid repeating the same action + dbms_job (write
to the file) ===> might be the solution.

Regards,

Waleed

-Original Message-
Sent: Thursday, October 25, 2001 2:11 PM
To: Multiple recipients of list ORACLE-L


Witold,

Writing into a text file, using UTL_FILE, from within table 'insert' (or
'update', or 'delete')  trigger is a part of the transaction.
So, if changes are not committed, nothing will be written into a text file.
Should work fine for you.

Igor Neyman, OCP DBA
Perceptron, Inc.
(734)414-4627
[EMAIL PROTECTED]


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, October 25, 2001 1:50 PM


> Thanks for the reply.
>
> I guess more details may be helpful.
> I need to get data from one table into a text file. The file needs to
> be generated only once after any changes to the table.
>
> It's easy enough to write a program that queries the table and
> generates a file but I thought about automating the process so that
> the user does not need to run any program. I thought about writing
> a PL/SQL using the UTL_FILE package to generate the file (it's a
> small table). But I would want the trigger to fire only when changes
> are commited, not on every insert, update, or delete. And I need
> only the commited data. I guess I was wondering if there was a
> way to write something like COMMIT_CHANGES_TO_A_TABLE
> trigger.
>
> I guess I will end up with small program but if there was a way to
> do it it would be a good learning.
>
> Thanks
>
> Witold
>
>
> On 25 Oct 2001, at 8:30, Amar Kumar Padhi wrote:
>
> > I am sorry, I actually couldn't understand your query?
> > Do you want a gobal trigger for commit and rollback that would fire
> > irrespective of the change involved at table/view level? Afaik, there is
no
> > such trigger.
> > Normally, your table/view level triggers would fire as per the event and
> > apply the change only when commit is done. Same way the changes done via
a
> > trigger would be removed on rollback.
> >
> > Please let the list know what you would actually intend to do if such an
> > option is provided.
> >
> > rgds
> > amar
> >
> >
> >
> > -Original Message-
> > Sent: Thursday, October 25, 2001 7:45 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Hello
> >
> > My life would be easier ;-) if there was a commit (and rollback)
> > trigger - Oracle 8i. I did some research and found various database-
> > level triggers but couldn't find COMMIT and ROLLBACK event
> > triggers. Can one actually write a code that would be fired only at
> > COMMIT and/or ROLLBACK event?
> >
> > Thanks
> >
> > Witold
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Witold Iwaniec
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > 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.com
> --
> Author: Witold Iwaniec
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> 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.com
-- 
Author: Igor Neyman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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 offic

RE: Object-Oriented Tools

[Aponte, Tony]

Title: RE: Object-Oriented Tools






We used it many moons ago with version 7.32.  It turned out to be more complicated to administer and code than we ever anticipated so it was put to pasture.  You're right in that many of the OO functionality is included in the newer versions,  and what's not can be provided with Java in the database.  We acquired it as a means to keep the database access code agnostic of the DBMS used but it suffered from (self-inflicted) poor implementation.  Eventually, the conclusion was reached that the cost of this agnosticism was ridiculous and the whole Persistence layer was eliminated from the application.  The client connections go straight to the database via Net8.  One additional side-effect was that we can use all of the Oracle security features available where as before the application handled the user account privileges in the Persistence layer.  This gave us visibility over who/what/where/how data was being manipulated.

HTH

Tony Aponte


-Original Message-

From: Carle, William T (Bill), NLCIO [mailto:[EMAIL PROTECTED]]

Sent: Thursday, October 25, 2001 12:50 PM

To: Multiple recipients of list ORACLE-L

Subject: Object-Oriented Tools



Hi,


    We use a product called Persistence that takes C++ code and makes the

Oracle (or any relational) database look like an object-oriented database.

Does anyone else use these sorts of tools? I'm not an object-oriented guru

by any means so forgive me if I sound a bit vague. Isn't Oracle capable of

doing the same thing? What is the best tool for this?



Bill Carle

AT&T

Database Administrator

816-995-3922

[EMAIL PROTECTED]


-- 

Please see the official ORACLE-L FAQ: http://www.orafaq.com

-- 

Author: Carle, William T (Bill), NLCIO

  INET: [EMAIL PROTECTED]


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

San Diego, California    -- Public Internet access / Mailing Lists



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).

i need check fragmentation of index

[Alexander Ordonez]

hi gurus, how check the fragmentation on index...??
ahy idea???
please i need your help!!

@lex

  Lic. Alexander Ordóñez Arroyo 
  Caja Costarricense del Seguro Social 
  Soporte Técnico - División de Informática 
  Telefono: 295-2004, San José, Costa Rica
  [EMAIL PROTECTED]Icq# 30173325


The true is out there in WWW


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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: analyze causing waits on dlm cr request queue latch

[Mohan, Ross]

It may not be OPS, butis it installed?

is your dbms clustered, or was it?

I have seen it in " stand alone " databases which
used to be OPS-aware and the other instance is
down.

but..older versions of oracle.certainly not cRAC, 
or whatever. 

hth

- ross

-Original Message-
Sent: Thursday, October 25, 2001 1:59 PM
To: Multiple recipients of list ORACLE-L


Good morning/afternoon/evening.

An "analyze schema" job kicked off overnight (I believe it uses
dbms_utility.analyze_schema, but I don't have access to the source at
the moment) was still running when people came in to work this morning.
 Many user sessions began hanging with a wait on the dlm cr request
queue latch.  My understanding of dlm latches is that they are
associated with Parallel Server systems, and this is not a Parallel
Server database.  Has anyone seen this before?  

TIA,




=
Paul Baumgartel, Adept Computer Associates, Inc.
[EMAIL PROTECTED]





__
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Mohan, Ross
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Object-Oriented Tools

[DENNIS WILLIAMS]

Bill - I have been interested in this because we are starting to develop in
Java. The feedback I have been getting is that what you are describing
hasn't worked out in the long run. My interpretation is that relational
techniques are quite robust and mature, and it is not difficult for
object-oriented programmers to adapt to the relational schema (should be
limited to a few objects). Most applications have non-object-oriented tools
that need access also. Appreciate anyone else's experiences.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Thursday, October 25, 2001 11:50 AM
To: Multiple recipients of list ORACLE-L


Hi,

We use a product called Persistence that takes C++ code and makes the
Oracle (or any relational) database look like an object-oriented database.
Does anyone else use these sorts of tools? I'm not an object-oriented guru
by any means so forgive me if I sound a bit vague. Isn't Oracle capable of
doing the same thing? What is the best tool for this?


Bill Carle
AT&T
Database Administrator
816-995-3922
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Carle, William T (Bill), NLCIO
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Clocks rolling back?

[IT - Database (Do Not Use)]

I believe that POINT IN TIME recoveries can be a little tricky if you are
unlucky enough to have a problem during the  0100-02000hrs time frame.


-Original Message-
Sent: Thursday, October 25, 2001 10:25 AM
To: Multiple recipients of list ORACLE-L


Are there any issues with Oracle that I should know about when the clocks
roll back this weekend?

Rick Stephenson
Oracle/Sybase Database Administrator
[EMAIL PROTECTED]
Ovid Technologies, Inc.
9350 South 150 East, Suite 300
Sandy, UT 84070
(801) 304-3000 ext. 2593

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: IT - Database (Do Not Use)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Concealing SQL Loader password from ps -ef

[Johnston, Tim]

Title: RE: Concealing SQL Loader password from ps -ef





You could also use a parameter file... Look at the utilities manual under the command line reference...  The example from Oracle is...

PARFILE specifies the name of a file that contains commonly used command-line parameters. For example, the command line could read: 

sqlldr parfile=example.par


The parameter file could have the following contents: 


userid=scott/tiger
control=example.ctl
errors=
log=example.log



-Original Message-
From: Bellows, Bambi [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 1:51 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Concealing SQL Loader password from ps -ef



The << operator creates a set of commands to be executed until a particular
label as part of the calling command and only the calling command is
displayed on ps -ef.  This should work the same for sqlloader as it does for
sqlplus or ftp or su or whatever else.  Just put the username/password on
the inside of the << operator and you should be golden.


HTH,
Bambi.
===


sqlplus << EOF
system/incredibly_secret_password
select * from dual;
exit
EOF




-Original Message-
Sent: Thursday, October 25, 2001 11:56 AM
To: Multiple recipients of list ORACLE-L


When running Sql Loader from a Unix script is there a way to code it so that
the password will not be displayed when someone does ps -ef?


I know how to do it for sqlplus, exp and imp but not sql loader.


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


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    -- Public Internet access / Mailing Lists

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.com
-- 
Author: Bellows, Bambi
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    -- Public Internet access / Mailing Lists

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: Java in the database

[Igor Neyman]

Still PL/SQL.
Hope, it will be supported long enough. (till my retirement? :)

Igor Neyman, OCP DBA
Perceptron, Inc.
(734)414-4627
[EMAIL PROTECTED]


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, October 25, 2001 1:16 PM


Out of curiosity, is anyone using the java engine for procedural code, or
are most people still using PL/SQL?

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED] 

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Igor Neyman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: How to query Standby database ...

[Larry Strickland]

Anjan,

First off, the answer to your question is to make sure that
REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE is set in the paramter file for your
DB and that you have used orapwd to create a (current) password file with
an appropriate password.  Then login as internal/that_secret_password or
as sys/your_sys_password and it should work fine.

Having just been through this, let me suggest STRONGLY that you abandon
this line of attack.  I had a Perl program that did exactly what you are
trying to do and woke up every 15 minutes to erase logfiles.  However --
and I'm not sure exactly how -- the database got updated before the actual
log was finished and the program deleted the logfile, causing me a lot of
grief since I didn't see it for some days and... well the story gets
pretty ugly from that point on.

Now, I use a program (also Perl) that parses the alert log and deletes
archive logs based on what is in the alert log.  It has worked very, very
nicely for the last month...

larry

On Thu, 25 Oct 2001 09:25:22 -0800620
"Anjan Thakuria" <[EMAIL PROTECTED]> wrote:

> Hi,
> 
> We have a standby environment where due to application constraints we
> have to apply logs based on the application progress.
> 
> However before I was made responsible the remote archiving was not
> enabled, and files were transferred through a script.  Now to clear the
> archive dest I need to write a script to delete only the logs that have
> been backed up and applied. So here are my questions...
> 
> 1.On the standby host I can get into the database -- sqlplus '/ as
> sysdba' . How can I get onto it remotely since I need to get in as
> somebody as SYSDBA. If I try
> 
> sqlplus '"sys/password@connect_string as sysdba'"  it still asks me for
> a password. What am I doing wrong.
> 
> 
> 2. This is an academic question. Am  I correct in assuming that
> password changes done in the production is passed onto the standby
> database.
> 
> 3.I try to logon to the standby database locally as follows
> 
> sqlplus 'sys as sysdba' and get the following.. ORA-01033 Oracle
> initialization or shutdown in progress
> 
> 
> Any help will be greatly appreciated.
> 
> 
> Thanks
> 
> Anjan
> 
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Larry Strickland
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Commit trigger

[Igor Neyman]

Witold,

Writing into a text file, using UTL_FILE, from within table 'insert' (or
'update', or 'delete')  trigger is a part of the transaction.
So, if changes are not committed, nothing will be written into a text file.
Should work fine for you.

Igor Neyman, OCP DBA
Perceptron, Inc.
(734)414-4627
[EMAIL PROTECTED]


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, October 25, 2001 1:50 PM


> Thanks for the reply.
>
> I guess more details may be helpful.
> I need to get data from one table into a text file. The file needs to
> be generated only once after any changes to the table.
>
> It's easy enough to write a program that queries the table and
> generates a file but I thought about automating the process so that
> the user does not need to run any program. I thought about writing
> a PL/SQL using the UTL_FILE package to generate the file (it's a
> small table). But I would want the trigger to fire only when changes
> are commited, not on every insert, update, or delete. And I need
> only the commited data. I guess I was wondering if there was a
> way to write something like COMMIT_CHANGES_TO_A_TABLE
> trigger.
>
> I guess I will end up with small program but if there was a way to
> do it it would be a good learning.
>
> Thanks
>
> Witold
>
>
> On 25 Oct 2001, at 8:30, Amar Kumar Padhi wrote:
>
> > I am sorry, I actually couldn't understand your query?
> > Do you want a gobal trigger for commit and rollback that would fire
> > irrespective of the change involved at table/view level? Afaik, there is
no
> > such trigger.
> > Normally, your table/view level triggers would fire as per the event and
> > apply the change only when commit is done. Same way the changes done via
a
> > trigger would be removed on rollback.
> >
> > Please let the list know what you would actually intend to do if such an
> > option is provided.
> >
> > rgds
> > amar
> >
> >
> >
> > -Original Message-
> > Sent: Thursday, October 25, 2001 7:45 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Hello
> >
> > My life would be easier ;-) if there was a commit (and rollback)
> > trigger - Oracle 8i. I did some research and found various database-
> > level triggers but couldn't find COMMIT and ROLLBACK event
> > triggers. Can one actually write a code that would be fired only at
> > COMMIT and/or ROLLBACK event?
> >
> > Thanks
> >
> > Witold
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Witold Iwaniec
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing Lists
> > 
> > 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.com
> --
> Author: Witold Iwaniec
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> 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.com
-- 
Author: Igor Neyman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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 Reports....

[Raj Gopalan]

Give a try by tracing the session used by the report.

-Original Message-
Sent: 25 October 2001 16:05
To: Multiple recipients of list ORACLE-L


Thanks Rachel,

I'll check these tables to see what dets they hold. The problem I have is
that I can't phone the user and say "are you running that report", because
they have a big nasty lady who will come and bite my head off if she thinks
we're actually trying to help!!

;o)

Kev.
"hit any user to continue"
__

Kevin Thomas
Technical Analyst
Deregulation Services
Calanais Ltd.
(2nd Floor East - Weirs Building)
Tel: 0141 568 2377
Fax: 0141 568 2366
http://www.calanais.com


-Original Message-
Sent: 25 October 2001 14:35
To: Multiple recipients of list ORACLE-L


you should be able to pull the queries out of v$sql, v$sqlarea and/or
v$sqltext

--- "Thomas, Kevin" <[EMAIL PROTECTED]> wrote:
> Hi all,
> 
> Sorry about the non-DBA related post...but I reckon you guys will be
> able to
> point me in the right direction!
> 
> Our client is running some Oracle Reports (v2.5) that are killing our
> database, in that the queries contained in them have an average hit
> rate of
> less than 2%!!! Guess what, it get's better, they don't have the
> source code
> anymore!! Is there a way of either a) re-engineering the executable,
> or b) a
> third party tool that will extract the queries or show the report in
> a text
> version (?!?).
> 
> Any thoughts guru-type-people ;o)
> 
> Kev.
> 
> "hit any user to continue"
> __
> 
> Kevin Thomas
> Technical Analyst
> Deregulation Services
> Calanais Ltd.
> (2nd Floor East - Weirs Building)
> Tel: 0141 568 2377
> Fax: 0141 568 2366
> http://www.calanais.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Thomas, Kevin
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> 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!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Thomas, Kevin
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Raj Gopalan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Commit trigger

[Jamadagni, Rajendra]

You could write your own mechanism ... by making use of dbms_alerts. You can
raise an alert on commit, have a process wait on that alert and as soon as
it gets the alert, get the data that you need. More information about the
package is available in the docs. 

HTH
Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art !



*2

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: Java in the database

[Jeff Wiegard]

Yes, I'd be interested to hear about peoples experience too. We developed a web portal 
for WWWRRR Inc. It was a Servlet framework. We found more success avoiding Oracle's 
Java technologies, as you're stuck with outdated Java classes, and/or Oracle-specific 
Java classes. Try getting the OCI drivers to work. It is an effort of a scale similar 
to the hunt for Osama ...

>>> [EMAIL PROTECTED] 10/25/01 12:16PM >>>
Out of curiosity, is anyone using the java engine for procedural code, or
are most people still using PL/SQL?

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED]  

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
--
Author: Jeff Wiegard
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Clocks rolling back?

[Boivin, Patrice J]

Last year in Autumn one of my NT servers failed to run AT jobs the night
that the time change took place, you may want to watch for that.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED]  

-Original Message-
From:   [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent:   Thursday, October 25, 2001 2:30 PM
To: Multiple recipients of list ORACLE-L
Subject:Re:Clocks rolling back?

None that I've come across in the last 20 years.  GOD, has it been
that long?!

Dick Goulet

Reply Separator
Author: [EMAIL PROTECTED]
Date:   10/25/2001 8:25 AM

Are there any issues with Oracle that I should know about when the
clocks
roll back this weekend?

Rick Stephenson
Oracle/Sybase Database Administrator
[EMAIL PROTECTED]
Ovid Technologies, Inc.
9350 South 150 East, Suite 300
Sandy, UT 84070
(801) 304-3000 ext. 2593

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists

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.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
Lists

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.com
--
Author: Boivin, Patrice J
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Move tablespace with no downtime?

[Rachel Carmichael]

ooh Jeremiah, that's sneaky... I like it. This one is a keeper :)


--- Jeremiah Wilton <[EMAIL PROTECTED]> wrote:
> Here's a trick I like to reduce the downtime associated with moving
> large datafiles:
> 
> 1. Place the tablespace that contains the file(s) you want to move
>into backup mode:
>- alter tablespace  begin backup;
> 
> 2. Copy the file(s):
>- cp  
>- If you are moving multiple files, you can do this in parallel
> 
> 3. Take the tablespace out of backup mode:
>- alter tablespace  end backup;
> 
> 4. (Now the very brief downtile begins)
>Take the tablespace offline immediate
>- alter tablespace  offline immediate;
> 
> 5. Issue the rename:
>- alter database rename file  to ;
> 
> 6. Recover the new file(s) or the whole tablespace (should be quite
>brief)
>- recover [datafile|tablespace] ;
> 
> 7. (Now the very brief downtime ends)
>Bring the tablespace online again:
>- alter tablespace  online;
> 
> --
> Jeremiah Wilton
> http://www.speakeasy.net/~jwilton
> 
> On Thu, 25 Oct 2001, Rachel Carmichael wrote:
> 
> > depends on what you mean by downtime.
> >
> > yes you can do it without taking down the database and the
> instance,
> > no, you can't do it without at least taking the tablespace offline.
> >
> > alter tablespace x offline;
> > in os, make a copy of all datafiles in the new location
> > alter database move file 'y' to 'z';
> >   
> > alter tablespace online;
> >
> >
> > --- Greg Moore <[EMAIL PROTECTED]> wrote:
> > > Can I move a tablespace and all it's associated datafiles to a
> new
> > > disk
> > > device with no downtime?
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Greg Moore
> > >   INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services-- (858) 538-5051  FAX: (858)
> 538-5051
> > > San Diego, California-- Public Internet access / Mailing
> > > Lists
> > >
> 
> > > 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!?
> > Make a great connection at Yahoo! Personals.
> > http://personals.yahoo.com
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Rachel Carmichael
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> > San Diego, California-- Public Internet access / Mailing
> Lists
> >
> 
> > 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.com
> -- 
> Author: Jeremiah Wilton
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing
> Lists
> 
> 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!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

analyze causing waits on dlm cr request queue latch

[Paul Baumgartel]

Good morning/afternoon/evening.

An "analyze schema" job kicked off overnight (I believe it uses
dbms_utility.analyze_schema, but I don't have access to the source at
the moment) was still running when people came in to work this morning.
 Many user sessions began hanging with a wait on the dlm cr request
queue latch.  My understanding of dlm latches is that they are
associated with Parallel Server systems, and this is not a Parallel
Server database.  Has anyone seen this before?  

TIA,




=
Paul Baumgartel, Adept Computer Associates, Inc.
[EMAIL PROTECTED]





__
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Commit trigger

[Witold Iwaniec]

Thanks for the reply. 

I guess more details may be helpful.
I need to get data from one table into a text file. The file needs to 
be generated only once after any changes to the table. 

It's easy enough to write a program that queries the table and 
generates a file but I thought about automating the process so that 
the user does not need to run any program. I thought about writing 
a PL/SQL using the UTL_FILE package to generate the file (it's a 
small table). But I would want the trigger to fire only when changes 
are commited, not on every insert, update, or delete. And I need 
only the commited data. I guess I was wondering if there was a 
way to write something like COMMIT_CHANGES_TO_A_TABLE 
trigger.

I guess I will end up with small program but if there was a way to 
do it it would be a good learning.

Thanks

Witold


On 25 Oct 2001, at 8:30, Amar Kumar Padhi wrote:

> I am sorry, I actually couldn't understand your query?
> Do you want a gobal trigger for commit and rollback that would fire
> irrespective of the change involved at table/view level? Afaik, there is no
> such trigger. 
> Normally, your table/view level triggers would fire as per the event and
> apply the change only when commit is done. Same way the changes done via a
> trigger would be removed on rollback. 
> 
> Please let the list know what you would actually intend to do if such an
> option is provided.
> 
> rgds
> amar
> 
> 
> 
> -Original Message-
> Sent: Thursday, October 25, 2001 7:45 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Hello
> 
> My life would be easier ;-) if there was a commit (and rollback) 
> trigger - Oracle 8i. I did some research and found various database-
> level triggers but couldn't find COMMIT and ROLLBACK event 
> triggers. Can one actually write a code that would be fired only at 
> COMMIT and/or ROLLBACK event?
> 
> Thanks
> 
> Witold
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Witold Iwaniec
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> 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.com
-- 
Author: Witold Iwaniec
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

Oracle 8.1.6 (8i) installation

[Richard O'Mahony]

Hi All,
I am relativly new to Oracle and I am having a problem installing Oracle
8.1.6 on a sparc ultra 10 running solaris 8. The problem arises when it
reaches the linking stage of the installation. The error message that
appears on the screen says

Error n invoking target ntcontab.0 of
makefile
/vendor/oracle/network/lib/ins_net_client.mk

in the log file it says
Exception thrown from action: make
Exception Name: MakefileException
Exception String: Error in invoking target ntcontab.o of 
makefile
/vendor/oracle/network/lib/ins_net_client.mk
Exception Severity: 1

If i do an ls -al on /usr/ccs/bin/make I get
-rwxrwxr-x   1 root other 273196 Oct 25 16:10 
/usr/ccs/bin/make

Also here is the contents of the /etc/system file
set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=20
set shmsys:shminfo_shmmin=1
set semsys:seminfo_semmni=100
set semsys:seminfo_semmns=200
set semsys:seminfo_semmsl=100
set semsys:seminfo_semopn=100
set semsys:seminfo_semvmx=32767
forceload: sys/shmsys
forceload: sys/semsys

One thing to note is that the version of make I am running is
make-3.77-sol7-sparc-local, inorder to get a make binary in the /usr/ccs/bin
directory I copied it from another machine (it did not seem to get installed
there during the make installation). A solution to this problem is urgent
and I would appreciate any ideas anyone may have I have tried jst about
everything I can think of.
Thanks.
Richard...

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Richard O'Mahony
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Concealing SQL Loader password from ps -ef

[Bellows, Bambi]

The << operator creates a set of commands to be executed until a particular
label as part of the calling command and only the calling command is
displayed on ps -ef.  This should work the same for sqlloader as it does for
sqlplus or ftp or su or whatever else.  Just put the username/password on
the inside of the << operator and you should be golden.

HTH,
Bambi.
===

sqlplus << EOF
system/incredibly_secret_password
select * from dual;
exit
EOF



-Original Message-
Sent: Thursday, October 25, 2001 11:56 AM
To: Multiple recipients of list ORACLE-L

When running Sql Loader from a Unix script is there a way to code it so that
the password will not be displayed when someone does ps -ef?

I know how to do it for sqlplus, exp and imp but not sql loader.

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Bellows, Bambi
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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:Clocks rolling back?

[dgoulet]

None that I've come across in the last 20 years.  GOD, has it been that long?!

Dick Goulet

Reply Separator
Author: [EMAIL PROTECTED]
Date:   10/25/2001 8:25 AM

Are there any issues with Oracle that I should know about when the clocks
roll back this weekend?

Rick Stephenson
Oracle/Sybase Database Administrator
[EMAIL PROTECTED]
Ovid Technologies, Inc.
9350 South 150 East, Suite 300
Sandy, UT 84070
(801) 304-3000 ext. 2593

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).

How to query Standby database ...

[Anjan Thakuria]

Hi,
We have a standby environment where due to application constraints we
have to apply logs based on the application progress.
However before I was made responsible the remote archiving was not enabled,
and files were transferred through a script.  Now to clear the archive
dest I need to write a script to delete only the logs that have been backed
up and applied. So here are my questions...
1.    On the standby host I can get into the database
-- sqlplus '/ as sysdba' . How can I get onto it remotely since I need
to get in as somebody as SYSDBA. If I try
sqlplus '"sys/password@connect_string as sysdba'"  it still asks
me for a password. What am I doing wrong.
 
2. This is an academic question. Am  I
correct in assuming that password changes done in the production is passed
onto the standby database.
3.    I try to logon to the standby database locally
as follows
sqlplus 'sys as sysdba' and get the following.. ORA-01033 Oracle
initialization or shutdown in progress
 
Any help will be greatly appreciated.
 
Thanks
Anjan
 

Java in the database

[Boivin, Patrice J]

Out of curiosity, is anyone using the java engine for procedural code, or
are most people still using PL/SQL?

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services| Services technologiques
Informatics Branch | Direction de l'informatique 
Maritimes Region, DFO  | Région des Maritimes, MPO

E-Mail: [EMAIL PROTECTED]  

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Sql not exists

[Larry Elkins]

Kimberly,

But you were right in the first place ;-)

An outer join, with a little twist (line 4), can be used for anti-joins
(item a not in b)

SQL> select d.deptno
  2  from   dept d, emp e
  3  where  d.deptno = e.deptno (+)
  4and  e.deptno is null
  5  /

DEPTNO
--
40

I don't see many people use the approach above, but, it is valid. It does
confuse some people when they first see it. But if you really want to
confuse folks and make the code a little more difficult to maintain, you can
try some more obscure (or simply double negation) methods:

  1  select d.deptno
  2  from   dept d, emp e
  3  where  not d.deptno <> e.deptno (+)
  4*   and  not e.deptno is not null
SQL> /

DEPTNO
--
40

  1  select deptno
  2  from dept
  3* where not deptno = any (select deptno from emp)
SQL> /

DEPTNO
--
40

  1  select deptno
  2  from dept
  3* where deptno <> all (select deptno from emp)
SQL> /

DEPTNO
--
40


And has anyone provide a NOT IN example yet? We got the basics of MINUS, NOT
EXISTS, and a null OUTER JOIN.

Regards,

Larry G. Elkins
[EMAIL PROTECTED]
214.954.1781

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Kimberly
> Smith
> Sent: Thursday, October 25, 2001 11:16 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Sql not exists
>
>
> Opps, I responding to this just a second ago and recommended outer join.
> Then I saw this response and it made me reread the question.  Duh!  More
> coffee please.
>
> -Original Message-
> Sent: Thursday, October 25, 2001 3:20 AM
> To: Multiple recipients of list ORACLE-L
>
>
> select id from table1
> minus
> select id from table2
>
> -Original Message-
> Sent: 25 October 2001 09:35
> To: Multiple recipients of list ORACLE-L
>
>
>
>
> Hallo you  DBA'
>
> Can anyone give me a good example on a sql select statement checking which
> ids exists in table one but not in table two? Table two also contains the
> corresponding id field but with other field names besides. Like this
>
> Table 1: Id Name  Year
> Table 2: :Id   City   Country
>
> Thanks in advance
>
> Roland Sköldblom

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

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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: Speaking the same language

[Mark Leith]

Hi Djordje,

You are right in saying that the terminology within SQLServer and Sybase are
very similar - in fact I don't know of any differences.. They are both bred
from the same monster back in the days of Ashton Tate :)

I would make one change with your list:

In SQLServer and Sybase, an Oracle Tablespace is called a Database, not a
filegroup. So an Oracle schema is not a Database.

=
Oracle  SqlServer
DB2 Sybase
=
DatabaseServer
Sys schema  Primary File group
Tablespace  Database
SYSTEM tablespace   Master database
other schemas   "Data" File group
Temp tablespace TempDB database
Redo log file   Log file
Database block  Page
Extent  Extent (8 pages -> 64K).
(multiple of blocks)Can be shared by logical objects.
SessionsProcesses
Data dictionary System catalogue
=
Data dictionary views   System catalogue tables
=
dba_objects sysobjects
dba_tab_columns syscolumns
dba_indexes sysindexes
dba_users   sysusers
dba_data_files  sysfiles
v$lock  syslocks
v$session   sysprocesses

There are a few more, but they don't jump to mind at the moment, and I'm off
home now to spend some time with my little girl :)

I'd be interested in a more complete list if you do come up with one. Maybe
I could post it to a web site? hmmm..

HTH

Mark

-Original Message-
Jankovic
Sent: Wednesday, October 24, 2001 23:10
To: Multiple recipients of list ORACLE-L


We need to communicate inside a team made of DBAs that support different
database platforms: oracle, sql*server, Sybase, adabase (Am I wrong that
sql*server and sybase terminology is pretty much the same?).  There are some
terminology differences between different databases (to start with the word
"database" that means different in oracle and sql*server world).  I have
tried to compile a start terminology difference list.  If you could
contribute to the list you can send an e-mail to me directly, I would
compile the list and send the compiled version to the list.  If you don't
hear back from me that probably means that the list was not very responsive
:-(.  Also, please let me know if you think some terminology is wrong in
this list.

Thanks.

Djordje Jankovic
[EMAIL PROTECTED]


Oracle  SqlServer
DB2

DatabaseServer
Schema  Database
Sys schema  Master database
Tablespace  File group
SYSTEM tablespace   Primary data file
other tablespaces   Secondary data files
Redo log file   Log file
Database block  Page
Extent  Extent (8 pages -> 64K).
(multiple of blocks)  Can be shared by logical objects.
Data dictionary System catalog


Data dictionary views   System catalog tables
dba_objects sysobjects
dba_tab_columns syscolumns
dba_indexes sysindexes
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Djordje Jankovic
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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.com
-- 
Author: Mark Leith
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

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).