Oracle表空间-还原表空间新建

1、新建
SQL> create undo tablespace lianxi_undo
  2  datafile 'C:\orcl1122\disk5\lianxi_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>