'How can I retrieve the value of an attribute supported by Oracle?
- 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.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
