1:创建临时表空间
create temporary tablespace nbpbs_data_temp
tempfile '\oradata\ggfwwwdb\nbpbs_data_temp.dbf'
size 50m
autoextend on
next 50m maxsize 2048m
extent management local;
2:创建数据表空间
create tablespace nbpbs_data
logging
datafile '\oradata\ggfwwwdb\nbpbs_data.dbf'
size 150m
autoextend on
next 150m maxsize 20480m
extent management local;
第3步:创建用户并指定表空间
create user nbpbs identified by nbpbs
default tablespace nbpbs_data
temporary tablespace nbpbs_data_temp;
第4步:给用户授予权限
第5步:发现空间不够大?那就调整一下吧
ALTER DATABASE DATAFILE '\oradata\ggfwwwdb\nbpbs_data.dbf' RESIZE 100M;
create temporary tablespace nbpbs_data_temp
tempfile '\oradata\ggfwwwdb\nbpbs_data_temp.dbf'
size 50m
autoextend on
next 50m maxsize 2048m
extent management local;
2:创建数据表空间
create tablespace nbpbs_data
logging
datafile '\oradata\ggfwwwdb\nbpbs_data.dbf'
size 150m
autoextend on
next 150m maxsize 20480m
extent management local;
第3步:创建用户并指定表空间
create user nbpbs identified by nbpbs
default tablespace nbpbs_data
temporary tablespace nbpbs_data_temp;
第4步:给用户授予权限
grant connect,resource,dba to nbpbservice;
--授权
GRANT
CONNECT,
RESOURCE,
CREATE SESSION,
CREATE ANY SEQUENCE,
CREATE ANY TABLE,
CREATE ANY VIEW ,
CREATE ANY INDEX,
CREATE ANY PROCEDURE,
CREATE ANY DIRECTORY,
ALTER SESSION,
ALTER ANY SEQUENCE,
ALTER ANY TABLE,
ALTER ANY INDEX,
ALTER ANY PROCEDURE,
DROP ANY SEQUENCE,
DROP ANY TABLE,
DROP ANY VIEW ,
DROP ANY INDEX,
DROP ANY PROCEDURE,
DROP ANY DIRECTORY,
SELECT ANY TABLE,
SELECT ANY DICTIONARY,
INSERT ANY TABLE,
UPDATE ANY TABLE,
DELETE ANY TABLE,
DEBUG ANY PROCEDURE,
DEBUG CONNECT SESSION,
exp_full_database,
imp_full_database
To nbpbservice;
第5步:发现空间不够大?那就调整一下吧
ALTER DATABASE DATAFILE '\oradata\ggfwwwdb\nbpbs_data.dbf' RESIZE 100M;