0
  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.

astentx
  • 6,393
  • 2
  • 16
  • 25

1 Answers1

1

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
Sayan Malakshinov
  • 8,492
  • 1
  • 19
  • 27
  • The flashback_on keyword is not known in 9i. –  Feb 11 '22 at 02:09
  • _"The flashback_on keyword is not known in 9i"_ Flashback was not available in 9i. Your CREATE TABLESPACE statement should have thrown an error when executed in 9i. And FWIW, 9i has been out of support since July 2010 - over 21 years ago. – EdStevens Feb 11 '22 at 13:28