Oracle 数据库备份与还原

--登录
sqlplus/nolog
--连接sys用户
conn / as sysdba
--关闭某个触发器
ALTER TRIGGER SYS.AW_DROP_TRG DISABLE;
--删除用户
drop user username cascade;
--删除表空间
drop tablespace gdexchange;
--删除XXXX.dbf文件

--创建dbf表空间
create tablespace gdexchange logging datafile 'G:\oracle\product\10.2.0\oradata\qddz\GDEXCHANGE.dbf'  size 1g autoextend on next 1m;
--创建用户
create user username IDENTIFIED BY password DEFAULT TABLESPACE GDEXCHANGE QUOTA UNLIMITED ON GDEXCHANGE QUOTA UNLIMITED ON SYSTEM;
--授予权限
grant dba, connect,resource,create session, create table, create view, create trigger, create sequence, unlimited tablespace to username;
--退出
quit

--导入数据库
imp username/password@dbname fromuser=username touser=username file= H:\bak\qddzdbak_2017-06-29-13-39-47__quyong\dbbak\qddzdbak_2017-06-29-13-39-47.dmp log= F:\log.txt