plsql创建临时表空间和表空间

2022-07-12 14:04:33

CREATE TEMPORARY TABLESPACE TBS_ASSIST2_TMP
TEMPFILE '/data01/oracle/app/oracle/oradata/oracle/assist2db_tmp.dbf' SIZE 1024M REUSE AUTOEXTEND OFF
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 100M;

CREATE TABLESPACE TBS_ASSIST2_DAT
DATAFILE '/data01/oracle/app/oracle/oradata/oracle/assist2db_dat01.dbf' SIZE 2048M AUTOEXTEND OFF
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
SEGMENT SPACE MANAGEMENT AUTO;