//Oracle创建新用户
create user anyue20180229(用户名) identified by anyue20180229(密码);
//授权
grant dba to anyue20180229;
//创建directory,以便于导出、导入
create or replace directory dump_dir as 'D:\app\Administrator\admin\orcl\dpdump'
//导出文件
expdp anyue/anyue@orcl dumpfile=anyue20180229.dmp logfile=20180229.log schemas=anyue20180130
//导入文件
impdp anyue20180229/anyue20180229@orcl dumpfile=anyue20180229.dmp logfile=20180229.log remap_schema=anyue20180130:anyue20180229
//创建表空间,使用时,记得修改下面的路径
CREATE TABLESPACE NNC_DATA01 DATAFILE 'D:\oracle\product\10.2.0\oradata\orcl\nnc_data01.dbf' SIZE 100M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K ;
CREATE TABLESPACE NNC_DATA02 DATAFILE 'D:\oracle\product\10.2.0\oradata\orcl\nnc_data02.dbf' SIZE 50M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K ;
CREATE TABLESPACE NNC_DATA03 DATAFILE ‘D:\oracle\product\10.2.0\oradata\orcl\nnc_data03.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 512K ;
CREATE TABLESPACE NNC_INDEX01 DATAFILE ‘D:\oracle\product\10.2.0\oradata\orcl\nnc_index01.dbf' SIZE 100M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K ;
CREATE TABLESPACE NNC_INDEX02 DATAFILE ‘D:\oracle\product\10.2.0\oradata\orcl\nnc_index02.dbf' SIZE 50M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K ;
CREATE TABLESPACE NNC_INDEX03 DATAFILE ‘D:\oracle\product\10.2.0\oradata\orcl\nnc_index03.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K ;
//远程备份数据库到本地
exp cetcnc65/cetcnc65@192.168.21.1:1521/orcl file=F:\databackups
//导入
imp tom/tom@localhost:1521/mydb file=d:/daochu.dmp fromuser=tom touser=tom