import

1. EXPORT: exp system@test owner=test123 file=d:oracleuser.dmp log=d:oracleuserdump.log rows=y statistics=none feedback=100 indexes=y consistent=y compress=n; (for individual tables=table1,table2,…..) 2. IMPORT: imp system@test fromuser=test123 touser=test123 file=d:oracleuser.dmp log=d:oracleuser11.log ignore=y rows=y indexes=y feedback=100;