-
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
-
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!
-
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.
-
Oracle 8.1.7.3.50 30GB
Export on Os390/4CPU 4G Ram
1.5H
Orca
Depends on IO-Power and your Disk-layout
-
My rule-of-thumb is import will take 3 times as long as export.
Jeff Hunter
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
|