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

Question

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.

Sayan Malakshinov · Accepted Answer · 2022-02-11 01:24:41Z

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

answered Feb 11, 2022 at 1:24

Sayan Malakshinov

8,7501 gold badge21 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user13746660 Over a year ago

The flashback_on keyword is not known in 9i.

EdStevens Over a year ago

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

Collectives™ on Stack Overflow

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

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related