--创建表空间:
create tablespace test_tablespace
logging
datafile 'D:\test.dbf'
size 50m
autoextend on
next 50m maxsize 4096m
extent management local;
--创建用户,并设置默认表空间:
create user test identified by test
default tablespace test_tablespace
temporary tablespace temp;
--用户授权:
grant connect,resource,DBA to test;
create tablespace test_tablespace
logging
datafile 'D:\test.dbf'
size 50m
autoextend on
next 50m maxsize 4096m
extent management local;
--创建用户,并设置默认表空间:
create user test identified by test
default tablespace test_tablespace
temporary tablespace temp;
--用户授权:
grant connect,resource,DBA to test;