--登录 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
