1、创建本地管理表空间： sql> create tablespace lianxi 2 datafile 'C:\orcl1122\disk5\lianxi01.dbf' size 50M,'C:\orcl1122\disk5\lianxi02.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:\ORACEL\BASE\ORADATA\ORCL\USERS01.DBF 4 USERS 332922880 40640 AVAILABLE 4 YES 3435972198 4194302 160 331874304 40512 ONLINE C:\ORACEL\BASE\ORADATA\ORCL\UNDOTBS01.DBF 3 UNDOTBS1 104857600 12800 AVAILABLE 3 YES 3435972198 4194302 640 103809024 12672 ONLINE C:\ORACEL\BASE\ORADATA\ORCL\SYSAUX01.DBF 2 SYSAUX 566231040 69120 AVAILABLE 2 YES 3435972198 4194302 1280 565182464 68992 ONLINE C:\ORACEL\BASE\ORADATA\ORCL\SYSTEM01.DBF 1 SYSTEM 713031680 87040 AVAILABLE 1 YES 3435972198 4194302 1280 711983104 86912 SYSTEM C:\ORACEL\BASE\ORADATA\ORCL\EXAMPLE01.DBF 5 EXAMPLE 104857600 12800 AVAILABLE 5 YES 3435972198 4194302 80 103809024 12672 ONLINE C:\ORCL1122\DISK5\LIANXI01.DBF 6 LIANXI 52428800 6400 AVAILABLE 6 NO 0 0 0 52355072 6391 ONLINE C:\ORCL1122\DISK5\LIANXI02.DBF 7 LIANXI 52428800 6400 AVAILABLE 7 NO 0 0 0 52355072 6391 ONLINE 7 rows selected sql> 原文链接：https://www.f2er.com/oracle/207632.html