Oracle Tablas del Sistema (parte I / II)

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