1.登陆sqlplus
Sqlplus /nolog;
Conn 用户名/密码;
Create directory data dir as "c:\dmpfile";
2.退出sqlplus 到命令行,执行expdb/impdb;
(1)导出:服务器命执行令行如下:
格式:
expdb user/password@orcl dumpfile=expdb.dmp directory=data_dir logfile=expdb.log version=11.2.0,1.0
实例:
expdb imetadata/123456@orcl dumpfile=imetadata.dmp directory=data_dir logfile=exp.log
schemas=imetadata_v4 version=11.2.0,1.0
(2)导入:服务器命执行令行如下:
实例:
impdb imetadata/123456@orcl dumpfile=IMETADATA.dmp directory=data_dir full=y logfile=dam.log remap_schema=IMETADATA:DATATEST remap_tablespace=IMETADATA:DATATEST