select * from dba_data_files ; select * from dba_users; -- 删除 用户 --DROP USER SYNC_PLUS_1 cascade; -- 删除表空间 --drop tablespace SYNC_PLUS_ORCLPDB1 including contents and datafiles ; /* create tablespace sync_plus_1 datafile 'F:\DB_FILES\ORACLE21C\APP\ALAN_LIU\ORADATA\ORCL\ORCLPDB\sync_plus_1_01.dbf' size 100M autoextend on next 100M , 'F:\DB_FILES\ORACLE21C\APP\ALAN_LIU\ORADATA\ORCL\ORCLPDB\sync_plus_1_02.dbf' size 100M autoextend on next 100M , 'F:\DB_FILES\ORACLE21C\APP\ALAN_LIU\ORADATA\ORCL\ORCLPDB\sync_plus_1_03.dbf' size 100M autoextend on next 100M , 'F:\DB_FILES\ORACLE21C\APP\ALAN_LIU\ORADATA\ORCL\ORCLPDB\sync_plus_1_04.dbf' size 100M autoextend on next 100M , 'F:\DB_FILES\ORACLE21C\APP\ALAN_LIU\ORADATA\ORCL\ORCLPDB\sync_plus_1_05.dbf' size 100M autoextend on next 100M , 'F:\DB_FILES\ORACLE21C\APP\ALAN_LIU\ORADATA\ORCL\ORCLPDB\sync_plus_1_06.dbf' size 100M autoextend on next 100M , 'F:\DB_FILES\ORACLE21C\APP\ALAN_LIU\ORADATA\ORCL\ORCLPDB\sync_plus_1_07.dbf' size 100M autoextend on next 100M , 'F:\DB_FILES\ORACLE21C\APP\ALAN_LIU\ORADATA\ORCL\ORCLPDB\sync_plus_1_08.dbf' size 100M autoextend on next 100M maxsize unlimited logging extent management local autoallocate segment space management auto */ --创建用户 设置权限 create user SYNC_PLUS_1 identified by SYNC_PLUS_1 default tablespace SYNC_PLUS_1 quota 500m on users; ---- 这里第一个 TEST_SYNC 为用户名，第二个 TEST_SYNC 为密码，第三个 SYNC_PLUS_1 为表空间名。然后执行。 grant all privileges to SYNC_PLUS_1; --- 执行该语句给 TEST_SYNC 用户授权，此时 TEST_SYNC 用户就可以登录了。 ---创建角色 create role ALLINONE_JX ; create role ALLOUTSIDE ; create role ALLTAX ; create role RDCX; grant ALLTAX to sync_plus_1 ; grant ALLINONE_JX to sync_plus_1 ; grant ALLOUTSIDE to sync_plus_1 ; grant dba to sync_plus_1; grant RDCX to sync_plus_1; ---增加表空间的数据文件 alter tablespace sync_plus_1 add datafile 'D:\SOFT\DEVELOP\DATABASE\ORACLE\ORADATA\ORCL\sync_plus_1_01.dbf' size 500M autoextend on next 100M , 'D:\SOFT\DEVELOP\DATABASE\ORACLE\ORADATA\ORCL\sync_plus_1_02.dbf' size 500M autoextend on next 100M , 'D:\SOFT\DEVELOP\DATABASE\ORACLE\ORADATA\ORCL\sync_plus_1_03.dbf' size 500M autoextend on next 100M , 'D:\SOFT\DEVELOP\DATABASE\ORACLE\ORADATA\ORCL\sync_plus_1_04.dbf' size 500M autoextend on next 100M , 'D:\SOFT\DEVELOP\DATABASE\ORACLE\ORADATA\ORCL\sync_plus_1_05.dbf' size 500M autoextend on next 100M , 'D:\SOFT\DEVELOP\DATABASE\ORACLE\ORADATA\ORCL\sync_plus_1_06.dbf' size 500M autoextend on next 100M , 'D:\SOFT\DEVELOP\DATABASE\ORACLE\ORADATA\ORCL\sync_plus_1_07.dbf' size 500M autoextend on next 100M , 'D:\SOFT\DEVELOP\DATABASE\ORACLE\ORADATA\ORCL\sync_plus_1_08.dbf' size 500M autoextend on next 100M
Oracel 创建表空间、创建用户并设置密码及制定表空间、分配权限、创建角色、角色授权、表空间不足时新增表空间数据文件
发布时间 2023-06-14 15:55:57作者: 一品堂.技术学习笔记