-
Is there a way to turn off redo logging while doing and import to make the import go faster?
-
no you cannot turn redo off, what you can do (if your database has NO LONG, LOB, RAW data) is export with direct=y then import would be faster
you can play around with these parameters to speed up your import
analyze=
buffer=
analyze=
indexes=
-
You cannot, but what you can do is, you can always specify in table/tablespace NO LOGGING mode.
Thanks
Kishore Kumar
-
You can turn off REDO and UNDO by creating a table with NOLOGGING. Oracle writes very small info in the redo and undo segments when data is written into that table.
Alternatively you can use UNRECOEVRABLE option.
However, the fastest method of doing exp/imp and sqlloader is using direct=true when the table is set to NOLOGGING mode.
-
I have seen some forum on metalink talking about using multiple exp/imp process via UNIX pipe and (if I remeber right) someone imported 25GB data in 6 hours, if you have metalink acc you should be able to find this (search on export import pipe)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|