CREATE TABLESPACE tjjw2008 DATAFILE
'D:\date\tjjw.dbf' SIZE 1024M
DEFAULT STORAGE
( INITIAL 64K NEXT 64K MAXEXTENTS UNLIMITED PCTINCREASE 50 );
CREATE USER tjjw IDENTIFIED BY tjjw
DEFAULT TABLESPACE tjjw2008;
GRANT CONNECT TO tjjw;
GRANT DBA TO tjjw;
GRANT resource TO tjjw;
#####################################################################
CREATE TABLESPACE pgms DATAFILE
'E:\oracle\oradata\qz\pgms.dbf' SIZE 500M 数据库所在路径
DEFAULT STORAGE
( INITIAL 64K NEXT 64K MAXEXTENTS UNLIMITED PCTINCREASE 50 );
CREATE USER pgms IDENTIFIED BY pgms 创建用户名
DEFAULT TABLESPACE pgms; 用户名密码
GRANT CONNECT TO pgms; 授权
GRANT DBA TO pgms;
GRANT resource TO pgms;
exp jjjw2008/jjjw2008@orcl file=d:/强智科技/数据库备份/jjjw20081223.dmp owner=(jjjw2008);
转载于:https://blog.51cto.com/linuxpython/1625507