oracle export DB

exp userid=feelview/feelview@feelview file=E:\GRGWorking\test\1.exp log=1.log full=y

 

导入

 

imp USERID=admin/admin@192.168.0.1/hnnxfeelview  BUFFER=2048 TOUSER=feelview  fromuser=feelview  file=feelview_hnnx_20150115.exp log=feelview_hnnx.log

 

已成功过

 

From Oracle 11G to Oracle 10G

Oracle 导出

1,sqlplus / as sysdba;
2,select * from dba_directories;（SYS:DATA_PUMP_DIR）

expdp feelview/feelview@127.0.0.1/feelview directory=data_pump_dir file=feelview1.dmp version=10.1.0

Oracle 导入

sqlplus / as sysdba;
select instance_name from v$instance;

创建User

CREATE USER FEELVIEW IDENTIFIED BY "feelview";
GRANT create session TO FEELVIEW;
GRANT UNLIMITED   TABLESPACE   to FEELVIEW;
select * from dba_directories; （将PDM文件放到DM_PMML_DIR）D:\oracle\product\10.1.0\Db_1\dm\admin

exit

数据会导入下面这个实例当中
select instance_name from v$instance;

impdp feelview/feelview directory=DM_PMML_DIR dumpfile=feelview.dmp
impdp system/system directory=DM_PMML_DIR dumpfile=feelview1.dmp

grant dba to feelview;
revoke dba from feelview;