Oracle 建表空间，建用户

最新推荐文章于 2021-04-12 01:48:58 发布

oufu

最新推荐文章于 2021-04-12 01:48:58 发布

阅读量381

点赞数 1

分类专栏：数据库开发

本文链接：https://blog.youkuaiyun.com/oufua/article/details/51297141

版权

数据库开发专栏收录该内容

33 篇文章

订阅专栏

1、创建临时表空间
create tablespace ORACLE_HISTORY logging datafile '/home/oracle/oraclehistory.dbf' size 30m autoextend on next 28m extent management local;
2、创建索引表空间
create tablespace ORACLE_INDEX logging datafile '/home/oracle/oracleindex.dbf' size 30m autoextend on next 22m extent management local;
3、创建数据表空间
create tablespace ORACLE_DATA logging datafile '/home/oracle/oracledata.dbf' size 30m autoextend on next 24m extent management local;

3.建用户
create user oracle identified by oracle default tablespace ORACLE_DATA temporary tablespace TEMP profile DEFAULT quota unlimited on oracle_HISTORY quota unlimited on oracle_DATA quota unlimited on oracle_INDEX;
4.赋权
grant connect to oracle;
grant exp_full_database to oracle;
grant imp_full_database to oracle;
grant create session to oracle;
alter user oracle quota 10M on users;