RE: RAC or Oracle Fail Safe

Title: RE: RAC or Oracle Fail Safe Hi Rajesh, Thanks for the detailed reply and I really appreciate that. Certain clarifications. 1. With reference to what you said about using both the nodes, you meant that we can install another database (lets say for reporting purpose) or/and also

Re: DB2 pointers

From a previous request to the list try these: DB2 links from SearchDatabase.com - http://searchdatabase.techtarget.com/bestWebLinks/0,289521,sid13_tax282900,00.html Learning the Lingo - article from DB2 Magazine that maps some Oracle and DB2 concepts -

RE: RAC or Oracle Fail Safe

Title: RE: RAC or Oracle Fail Safe Hi Hussain, Replies are inline . With reference to what you said about using both the nodes, you meant that we can install another database (lets say for reporting purpose) or/and also 9iAS on one node and our main production database on the

imp table data, but not PK indexes?

Hi, I sent this yesterday but it did not seem to get posted. Anyway I am posting it again. I am trying to speed up a schema imp process by import data and indexes separately to an Oracle 8173 db. While importing table data, I don't want to import PK indexes which are sitting in tablespace

Re: Increase tablespace, which way is better?

Please correct me if I am wrong. With option 1, the datafile will dynamically extend, 1M at a time and there is no guarantee the datafile is contiguous on disk. That will increase your I/O time when Oracle need to find data all over the disk. And also with autoextend, you may run out of space on

Re: imp table data, but not PK indexes?

Set indexes=no in the import script At 06:14 AM 7/19/2003 -0800, you wrote: Hi, I sent this yesterday but it did not seem to get posted. Anyway I am posting it again. I am trying to speed up a schema imp process by import data and indexes separately to an Oracle 8173 db. While importing table

RE: imp table data, but not PK indexes?

Use the Indexes = N Option and Create the Index Seperatley .. AFAIK that should work ... Regards, Ganesh R HP : (+65)9067-8474 Mail : [EMAIL PROTECTED] == All Opinions expressed are my own and do not in anyway reflect those of my employer

Re: Empty String is interpreted as NULL

Thanks for all replies. Right now I think I can afford just make the column NULL, so that's what I'll do. But still, something doesn't feel quite right with empty string == NULL :). RDB On Friday 18 July 2003 03:22 pm, Mercadante, Thomas F wrote: Reuben, While I agree that an empty string

RE: imp table data, but not PK indexes?

as PK comes under 'constraints' you might also have to do constraints=N also... On Sat, 19 Jul 2003 07:04:23 -0800, Ganesh Raja [EMAIL PROTECTED] wrote : Use the Indexes = N Option and Create the Index Seperatley .. AFAIK that should work ... Regards, Ganesh R HP : (+65)9067-8474

RE: imp table data, but not PK indexes?

as PK comes under 'constraints' you might also have to do constraints=N also... On Sat, 19 Jul 2003 07:04:23 -0800, Ganesh Raja [EMAIL PROTECTED] wrote : Use the Indexes = N Option and Create the Index Seperatley .. AFAIK that should work ... Regards, Ganesh R HP : (+65)9067-8474

RE: pls-00123 Program too Large

Title: RE: pls-00123 Program too Large David, that trigger is way too long ... IMO. but if you really must, convert the logic into a package and pass parameters to the package call from within the trigger. Raj -Original Message- From: Ehresmann, David [mailto:[EMAIL PROTECTED]]

RE: DBA/Programmer GUI tool for Oracle in Linux

Title: RE: DBA/Programmer GUI tool for Oracle in Linux TORA can't beat it. most value for money ... search on smartforge.net Raj -Original Message- From: Reuben D. Budiardja [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 19, 2003 11:54 AM To: Multiple recipients of list

RE: Physical Design Question

Title: RE: Physical Design Question Exactly, We had that Windows Server monitoring database on a w2K box, and due to performance issues, the monitoring app used to put so much load on the boxes it was supposed to monitor that we had to crash the boxes in out test lab. So, we (DBA and Unix)

RE: Increase tablespace, which way is better?

Title: Message We prefer to size them correctly to a max limit and then keep adding files. Because for each raw file, we have a backup file and a tertiary file. This helps in doing backups quickly and in case of crash, we can bring up the database on backup or tertiary data files. We

Re: faq broke? -- Other options

Don't think that the only searchable archives are on orafaq. Fat City has the definitive archives that date back to the start of the list here. You should consider using the archives here as well. You can find them here: http://www.listguru.com thanks, bruce -Original Message- Sent:

RE: imp table data, but not PK indexes?

PK is a constraint too constraints=Y by default. --- Ganesh Raja [EMAIL PROTECTED] wrote: Use the Indexes = N Option and Create the Index Seperatley .. AFAIK that should work ... Regards, Ganesh R HP : (+65)9067-8474 Mail : [EMAIL PROTECTED]

Antw: DBA/Programmer GUI tool for Oracle in Linux

Hi there! I am using the Oracle Enterprise Manager. Just download Oracle for Linux and install only the whole client part inlcuding OEM. It has the whole functionality even fro new feature and is included in your server license if you are not using enhanced version. Sven -- Sven Jensen

Re: imp table data, but not PK indexes?

- Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, July 20, 2003 2:04 AM as PK comes under 'constraints' you might also have to do constraints=N also... On Sat, 19 Jul 2003 07:04:23 -0800, Ganesh Raja [EMAIL PROTECTED] wrote : Use