Re: imp table data, but not PK indexes?

2003-07-20 Thread Tanel Poder
Hi! Yes, but IIRC CONSTRAINTS=Y is an exp parameter, not imp? It's imp parameter as well. Best way to handle these things is to export twice. Once with all the bells and whistles turned on but ROWS=N (this gives you a small export file with all the schema logic added and takes no time at

Re: imp table data, but not PK indexes?

2003-07-20 Thread Nuno Souto
- Original Message - 2) export data with constraints=n rows=y indexes=n direct=y recordlength=65535 ^^ Do you find that makes a real difference? I haven't had much success with it... Also, if you plan to shorten your downtime by first exporting/importing the

Re: imp table data, but not PK indexes?

2003-07-20 Thread Tanel Poder
2) export data with constraints=n rows=y indexes=n direct=y recordlength=65535 ^^ Do you find that makes a real difference? I haven't had much success with it... Never in production. But once I was writing a paper on upgrading databases with low downtime, then I tested

Re: imp table data, but not PK indexes?

2003-07-20 Thread M Rafiq
I have been using it on HP and it speeds up export with direct=y. I wish HP should enhance this value greater than 65535 as it is maximum limit on HP. It helped me in export when we were changing block size from 4K to 16K Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients

imp table data, but not PK indexes?

2003-07-19 Thread Guang Mei
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: imp table data, but not PK indexes?

2003-07-19 Thread Wolfgang Breitling
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?

2003-07-19 Thread Ganesh Raja
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: imp table data, but not PK indexes?

2003-07-19 Thread rahul
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?

2003-07-19 Thread rahul
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?

2003-07-19 Thread Ravi Kulkarni
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]

Re: imp table data, but not PK indexes?

2003-07-19 Thread Nuno Souto
- 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