RE: Problem starting Oracle on W2K

Thanks Chip ! well then if the service is started, i dont need the startora.sql !!! -Original Message- Sent: Tuesday, February 25, 2003 12:34 AM To: Multiple recipients of list ORACLE-L set ORACLE_HOME=d:\oracle\ora81 set ORACLE_SID=everest lsnrctl start net start OracleServiceeverest

RE: Event Triggers in 8i ?

Bob, here is the code : CREATE OR REPLACE TRIGGER bef_dbshutdown BEFORE SHUTDOWN ON DATABASE BEGIN insert into db_updown_log(log_date) values(sysdate); END; / u just have to replace the insert statement with whatever u want. also, doesnt matter under what schema u create the trigger.

RE: SQL struggle - UPDATE too?

Saira : how do u want to achive this ? using procedure or a single update stmt ? -Original Message- Somani Sent: Tuesday, February 25, 2003 3:27 PM To: Multiple recipients of list ORACLE-L I am very confused (and fairly new to SQL which would be my excuse to post such amateurish

Problem starting Oracle on W2K

Hi ... oracle 817 ee os - win2k sp3 since i dont want oracle to start always on my home pc, i have changed the services to manual. whenever i want oracle, i run the below batch file : set ORACLE_HOME=d:\oracle\ora81 set ORACLE_SID=everest lsnrctl start svrmgrl @startora.sql /* startora.sql */

RE: select count(case ...) slow in PL/SQL, any better way?

I too faced the problem of case not working in pl/sql procedures. So I created a view. Would creating a view work for you ? -Original Message- Sent: Monday, February 24, 2003 3:07 PM To: Multiple recipients of list ORACLE-L Hi: Oracle 8173 on Sun Solaris 2.8. I am trying to optimize

RE: general recovery scenarios

Thanks Robert ! sure, i also need to learn RMAN. that would definitely help. thanks all for the guidelines !!! -Original Message- Robert - IL Sent: Saturday, February 22, 2003 8:49 PM To: Multiple recipients of list ORACLE-L If I may, my Oracle9i RMAN Backup and Recovery book provides

RE: Top 10 DBA Do's and Don'ts anyone

Rachel: where can we find that article ? can u post the url ? -Original Message- Carmichael Sent: Sunday, February 23, 2003 6:24 AM To: Multiple recipients of list ORACLE-L for the don'ts you could just read my paper how not to be a DBA, the top 20 mistakes which I gave at IOUG last

RE: slow insert

You can read more abt it in PL/SQL User's Guide and Reference - Chapter 4 - Collections and Records ! anyway, below is the simple code to copy data from emp table. note that, after u fetch from the cursor, u have to check for the notfound condition at the end. say, the emp table has 15 rows and u

general recovery scenarios

Sorry folks .. i asked a wrong question. thanks for ur answers but those crashing dbs recovery was totally heavy for me. i shud i have asked, what r the different types of crashes and how to recover from them ? i mean, only the general recovery scenarious. since i m learning, i just want to

how to crash a db ?

Hi Listers ... sorry, no bad intentions or anything like that :) but i want to learn some recovery options. atleast, the basic point-in-time etc. so how can i try to crash a db ? r there any other ways to learn this w/out crashing the db ? wishing y'all a happy wknd ! thanks, -sam -- Please

RE: slow insert

if u r having oracle 8.1.7 EE or higher, try using bulk inserts ! that surely will speed up ! and of course, u surely might have thought of APPEND hint dropping/disabling indexes etc. -Original Message- Ravindra Sent: Friday, February 21, 2003 3:08 PM To: Multiple recipients of list

RE: Urgent - Help ....

Harsh, after altering the column (increasing the width) make sure u dont have any triggers/procedures associated with the table. altering the table will make those objects invalid. so make sure to compile those objects again. HTH !!! -Original Message- Agrawal Sent: Thursday, February

storage clause

Hi Gurus ... can somebody help in sizing the table/index using the storage clause ? what r the key values to check and how to calculate the table size the related storage parameters ? how does it change from an OLTP appln to a Datawarehouse ? lets say for the table emp : Name Null?

RE: storage clause

Dennis, sorry for being not clear. in fact, i dont even know the proper approach to take if i have to resize the table. ok, so 1st input required is how many rows will the table have ? 2nd is the growth pattern ? now is there a certain approach to it ? say like, if the table is having 100,000

RE: storage clause

I've helped more than confused you. Regards, Mark. netmadcap@net zero.comTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject

RE: Preventing select on table

Ok, so now you have learnt the lesson that not to define a primary key based on any attributes. is it ok for ur customer if the values r updated at night ? if so, u can add a column to the table, say new_customer_id, and then at night run thru a huge update to replace all the keys in referenced

RE: Oracle 8i or 9i ?

i would say, first install 8i start playing with it. once u r comfortable dealing with Oracle homes, clean uninstall etc, install 9i in a different home. i personally had terrible experiences when i was learning (and i m still learning) the administration part and dealing with multiple instances