Printable View
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
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.