1.exp username/pwd@ora8 file=dbname.dmp rows=N log=exp.log
2.imp username/pwd@ora8 file=dbname.dmp fromuser=usera touser=userb show=Y rows=N log=imp.log indexfile=schame.sql
执行成功后请查看 schame.sql 中的DDL语句,但不包括sequence/procedure等其它对象.
1.exp username/pwd@ora8 file=dbname.dmp rows=N log=exp.log
2.imp username/pwd@ora8 file=dbname.dmp fromuser=usera touser=userb show=Y rows=N log=imp.log indexfile=schame.sql
执行成功后请查看 schame.sql 中的DDL语句,但不包括sequence/procedure等其它对象.