Export / import duration for Oracle database
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.
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 220.127.116.11.50 30GB
Export on Os390/4CPU 4G Ram
Depends on IO-Power and your Disk-layout
My rule-of-thumb is import will take 3 times as long as export.
Click Here to Expand Forum to Full Width