+ Reply to Thread
Results 1 to 5 of 5
  1. 01-21-2003 05:03 AM #1
    kasi
    kasi is offline Junior Member
    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
    Reply With Quote Reply With Quote
  2. 01-21-2003 06:17 AM #2
    jovery's Avatar
    jovery
    jovery is offline Ha Ha
    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!
    Reply With Quote Reply With Quote
  3. 01-21-2003 10:37 AM #3
    kburrows
    kburrows is offline Member
    Join Date
    Nov 2000
    Posts
    172
    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.
    Reply With Quote Reply With Quote
  4. 01-21-2003 12:14 PM #4
    Orca777's Avatar
    Orca777
    Orca777 is offline Senior Member
    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
    Reply With Quote Reply With Quote
  5. 01-21-2003 03:17 PM #5
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,094
    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."
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

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

Forum Rules

 Click Here to Expand Forum to Full Width