query clob settings in oracle
27 June 2015
You can query all clob related settings from the database with the following query.
TABLE_NAME | COLUMN_NAME | isSecureFile | Compressed | Encrypted | Deduplicated | StoredInRow |
---|---|---|---|---|---|---|
SAMPLE_DATASET_INTRO | XMLDATA | YES | NO | NO | NO | YES |
SAMPLE_DATASET_EVOLVE | XMLDATA | YES | NO | NO | NO | YES |
SAMPLE_DATASET_PARTN | XMLDATA | YES | NO | NO | NO | YES |
SAMPLE_DATASET_FULLTEXT | XMLDATA | YES | NO | NO | NO | YES |
SAMPLE_DATASET_XQUERY | XMLDATA | YES | NO | NO | NO | YES |
SAMPLE_DATASET_REPOS | IMAGE | YES | NO | NO | NO | YES |