1.新建 table space
create tablespace GCE_DATA1
logging
datafile 'D:\oracle\oradata\Oracle9i\user_data.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
2. 新建一个 user 赋予dba权限
create user DANNY identified by 111111
default tablespace GCE_DATA1;
grant connect,resource,dba to username;
grant sysdba to username
create tablespace GCE_DATA1
logging
datafile 'D:\oracle\oradata\Oracle9i\user_data.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
2. 新建一个 user 赋予dba权限
create user DANNY identified by 111111
default tablespace GCE_DATA1;
grant connect,resource,dba to username;
grant sysdba to username