Oracle表空间-本地管理新建

发布时间：2020-12-12 14:26:56 所属栏目：百科来源：网络整理

导读：1、创建本地管理表空间： SQL create tablespace lianxi 2 datafile 'C:orcl1122disk5lianxi01.dbf' size 50M,'C:orcl1122disk5lianxi02.dbf' size 50M 3 minimum extent 50k 4 default storage (initial 50k next 50k maxextents 100 pctincrease 0);

1、创建本地管理表空间： SQL> create tablespace lianxi 2 datafile 'C:orcl1122disk5lianxi01.dbf' size 50M,'C:orcl1122disk5lianxi02.dbf' size 50M 3 minimum extent 50k 4 default storage (initial 50k next 50k maxextents 100 pctincrease 0); Tablespace created 2、查看 SQL> select * from dba_tablespaces; 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 ------------------------------ ---------- -------------- ----------- ----------- ----------- ---------- ------------ ---------- --------- --------- --------- ------------- ----------------- --------------- ---------- ------------------------ ------------------- ----------- ------- -------------------- --------- ------------ SYSTEM 8192 65536 1 2147483645 2147483645 65536 ONLINE PERMANENT LOGGING NO LOCAL SYSTEM NO MANUAL DISABLED NOT APPLY NO HOST NO SYSAUX 8192 65536 1 2147483645 2147483645 65536 ONLINE PERMANENT LOGGING NO LOCAL SYSTEM NO AUTO DISABLED NOT APPLY NO HOST NO UNDOTBS1 8192 65536 1 2147483645 2147483645 65536 ONLINE UNDO LOGGING NO LOCAL SYSTEM NO MANUAL DISABLED NOGUARANTEE NO HOST NO TEMP 8192 1048576 1048576 1 2147483645 0 1048576 ONLINE TEMPORARY NOLOGGING NO LOCAL UNIFORM NO MANUAL DISABLED NOT APPLY NO HOST NO USERS 8192 65536 1 2147483645 2147483645 65536 ONLINE PERMANENT LOGGING NO LOCAL SYSTEM NO AUTO DISABLED NOT APPLY NO HOST NO EXAMPLE 8192 65536 1 2147483645 2147483645 65536 ONLINE PERMANENT NOLOGGING NO LOCAL SYSTEM YES AUTO DISABLED NOT APPLY NO HOST NO LIANXI 8192 57344 57344 1 2147483645 2147483645 0 57344 ONLINE PERMANENT LOGGING NO LOCAL UNIFORM NO AUTO DISABLED NOT APPLY NO HOST NO 7 rows selected SQL> select * from dba_data_files; FILE_NAME FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS RELATIVE_FNO AUTOEXTENSIBLE MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS ONLINE_STATUS -------------------------------------------------------------------------------- ---------- ------------------------------ ---------- ---------- --------- ------------ -------------- ---------- ---------- ------------ ---------- ----------- ------------- C:ORACELBASEORADATAORCLUSERS01.DBF 4 USERS 332922880 40640 AVAILABLE 4 YES 3435972198 4194302 160 331874304 40512 ONLINE C:ORACELBASEORADATAORCLUNDOTBS01.DBF 3 UNDOTBS1 104857600 12800 AVAILABLE 3 YES 3435972198 4194302 640 103809024 12672 ONLINE C:ORACELBASEORADATAORCLSYSAUX01.DBF 2 SYSAUX 566231040 69120 AVAILABLE 2 YES 3435972198 4194302 1280 565182464 68992 ONLINE C:ORACELBASEORADATAORCLSYSTEM01.DBF 1 SYSTEM 713031680 87040 AVAILABLE 1 YES 3435972198 4194302 1280 711983104 86912 SYSTEM C:ORACELBASEORADATAORCLEXAMPLE01.DBF 5 EXAMPLE 104857600 12800 AVAILABLE 5 YES 3435972198 4194302 80 103809024 12672 ONLINE C:ORCL1122DISK5LIANXI01.DBF 6 LIANXI 52428800 6400 AVAILABLE 6 NO 0 0 0 52355072 6391 ONLINE C:ORCL1122DISK5LIANXI02.DBF 7 LIANXI 52428800 6400 AVAILABLE 7 NO 0 0 0 52355072 6391 ONLINE 7 rows selected SQL>

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!