RE: newbie sqlplus ?

Title: RE: newbie sqlplus ? If that is where you want to put all of your database files than yes. I think that starting out, a single location will be fine. As you learn more about the database you'll find that spreading the database out among server different physical disks is key to

Re: Embeded password in script

$cd ${STUFF}/log $cat ../parms/dbimpl.Connect connect dbimpl/[EMAIL PROTECTED] as sysdba -- Optionally, could have sql*plus environment modifications $cat ../sql/demo.sql @../parms/1..Connect -- SQL commands shutdown exit $sqlplus /nolog @../sql/demo.sql dbimpl The unix permissions on the parms

Re: How long to hold onto old Oracle CDs?

On the local level (eg Denmark) they might have a CD or they might not. There won't be a centralised, systematic archiving effort. Frankly, when I was in Support, I would sometimes contact a customer that I knew had a certain (old) version and have them ship a copy or lend it to me, so that I

RE: slow insert

Thanks for the inputs. Here are some important results. 1)The insert into Original table with 43million records takes about 10minutes and the explain plan as attached in the text file original table insert into original table... select ... from a,b where a.col1=b.col1 ---index columns

Re: corrupted block

Metalink Note 130605.1 is worth reading about setting Maxcorrupt for an RMAN whole database backup (and checking alert.log for corruption messages). Metalink Note 207413.1 describes RMAN incorrectly reporting block corruption. Bugs 2068275, 1849726, and 1802432 may be interesting

RE: Problem starting Oracle on W2K

Hi I remembered On Windows platforms, the OracleServiceSID service must be started before connecting to the instance using SVRMGRL. thanks Banarasi Babu T OCP, DBA -Original Message- Sent: Tuesday, February 25, 2003 2:24 AM To: Multiple recipients of list ORACLE-L Hi ... oracle

Re: Problem starting Oracle on W2K

set ORACLE_HOME=d:\oracle\ora81 set ORACLE_SID=everest lsnrctl start net start OracleServiceeverest svrmgrl @startora.sql The windows service has to be started before connect internal works. Have Fun :) [EMAIL PROTECTED] wrote: Hi ... oracle 817 ee os - win2k sp3 since i dont want oracle to

RE: Which is beter a cursor or a for loop?

Title: RE: Which is beter a cursor or a for loop? Thanks everyone! Regards Denham -Original Message- From: Connor McDonald [mailto:[EMAIL PROTECTED]] Sent: Monday, February 24, 2003 4:59 PM To: Multiple recipients of list ORACLE-L Subject: Re: Which is beter a cursor or a for

OS Kill

hi list one session in our database is in ACTIVE state since long. it is doing no activity at all. it has locked one table also. because of this other sessions are also in ACTIVE state. so it is required for us to kill the session. i got the corresponding spid for that session from v$process.

Re: newbie sqlplus ?

Reading "The OFA standard: Oracle for Open Systems" could be helpful: http://www.hotsos.com/catalog/ An OFA compliant setup looks a bit different: $ORACLE_BASE=/db/oracle $ORACLE_HOME=/db/oracle/product/8.1.7 The Admin directories could be: /db/oracle/admin/817db1

Re: newbie sqlplus ?

Title: RE: newbie sqlplus ? Using my setup or my example of folders, how would you setup a db? I want to see what I'm failing to see. Thx for the reply - Original Message - From: Chris Stephens To: Multiple recipients of list ORACLE-L Sent: Monday, February 24,

<    1   2   3