Oracle表空间-本地管理新建

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>