Is there a way to turn off redo logging ....
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Is there a way to turn off redo logging ....

  1. #1
    Join Date
    Oct 2000
    Posts
    103

    Question

    Is there a way to turn off redo logging while doing and import to make the import go faster?

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    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=

  3. #3
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    You cannot, but what you can do is, you can always specify in table/tablespace NO LOGGING mode.

    Thanks
    Kishore Kumar

  4. #4
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    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.

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    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
  •  



Click Here to Expand Forum to Full Width