oracle-databaseoracle9itablespaceflashback

How can I retrieve the value of an attribute supported by Oracle?


  1. Tablespace FlashBack
CREATE TABLESPACE TS_Physical
    DATAFILE
        '\physical_df.dbf'
            SIZE 1024000
            AUTOEXTEND OFF
    BLOCKSIZE 8192
    LOGGING
    FORCE LOGGING
    ONLINE
    EXTENT MANAGEMENT
        LOCAL AUTOALLOCATE
    SEGMENT SPACE MANAGEMENT AUTO
    FLASHBACK ON;

I looked up USER_TABLESPACES and DBA_TABLESPACES that store tablespace information, but there is no entry called FlashBack.

SELECT * FROM USER_TABLESPACES;
SELECT * FROM DBA_TABLESPACES;

I obviously have flashback on. How can I query whether the tablespace is using flashback or not?

If it is an item that cannot be viewed, please share a link to the related document.


Solution

  • V$TABLESPACE.FLASHBACK_ON

    SQL> select name,flashback_on from v$tablespace;
    
    NAME                           FLASHBACK_ON
    ------------------------------ ------------
    SYSTEM                         YES
    SYSAUX                         YES
    UNDOTBS1                       YES
    TEMP                           YES
    USERS                          YES