Results 1 to 2 of 2

Thread: Export

  1. #1
    Join Date
    May 2004

    Unanswered: Export


    Does the export need the DB to be offline? if not, what is the impact on the consistency of the data entered while export??


  2. #2
    Join Date
    Jan 2004
    Croatia, Europe
    Provided Answers: 5
    No, it doesn't.

    Data entered during export? It depends on WHEN they are entered ... if the table is already exported, then sorry - you won't have them.

    However, there's an export parameter "CONSISTENT" which defaults to NO. If you need to have consistent data in export, issue something like

    EXP un/pw tables=(tab1, tab2, tab3, ...) CONSISTENT=Y

    It is suggested that only tables that need to remain consistent are exported together, while all the others should be exported separately. Why? Because use of the "Consistent" parameter requires a rollback segment to be retained for the duration of the export.

Posting Permissions

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