Algunas tablas del sistema de Oracle utiles.
/*
ALL_ARGUMENTS Arguments in object accessible to the user
argumentos a objeto accesible para el usuario
*/
select *
from ALL_ARGUMENTS
/*
ALL_CATALOG All tables, views, synonyms, sequences accessible to the user
Tablas, vistas, sinonimos y secuencias accesibles por el usuario
*/
select *
from ALL_CATALOG
/*
ALL_COL_COMMENTS Comments on columns of accessible tables and views
Comentarios en columnas accesibles por el usuario
*/
select *
from ALL_COL_COMMENTS
/*
ALL_CONSTRAINTS Constraint definitions on accessible tables
Restricciones definidas
*/
select *
from ALL_CONSTRAINTS
/*
ALL_CONS_COLUMNS Information about accessible columns in constraint definitions
*/
select *
from ALL_CONS_COLUMNS
/*
ALL_DB_LINKS Database links accessible to the user
Links accesibles a BBDD
*/
select *
from ALL_DB_LINKS
/*
ALL_ERRORS Current errors on stored objects that user is allowed to create
Errores actuales sobre los objetos modificables
*/
select *
from ALL_ERRORS
/*
ALL_INDEXES Descriptions of indexes on tables accessible to the user
Descripcion de los indices de las tablas
*/
select *
from ALL_INDEXES
/*
ALL_IND_COLUMNS COLUMNs comprising INDEXes on accessible TABLES
*/
select *
from ALL_IND_COLUMNS
/*
ALL_LOBS Description of LOBs contained in tables accessible to the user
*/
select *
from ALL_LOBS
/*
ALL_OBJECTS Objects accessible to the user
Objetos accesibles por el usuario
*/
select *
from ALL_OBJECTS
/*
ALL_OBJECT_TABLES Description of all object tables accessible to the user
Descripcion de todos los objetos de las tablas
*/
select *
from ALL_OBJECT_TABLES
/*
ALL_SEQUENCES Description of SEQUENCEs accessible to the user
Descripcion de las secuencias definidas
*/
select *
from ALL_SEQUENCES
/*
ALL_SNAPSHOTS Snapshots the user can access
Instantaneas que el usuario puede acceder
*/
select *
from ALL_SNAPSHOTS
/* **!!***
ALL_SOURCE Current source on stored objects that user is allowed to create
Codigo fuente
*/
select *
from ALL_SOURCE
/*
ALL_SYNONYMS All synonyms accessible to the user
Descripcion de los sinonimos
*/
select *
from ALL_SYNONYMS
/*
ALL_TABLES Description of relational tables accessible to the user
Descripcion de las tablas del esquema
*/
select *
from ALL_TABLES
/*
ALL_TAB_COLUMNS Columns of user's tables, views and clusters
Descripcion de las columnas de las tablas
*/
select *
from ALL_TAB_COLUMNS
/*
ALL_TAB_COL_STATISTICS Columns of user's tables, views and clusters
*/
select *
from ALL_TAB_COL_STATISTICS
/*
ALL_TAB_COMMENTS Comments on tables and views accessible to the user
Comentarios de las tablas
*/
select *
from ALL_TAB_COMMENTS
/*
ALL_TRIGGERS Triggers accessible to the current user
*/
select *
from ALL_TRIGGERS
/*
ALL_TRIGGER_COLS Column usage in user's triggers or in triggers on user's tables
*/
select *
from ALL_TRIGGER_COLS
/*
ALL_TYPES Description of types accessible to the user
*/
select *
from ALL_TYPES
/*
ALL_UPDATABLE_COLUMNS Description of all updatable columns
Descripcion de las columnas modificables
*/
select *
from ALL_UPDATABLE_COLUMNS
/*
ALL_USERS Information about all users of the database
Informacion de los usuarios
*/
select *
from ALL_USERS
/*
ALL_VIEWS Description of views accessible to the user
*/
select *
from ALL_VIEWS