导出数据
exp 用户名/密码@127.0.0.1/ORCL owner=用户名 grants=y file=D:\backup\OSYUNWEI.dmp log=D:\backup\OSYUNWEI.log
添加用户
alter system set DB_CREATE_FILE_DEST = 'E:\oracle\app\oracle';
create tablespace SCF_DATA2;
CREATE USER zylin
IDENTIFIED BY 111111
DEFAULT TABLESPACE SCF_DATA2;
GRANT CONNECT TO zylin;
GRANT RESOURCE TO zylin;
GRANT CREATE VIEW TO zylin;
GRANT SELECT ANY DICTIONARY TO zylin;
GRANT UNLIMITED TABLESPACE TO zylin;
GRANT dba TO zylin;
oracle数据导入
imp full=y file=E:\mattNew.dmp
删除用户
drop user 用户名字 cascade