2022年06月8日 | Wizzer | 评论 CREATE TABLESPACE DEMO LOGGING DATAFILE '/opt/oracle/oradata/ORCLCDB/DEMO.dbf' SIZE 200M AUTOEXTEND ON NEXT 32M MAXSIZE 500M EXTENT MANAGEMENT LOCAL; create temporary tablespace DEMO_TEMP tempfile '/opt/oracle/oradata/ORCLCDB/DEMO_TEMP.dbf' size 100m autoextend on next 32m maxsize 500m extent management local; alter session set "_ORACLE_SCRIPT"=true; create user DEMO identified by DEMO default tablespace DEMO temporary tablespace DEMO_TEMP; alter user DEMO identified by DEMO; grant connect,resource,dba to DEMO; alter user DEMO quota unlimited on users; 564 total views, 6 views today