Export / import duration for Oracle database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Export / import duration for Oracle database

  1. #1
    Join Date
    Jan 2003
    Posts
    1

    Export / import duration for Oracle database

    Hi

    I am having Oracle 7.3.4 database which is 45GB and running in Sun enterprise 3000 , 2 GB RAM. Can anyone tell me with your experience ...

    1. How much time the import of database will take ?

    2. I am planning to export the table to oracle 9i database in another server of same configuration. How long the export would take.


    thanks for you help

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    The best way to get a metric is to take a sample set of data and perform the export/import. Using this sample will give you approximate timings.

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  3. #3
    Join Date
    Nov 2000
    Posts
    173
    I have an Oracle 817 database running on IBM S85. The database is about 50gb and takes me no more than 1.5 hrs using the split unix command or the New 817 Oracle Filesize parameter.

  4. #4
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    Oracle 8.1.7.3.50 30GB

    Export on Os390/4CPU 4G Ram

    1.5H
    Orca
    Depends on IO-Power and your Disk-layout

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    My rule-of-thumb is import will take 3 times as long as export.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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