Tag: dictionary views

Loading “Views” from One Database to Another

Loading “views” from one database to another seems to be a simple request, right?  Let’s go to the regular cases/simple answers: Use DBMS_METDATA.GET_DDL to get the view code: DBMS_METADATA.get_ddl (‘VIEW’, <VIEW_NAME>, <OWNER>) Use datapump with include=VIEW, or even specifying the…

Read More >

Inefficient queries to ALL_SYNONYMS

Short summary: Queries to ALL_SYNONYMS cause FTS of SYS.OBJ$ which can’t be avoided.

Read More >