orcal数据操作

1.将数据库ZHSY完全导出,用户名baseusernj密码baseusernj导出到D:\daochu.dmp中
exp baseusernj/baseusernj@ZHSY file=d:\daochu.dmp full=y

exp baseuserhf/baseuserhf@ZJCPDB file=C:\105hf.dmp owner=baseuserhf
2.导入那个数据库的用户就写那个，第一个是用户名，第二个是密码
imp baseusernj/baseusernj@ZHSY file=C:\\gzzj.dmp fromuser=baseuser touser=baseusernj
imp baseusertd/baseusertd@ZJCPDB file=C:\tdzj20160920.dmp fromuser=baseuser touser=baseusertd

CREATE SMALLFILE
TABLESPACE base_DATA
LOGGING
DATAFILE
'D:\ORACLE\PRODUCT\10.2.0\ORADATA\zhsy\base_DATA.DBF' SIZE
100M REUSE AUTOEXTEND
ON NEXT 20M MAXSIZE 1024M EXTENT MANAGEMENT LOCAL
UNIFORM SIZE 512K SEGMENT SPACE MANAGEMENT AUTO ;

-- Create the user
create user baseuser --用户名
identified by baseuser --密码
default tablespace base_DATA
temporary tablespace TEMP
profile DEFAULT;
-- Grant/Revoke role privileges
grant connect to baseuser with admin option;
grant dba to baseuser with admin option;
grant resource to baseuser with admin option;

11g的dmp导入到10g

1.将接收到的TEST.dmp放入C:\oracle\product\10.2.0\admin\ZJCPDB\dpdump中
2.命令：
IMPDP SMARTSTORAGEYL/SMARTSTORAGEYL@ZJCP
DB schemas=SMARTSTORAGEYL directory=DATA_PUMP_DIR dumpfile=test.dmp logfile=test
.log version=10.2.0.1.0