Bonjour,
Quand j'essaye all_tables on m'affiche ça , je ne vois pas du tout le nom de la base .... y a que le nom d'utilisateur et le nom de la table :
OWNER TABLE_NAME
------------------------------ ------------------------------
TABLESPACE_NAME CLUSTER_NAME
------------------------------ ------------------------------
IOT_NAME STATUS PCT_FREE PCT_USED INI_TRANS
------------------------------ -------- ---------- ---------- ----------
MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE
---------- -------------- ----------- ----------- ----------- ------------
FREELISTS FREELIST_GROUPS LOG B NUM_ROWS BLOCKS EMPTY_BLOCKS AVG_SPACE
---------- --------------- --- - ---------- ---------- ------------ ----------
CHAIN_CNT AVG_ROW_LEN AVG_SPACE_FREELIST_BLOCKS NUM_FREELIST_BLOCKS DEGREE
---------- ----------- ------------------------- ------------------- ----------
INSTANCES CACHE TABLE_LO SAMPLE_SIZE LAST_ANAL PAR IOT_TYPE T S NES BUFFER_
---------- ----- -------- ----------- --------- --- ------------ - - --- -------
FLASH_C CELL_FL ROW_MOVE GLO USE DURATION SKIP_COR MON
------- ------- -------- --- --- --------------- -------- ---
CLUSTER_OWNER DEPENDEN COMPRESS COMPRESS_FOR DRO REA SEG
------------------------------ -------- -------- ------------ --- --- ---
RESULT_
-------
USER01 LOCALITE
Partager