Import in ORACLE 8.1.6 [message #23197] |
Wed, 20 November 2002 13:42 |
Siva Ram
Messages: 22 Registered: November 2001
|
Junior Member |
|
|
Hello Team
Could any one of u help me out in resolving this issue.
I want to IMPORT the entire database to another machine. We've 376 tables and each has about 20000 tuples. This below statement upon execution is running for 60mts almost. My mgr says there's an option to make it fast, but I don't remember. So, could someone suggest me the fastest option available in IMPORT so that this can be completed in few minutes rather than 1hour. This is our production database and I need ASAP.
imp system/xxx file=G:ORACLE816Backupssysbear1.exp
log=D:DBALogsimpprod.log
fromuser=pstable
touser=pstable
commit=N
Thank You for ur help !
|
|
|
|