oracle数据库的操作

原创于 2018-08-21 19:38:59 发布 · 145 阅读

CC 4.0 BY-SA版权

0、在本地登录服务器数据库：
1、创建表空间
CREATE TABLESPACE EDSYSTEM
DATAFILE 'D:\oracle\product\10.2.0\oradata\shitan\EDSYSTEM.dbf'
SIZE 100M
AUTOEXTEND ON NEXT 10M;
--2、创建用户
create user test
identified by test
default tablespace EDSYSTEM
--3、授权
grant dba to test;
grant connect,resource to test;
grant select any table to test;
grant update any table to test;
grant create any table to test;
grant delete any table to test;
-----------------------------------------
删除用户un：drop user un cascade;
删除表空间ts:alter tablespace xx offline;
drop tablespace ts INCLUDING CONTENTS CASCADE CONSTRAINTS;