cmd-》sqlplus
登陆用户名:conn as sysdba
口令:为空
--创建临时表空间
create temporary tablespace xzsp_liuan_temp
tempfile 'E:\oracle_data\xzsp_wuxi_temp.dbf'
size 32m
autoextend on
next 32m
extent management local;
--创建表空间
create tablespace xzsp_liuan
logging
datafile 'E:\oracle_data\xzsp_liuan.dbf'
size 32m
autoextend on
next 32m
extent management local;
--创建用户
create user xzsp_liuan identified by "123"
default tablespace xzsp_liuan
temporary tablespace xzsp_liuan_temp;
--授权
grant connect,resource,dba to xzsp_liuan;
===================================================================================
create user xzsp_liuan identified by "123"
default tablespace xzsp_liuan;
--还原库
imp xzsp_linshu/123@orcl fromuser=xzsp_linshu touser=xzsp_linshu file='' ignore=y;
--备份库
exp xzsp_linshu/123@orcl file='c:\xzsp_linshu20110720.dmp'
--删除表空间
drop tablespace gx_zjjk including contents and datafiles;
drop tablespace xzsp_langxi including contents and datafiles;
--删除用户
drop user gx_zjjk cascade;
alter user jx_zjjk account unlock;
drop tablespace xzsp_nt including contents and datafiles CASCADE CONSTRAINTS;
--备份数据库(oracle11G备份到oracle10G)
EXPDP USERID='xzsp_fuyun/zwfw123TH@orcl as sysdba' schemas=xzsp_fuyun directory=DATA_PUMP_DIR dumpfile=xzsp_fuyun20120831.dmp logfile=xzsp_fuyun20120831.log version=10.2.0.1.0
目录:app\Administrator\admin\orcl\dpdump下生成
--还原库(oracle11G还原到oracle10G)
将xzsp_fuyun20120801.dmp文件拷贝到了admin\orcl\dpdump目录下
IMPDP USERID='xzsp_fuyun/123@orcl as sysdba' schemas=xzsp_fuyun directory=DATA_PUMP_DIR dumpfile=1.DMP logfile=xzsp_fuyun.log version=10.2.0.1.0
[url]http://wenku.baidu.com/view/c7d426fbaef8941ea76e05d1.html[/url]
[url]http://baike.baidu.com/view/2973562.htm[/url]