Results 1 to 2 of 2

Thread: Moving data

  1. #1
    Join Date
    Jul 2003

    Unanswered: Moving data

    I'm about to move data from one database to another (Oracle 8.1.7 Windows 2000). It is data from one table (about 1 milion records, 15 columns and each in size of varchar2(10) on average). In connection with this I have some questions:
    1. What is the best way to do it ?
    2. How long is it going to take me (approximately) ?
    3. What do I have to remember about to do it safely and quickly ?

    Thank you for any solutions

  2. #2
    Join Date
    Jul 2003
    use export/import or sqlloader.

    export/import will take you maybe 1 hour or less.
    sqlloader depends on how long it takes you to make the flat-file.

    export/import is the way to go, it won't let you insert duplicate rows so make sure you send everything to a log file and set ignore=Y
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

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