创建表空间
‘D:\DATABASE\ORACLE19C\HOME\ORADATA\ORCL\LEARUN.DBF’=>更换自己的路径
CREATE TABLESPACE 表空间名
DATAFILE
'D:\DATABASE\ORACLE19C\HOME\ORADATA\ORCL\LEARUN.DBF' SIZE 100M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
LOGGING
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON;
创建用户
CREATE USER 用户名 IDENTIFIED BY 密码
DEFAULT TABLESPACE 表空间名称
TEMPORARY TABLESPACE TEMP
PROFILE "DEFAULT";
赋值权限
GRANT "AQ_ADMINISTRATOR_ROLE" TO LEARUN WITH ADMIN OPTION;
GRANT "DBA" TO LEARUN WITH ADMIN OPTION;
给予用户权限
ALTER USER LEARUN DEFAULT ROLE "AQ_ADMINISTRATOR_ROLE", "DBA";