How do you know which tables are FTS

zhaozj2021-02-16  62

SQL> DESC OBJ $ name empty? Type ---------------------------------------- -------------------------------- Obj # not null Number DataObj # Number Owner # not null Number Name NOT NULL VARCHAR2 (30) Namespace Not Null Number Subname VARCHAR2 (30) FTS Table Select O.Name from Obj $ O, x $ bh x where x.obj = o.Dataobj # and standard.bitand (x.flag, 524288)> 0 and o.owner # = 41; SQL> SELECT O.NAME from Obj $ O, x $ bh x 2 Where x.obj = o.dataobj # 3 and standard.bitand (x.flag, 524288)> 0 4 and O.owner # = 41; name ---------------------------- T1 DESC X $ BH SQL>

DESC X $ BH name empty?

Types of ---------------------------------------- -------- - ---------------- ADDR RAW (4) Indx Number INST_ID NUMBER BUF # Number HLADDR RAW (4) NXT_HASH RAW (4) PRV_HASH RAW (4) NXT_REPL RAW (4) PRV_REPL Raw (4) Flag Number Lru_FLAG Number TS # Number File # Number DBARFIL Number Dbablk Number Class NUMBER STATE NUMBER MODE_HELD NUMBER CHANGES NUMBER CSTATE NUMBER X_TO_NULL NUMBER FORCED_READS NUMBER FORCED_WRITES NUMBER LE_ADDR RAW (4) DIRTY_QUEUE NUMBER SET_DS RAW (4) OBJ NUMBER BA RAW (4) CR_SCN_BAS

转载请注明原文地址:https://www.9cbs.com/read-16946.html

New Post(0)