Histórico da Página
...
- userid: Nome do usuário criado anteriormente;
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'); |
Nota | ||
---|---|---|
| ||
O comando SQL acima deverá ser executado usando o usuários "userid" criado anteriormente. |
Oracle 12c:
Caso seja utilizado Oracle 12c ou superior é necessário alterar o arquivo <INSTALL_FLUIG>\jboss\bin\standalone.conf.bat(standalone.conf em ambientes Linux) e incluir a seguinte linha:
...
Nota | ||
---|---|---|
| ||
NLS (National Language Support) é utilizado para definir datas, números, moeda e configurações de idioma. O NLS_CHARACTERSET para o Fluig é AL32UTF8.
|
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');