首次导入数据库:
1)windows命令行中执行:sqlplus / as sysdba, 进入sqlplus命令行模式;
2)sqlplus命令行中执行: create directory dump_dir as '{本地目录}';
[img]http://dl2.iteye.com/upload/attachment/0096/9245/d8b9ed6b-7857-3009-b25a-f4b5bdac5211.png[/img]
3) sqlplus命令行执行:create temporary tablespace tempsts1 tempfile '{临时表空间文件名}' size 100m autoextend on;
[img]http://dl2.iteye.com/upload/attachment/0096/9247/af3ab52e-a91e-3c8c-9e00-849e7b3643ab.png[/img]
4) 拷贝dmp文件到上面的“本地目录”;
5)windows命令中执行:impdp \"/ as sysdba\" directory=dump_dir dumpfile={dmp文件名}
[img]http://dl2.iteye.com/upload/attachment/0096/9249/4f6a5d03-0c61-3a62-8961-f22e9181c804.png[/img]
第二次及以后导入数据库:
1)windows命令行中执行:sqlplus / as sysdba, 进入sqlplus命令行模式;
2)sqlplus命令行中执行:drop user ceping cascade;
3) windows命令中执行:impdp \"/ as sysdba\" directory=dump_dir dumpfile={dmp文件名}
1)windows命令行中执行:sqlplus / as sysdba, 进入sqlplus命令行模式;
2)sqlplus命令行中执行: create directory dump_dir as '{本地目录}';
[img]http://dl2.iteye.com/upload/attachment/0096/9245/d8b9ed6b-7857-3009-b25a-f4b5bdac5211.png[/img]
3) sqlplus命令行执行:create temporary tablespace tempsts1 tempfile '{临时表空间文件名}' size 100m autoextend on;
[img]http://dl2.iteye.com/upload/attachment/0096/9247/af3ab52e-a91e-3c8c-9e00-849e7b3643ab.png[/img]
4) 拷贝dmp文件到上面的“本地目录”;
5)windows命令中执行:impdp \"/ as sysdba\" directory=dump_dir dumpfile={dmp文件名}
[img]http://dl2.iteye.com/upload/attachment/0096/9249/4f6a5d03-0c61-3a62-8961-f22e9181c804.png[/img]
第二次及以后导入数据库:
1)windows命令行中执行:sqlplus / as sysdba, 进入sqlplus命令行模式;
2)sqlplus命令行中执行:drop user ceping cascade;
3) windows命令中执行:impdp \"/ as sysdba\" directory=dump_dir dumpfile={dmp文件名}