Menu de navegação

[CVPRADOParticipante]

Pessoal,

Gostaria de saber se há algum select que traga como resultado, todas as view do Oracle9i Enterprise Edition Release 9.2.0.1.0 – Production

Outra dúvida
Alguem sabe dizer se há views padrões no Oracle e quais são, há algum comnado para listar essas view padrão?

[fsitjaParticipante]

É só buscar do dicionário de dados:

[code]
select * from dba_objects o where o.object_type = ‘VIEW’

ou

select * from dba_views
[/code

[fsitjaParticipante]

Desculpa, esbarrei no “enviar”… 😕

Então… você pode rodar o select na DBA_VIEWS ou, se você não tiver privilégios lá, na ALL_VIEWS (todas que você tem grants) ou USER_VIEWS (todas do seu usuário). A mesma coisa vale para DBA_OBJECTS.

Para ver views de sistema, faça:

select * from dba_views v where v.owner = 'SYS'


[vieriParticipante]

Perfeito fsitja.

Assim como o DBA tem que conhecer as views internas do banco,
desenvolvedores devem conhecer as views de usuário.

Não sei oque o CVPRADO que dizer com views padrões.
Mas se você quiser sumarizar as views internas do dicionário dados do Oracle basta dar uma passada na view dictionary ou abreviada de dict.

ex:

SQL> select * from dict where table_name like ‘%VIEW%’
2 ;

TABLE_NAME

COMMENTS

USER_VIEWS
Description of the user’s own views

ALL_VIEWS
Description of views accessible to the user

DBA_VIEWS
Description of all views in the database

TABLE_NAME

COMMENTS

ALL_MVIEW_ANALYSIS
Description of the materialized views accessible to the user

USER_MVIEW_ANALYSIS
Description of the materialized views created by the user

DBA_MVIEW_ANALYSIS
Description of the materialized views accessible to dba

TABLE_NAME

COMMENTS

DBA_MVIEW_AGGREGATES
Description of the materialized view aggregates accessible to dba

USER_MVIEW_AGGREGATES
Description of the materialized view aggregates created by the user

ALL_MVIEW_AGGREGATES
Description of the materialized view aggregates accessible to the user

TABLE_NAME

COMMENTS

ALL_MVIEW_DETAIL_RELATIONS
Description of the materialized view detail tables accessible to the user

USER_MVIEW_DETAIL_RELATIONS
Description of the materialized view detail tables of the materialized
views created by the user

DBA_MVIEW_DETAIL_RELATIONS
Description of the materialized view detail tables accessible to dba

TABLE_NAME

COMMENTS

DBA_MVIEW_KEYS
Description of the columns that appear in the GROUP BY
list of a materialized view accessible to dba

ALL_MVIEW_KEYS
Description of the columns that appear in the GROUP BY
list of a materialized view accessible to the user

TABLE_NAME

COMMENTS

USER_MVIEW_KEYS
Description of the columns that appear in the GROUP BY
list of a materialized view created by the user

DBA_MVIEW_JOINS
Description of a join between two columns in the
WHERE clause of a materialized view accessible to dba

ALL_MVIEW_JOINS

TABLE_NAME

COMMENTS

Description of a join between two columns in the
WHERE clause of a materialized view accessible to the user

USER_MVIEW_JOINS
Description of a join between two columns in the
WHERE clause of a materialized view created by the user

DBA_MVIEW_COMMENTS
Comments on all materialized views in the database

TABLE_NAME

COMMENTS

ALL_MVIEW_COMMENTS
Comments on materialized views accessible to the user

USER_MVIEW_COMMENTS
Comments on materialized views owned by the user

DBA_TUNE_MVIEW
Catalog View to show the result after executing TUNE_MVIEW() API

TABLE_NAME

COMMENTS

USER_TUNE_MVIEW
tune_mview catalog view owned by the user

DBA_MVIEWS
All materialized views in the database

ALL_MVIEWS
All materialized views in the database

TABLE_NAME

COMMENTS

USER_MVIEWS
All materialized views in the database

DBA_MVIEW_REFRESH_TIMES
All fast refreshable materialized views and their last refresh times for each ma
ster table

ALL_MVIEW_REFRESH_TIMES

TABLE_NAME

COMMENTS

Materialized views and their last refresh times for each master table that the
user can look at

USER_MVIEW_REFRESH_TIMES
Materialized views and their last refresh times for each master table that the u
ser can look at

DBA_MVIEW_LOGS
All materialized view logs in the database

TABLE_NAME

COMMENTS

ALL_MVIEW_LOGS
All materialized view logs in the database that the user can see

USER_MVIEW_LOGS
All materialized view logs owned by the user

DBA_BASE_TABLE_MVIEWS
All materialized views with log(s) in the database

TABLE_NAME

COMMENTS

ALL_BASE_TABLE_MVIEWS
All materialized views with log(s) in the database that the user can see

USER_BASE_TABLE_MVIEWS
All materialized views with log(s) owned by the user in the database

DBA_REGISTERED_MVIEWS
Remote materialized views of local tables

TABLE_NAME

COMMENTS

ALL_REGISTERED_MVIEWS
Remote materialized views of local tables that the user can see

USER_REGISTERED_MVIEWS
Remote materialized views of local tables currently using logs owned by the user

DBA_MVIEW_LOG_FILTER_COLS
All filter columns (excluding PK cols) being logged in the materialized view log

TABLE_NAME

COMMENTS

s

DBA_REGISTERED_MVIEW_GROUPS
Materialized view repgroup registration information

DBA_XML_VIEWS
Description of all XML views in the database

ALL_XML_VIEWS

TABLE_NAME

COMMENTS

Description of the all XMLType views that the user has privileges on

USER_XML_VIEWS
Description of the user’s own XMLType views

DBA_XML_VIEW_COLS
Description of all XML views in the database

ALL_XML_VIEW_COLS

TABLE_NAME

COMMENTS

Description of the all XMLType views that the user has privileges on

USER_XML_VIEW_COLS
Description of the user’s own XMLType views

V$FIXED_VIEW_DEFINITION
Synonym for V_$FIXED_VIEW_DEFINITION

GV$FIXED_VIEW_DEFINITION

TABLE_NAME

COMMENTS

Synonym for GV_$FIXED_VIEW_DEFINITION

[Autor]

Posts