-- 1:创建临时表空间
create temporary tablespace fszq_temp
tempfile 'E:\app\WRS\oradata\fszq\fszq_temp.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
-- 2:创建数据表空间
create tablespace fszq_data
logging
datafile 'E:\app\WRS\oradata\fszq\fszq_data.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
--第3步:创建用户并指定表空间
create user fszq identified by FSZQ default tablespace fszq_data temporary tablespace fszq_temp;
--第4步:给用户授予权限
GRANT
CONNECT,RESOURCE,UNLIMITED TABLESPACE,
CREATE SESSION, CREATE ANY TABLE, CREATE ANY VIEW ,CREATE ANY INDEX, CREATE ANY PROCEDURE,
ALTER ANY TABLE, ALTER ANY PROCEDURE,DROP ANY TABLE, DROP ANY VIEW, DROP ANY INDEX, DROP ANY PROCEDURE,
SELECT ANY TABLE, INSERT ANY TABLE, UPDATE ANY TABLE, DELETE ANY TABLE
TO fszq;
--第5步:导出和导入数据
select * from dba_directories;
本内容试读结束,登录后可阅读更多
下载后可阅读完整内容,剩余1页未读,立即下载