Hi DB Guru's,
I got a problen in import. The dump file size is 1.2GB and number of records in each table is more than 500000. its taking 8 hours to complete the import.Can any one suggest a shortcut to reduce the time of import.
Not very well size RBSs but this should not be the cause. Eight hours you said for a one G dump? Odd. Try with 3 times smaller buffer. Are all tables 'empty' before the import? Is the system well tuned?
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g