Oracle表空间-还原表空间新建
发布时间：2020-12-12 14:26:55 所属栏目：百科 来源：网络整理
导读：1、新建 SQL create undo tablespace lianxi_undo 2 datafile 'C:orcl1122disk5lianxi_undo.dbf' 3 size 20M; Tablespace created SQL 2、查询 SQL select * from dba_tablespaces where tablespace_name like '%LIANXI%'; TABLESPACE_NAME BLOCK_SIZE INI
|
1、新建 SQL> create undo tablespace lianxi_undo 2 datafile 'C:orcl1122disk5lianxi_undo.dbf' 3 size 20M; Tablespace created SQL> 2、查询 SQL> select * from dba_tablespaces where tablespace_name like '%LIANXI%'; TABLESPACE_NAME BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS MAX_SIZE PCT_INCREASE MIN_EXTLEN STATUS CONTENTS LOGGING FORCE_LOGGING EXTENT_MANAGEMENT ALLOCATION_TYPE PLUGGED_IN SEGMENT_SPACE_MANAGEMENT DEF_TAB_COMPRESSION RETENTION BIGFILE PREDICATE_EVALUATION ENCRYPTED COMPRESS_FOR ------------------------------ ---------- -------------- ----------- ----------- ----------- ---------- ------------ ---------- --------- --------- --------- ------------- ----------------- --------------- ---------- ------------------------ ------------------- ----------- ------- -------------------- --------- ------------ LIANXI 8192 57344 57344 1 2147483645 2147483645 0 57344 ONLINE PERMANENT LOGGING NO LOCAL UNIFORM NO AUTO DISABLED NOT APPLY NO HOST NO LIANXI_UNDO 8192 65536 1 2147483645 2147483645 65536 ONLINE UNDO LOGGING NO LOCAL SYSTEM NO MANUAL DISABLED NOGUARANTEE NO HOST NO SQL> （编辑：李大同） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |