Results 1 to 3 of 3

Thread: Export/Import of Financial db

  1. #1
    Join Date
    Jan 2003
    Location
    Melbourne, Australia
    Posts
    5

    Export/Import of Financial db

    I am attempting to perform an export/import of a 'smallish' 35Gb financials database.

    Does anyone know of any issues that I should be aware of?

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Do it during off hours.

    If you are using CONSISTENT=Y option for export or using commit after importing the whole table then make sure that you create a large rollback segment and make this the only online rollback segment.

    Use direct path option to speed up export.

  3. #3
    Join Date
    Jan 2003
    Location
    Melbourne, Australia
    Posts
    5
    Thank you.

    I have previously cloned the database into a test instance. Can I just import the dump file without clearing out any of the old data? - ie will it overwrite the old data with the content of the import file.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •