oracle 创建schema

-- 查看当前已有的用户SELECT Username FROM dba_users;-- 创建临时CREATE USER gzmpc IDENTIFIED BY PASSWORD;-- 授权GRANT CREATE SESSION TO gzmpc;CREATE TABLESPACE gzmoc_wk DATAFILE 'gzmoc_wk.dat' SIZE 10M AUTOEXTEND ON;

锦瑟思年华

3819人浏览 · 2021-06-01 14:46:16

锦瑟思年华 · 2021-06-01 14:46:16 发布

-- 查看当前已有的用户
SELECT Username FROM dba_users;
 
-- 创建临时
CREATE USER gzmpc IDENTIFIED BY PASSWORD;
 
-- 授权
GRANT CREATE SESSION TO gzmpc;
 
CREATE TABLESPACE gzmoc_wk DATAFILE 'gzmoc_wk.dat' SIZE 10M AUTOEXTEND ON;
 
CREATE TEMPORARY TABLESPACE gzmoc_wk_tablespace_temp TEMPFILE 'gzmoc_tabspace_temp.dat' SIZE 5M AUTOEXTEND ON;
 
DROP USER gzmpc;
 
-- 开始创建数据库
CREATE USER gzmpc IDENTIFIED BY PASSWORD DEFAULT TABLESPACE gzmoc_wk TEMPORARY TABLESPACE gzmoc_wk_tablespace_temp;
 
-- 授权
grant create session to gzmpc;
 
grant create table to gzmpc;
 
grant unlimited tablespace to gzmpc;
 
-- 最后修改一下密码
ALTER USER gzmpc IDENTIFIED BY gzmpc;

转载至