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);