RE: shutdown abort / startup restrict / shutdown vs. shutdown imm

2002-07-25 Thread Inder . Singh
Inder Singh IT Management 1101 Pacific Ave. Ph:859-815-2460 Email: [EMAIL PROTECTED] -Original Message- Sent: Thursday, July 25, 2002 12:49 PM To: Multiple recipients of list ORACLE-L imm My old argument against shutdown abort was a nasty little bug (it's been fixed in 9i). Here

RE: SQL*Loader question

2002-06-04 Thread Inder . Singh
I don't know of any such option in sqlloader. But, you can do one thing copy the 100 records from the file and create a new file and try to load that one. Hope this helps. Regards, Inder -Original Message- Sent: Tuesday, June 04, 2002 11:39 AM To: Multiple recipients of list ORACLE-L

Data Warehouse design

2002-06-12 Thread Inder . Singh
Hi, I am in the process of designing the data warehouse. My Question is can I define the relationship between dimension tables. Like I have country,customer and time zone dimension tables. Can I add relationship between customer,country and time zone just to validate the data before load

Urgent - Upgrade from 8.1.6 to 8.1.6.3

2002-06-22 Thread Inder . Singh
Hi, I have upgraded two databases from 8.1.6 to 8.1.6.3. After upgrade I ran catalogand catproc.sql for both of them. For first database ir ran fine. But for the second one it never started. So I cacelled that one. I started again and now it is been 20-25 minutes. But, stll there is no

RE: delete from table question

2002-07-16 Thread Inder . Singh
Hi, I have this script which deletes the record from the master as well as all the Child tables also. May be this will help you. But I have never used this script before. Check this on Development before running it in Prod. To delete records from all the dependent tables and the master table