I will explain how to import or export dump:
opend command line window to write the command
1- Export dump to file define the file which you will put the dump then define the path of log file
exp system/sys@orcl file=d:\test2.dmp owner=(test2) log=d:\test2.log
2- Import dump file
imp system/sys@orcl fromuser=test2 touser=test2 file=d:\test2.dmp
imp system/sys@orcl file=D:\Modules\dump\Lagoon_dmp\fulld.dmp sqlfile=d:\philddl.txt
imp system/sys@orcl file=D:\Modules\dump\full_Wed.DMP full=yes log=d:\ysr.log
opend command line window to write the command
1- Export dump to file define the file which you will put the dump then define the path of log file
exp system/sys@orcl file=d:\test2.dmp owner=(test2) log=d:\test2.log
2- Import dump file
imp system/sys@orcl fromuser=test2 touser=test2 file=d:\test2.dmp
imp system/sys@orcl file=D:\Modules\dump\Lagoon_dmp\fulld.dmp sqlfile=d:\philddl.txt
imp system/sys@orcl file=D:\Modules\dump\full_Wed.DMP full=yes log=d:\ysr.log
No comments:
Post a Comment