Histórico da Página
...
Por fim, será necessário executar um comando SQL no banco de dados a ser usado para o fluig:
Bloco de código | ||
---|---|---|
| ||
CREATE VIEW ALL_OBJECTS AS SELECT * FROM SYS.ALL_OBJECTS WHERE OWNER = sys_context('USERENV', 'CURRENT_SCHEMA'); CREATE VIEW ALL_SYNONYMS AS SELECT * FROM SYS.ALL_SYNONYMS WHERE OWNER = sys_context('USERENV', 'CURRENT_SCHEMA'); CREATE VIEW ALL_SEQUENCES AS SELECT * FROM SYS.ALL_SEQUENCES WHERE SEQUENCE_OWNER = sys_context('USERENV', 'CURRENT_SCHEMA'); CREATE VIEW ALL_CONSTRAINTS AS SELECT * FROM SYS.ALL_CONSTRAINTS WHERE OWNER = sys_context('USERENV', 'CURRENT_SCHEMA'); CREATE VIEW ALL_CONS_COLUMNS AS SELECT * FROM SYS.ALL_CONS_COLUMNS WHERE OWNER = sys_context('USERENV', 'CURRENT_SCHEMA'); CREATE VIEW ALL_INDEXES AS SELECT * FROM SYS.ALL_INDEXES WHERE OWNER = sys_context('USERENV', 'CURRENT_SCHEMA'); CREATE VIEW ALL_IND_COLUMNS AS SELECT * FROM SYS.ALL_IND_COLUMNS WHERE TABLE_OWNER = sys_context('USERENV', 'CURRENT_SCHEMA'); CREATE VIEW ALL_TABLES AS SELECT * FROM SYS.ALL_TABLES WHERE OWNER = sys_context('USERENV', 'CURRENT_SCHEMA'); CREATE VIEW ALL_TAB_COLUMNS AS SELECT * FROM SYS.ALL_TAB_COLUMNS WHERE OWNER = sys_context('USERENV', 'CURRENT_SCHEMA'); |
...
Visão Geral
Import HTML Content
Conteúdo das Ferramentas
Tarefas