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
- 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
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
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
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
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
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
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
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]
- 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
10 matches
Mail list logo