Página destinada a atualizações anteriores ao fluig 1.5.613 e anteriores.

Acesse a página original para atualizações a partir do fluig da atualização 1.6: Configuração do banco de dados Oracle.

• É imprescindível conectar no banco de dados com o usuário userid para a execução dos procedimentos abaixo, a fim de garantir o isolamento e integridade da operação.
• O servidor fluig deve estar parado no momento da execução do script.
  

DECLARE
  AUX_USERCONNECTED VARCHAR2(30);  
BEGIN
  SELECT SYS_CONTEXT('USERENV', 'CURRENT_SCHEMA')USER
    INTO AUX_USERCONNECTED
    FROM DUAL;
  IF (AUX_USERCONNECTED <> 'SYS') AND (AUX_USERCONNECTED <> 'SYSTEM') THEN
    EXECUTE IMMEDIATE ('CREATE OR REPLACE VIEW ' ||AUX_USERCONNECTED|| '.ALL_OBJECTS AS' ||
                      ' SELECT * FROM SYS.ALL_OBJECTS WHERE OWNER =' ||
                      ' SYS_CONTEXT(' || CHR(39) || 'USERENV' || CHR(39) || ', ' ||IN (SELECT USER FROM DUAL)');
    EXECUTE IMMEDIATE ('CREATE OR REPLACE              CHR(39)VIEW ' || 'CURRENT_SCHEMA' || CHR(39) AUX_USERCONNECTED|| ')');
    EXECUTE IMMEDIATE ('CREATE VIEW .ALL_SYNONYMS AS' ||
                      ' SELECT * FROM SYS.ALL_SYNONYMS WHERE OWNER =' ||
                      ' SYS_CONTEXT(' || CHR(39) || 'USERENV' || CHR(39) || ', ' ||IN (SELECT USER FROM DUAL)');
    EXECUTE IMMEDIATE ('CREATE OR REPLACE              CHR(39)VIEW ' || 'CURRENT_SCHEMA' AUX_USERCONNECTED|| CHR(39) || ')');
    EXECUTE IMMEDIATE ('CREATE VIEW '.ALL_SEQUENCES AS' ||
                      ' SELECT * FROM SYS.ALL_SEQUENCES WHERE SEQUENCE_OWNER =' ||
                      ' SYS_CONTEXT(' || CHR(39) || 'USERENV' || CHR(39) || ', ' ||IN (SELECT USER FROM DUAL)');
    EXECUTE IMMEDIATE ('CREATE OR REPLACE VIEW             CHR(39) || 'CURRENT_SCHEMA' || CHR(39) || ')');
    EXECUTE IMMEDIATE ('CREATE VIEW ' ||AUX_USERCONNECTED|| '.ALL_CONSTRAINTS AS' ||
                      ' SELECT * FROM SYS.ALL_CONSTRAINTS WHERE OWNER =' ||
                      ' SYS_CONTEXT(' || CHR(39) || 'USERENV' || CHR(39) || ', ' ||IN (SELECT USER FROM DUAL)');
    EXECUTE IMMEDIATE ('CREATE OR REPLACE              CHR(39)VIEW ' || 'CURRENT_SCHEMA' || CHR(39) AUX_USERCONNECTED|| ')');
    EXECUTE IMMEDIATE ('CREATE VIEW .ALL_CONS_COLUMNS AS' ||
                      ' SELECT * FROM SYS.ALL_CONS_COLUMNS WHERE OWNER =' ||
                      ' SYS_CONTEXT(' || CHR(39) || 'USERENV' || CHR(39) || ', ' ||IN (SELECT USER FROM DUAL)');
    EXECUTE IMMEDIATE ('CREATE OR REPLACE              CHR(39)VIEW ' || 'CURRENT_SCHEMA' AUX_USERCONNECTED|| CHR(39) || ')');
    EXECUTE IMMEDIATE ('CREATE VIEW '.ALL_INDEXES AS' ||
                      ' SELECT * FROM SYS.ALL_INDEXES WHERE OWNER =' ||
                      ' SYS_CONTEXT(' || CHR(39) || 'USERENV' || CHR(39) || ', ' ||IN (SELECT USER FROM DUAL)');
    EXECUTE IMMEDIATE ('CREATE OR REPLACE VIEW             CHR(39) || 'CURRENT_SCHEMA' || CHR(39) || ')');
    EXECUTE IMMEDIATE ('CREATE VIEW ' ||AUX_USERCONNECTED|| '.ALL_IND_COLUMNS AS' ||
                      ' SELECT * FROM SYS.ALL_IND_COLUMNS WHERE TABLE_OWNER =' ||
                      ' SYS_CONTEXT(' || CHR(39) || 'USERENV' || CHR(39) || ', ' ||IN (SELECT USER FROM DUAL)');
    EXECUTE IMMEDIATE ('CREATE OR REPLACE VIEW             CHR(39) || 'CURRENT_SCHEMA' || CHR(39) || ')');
    EXECUTE IMMEDIATE ('CREATE VIEW ' ||AUX_USERCONNECTED|| '.ALL_TABLES AS' ||
                      ' SELECT * FROM SYS.ALL_TABLES WHERE OWNER =' ||
                      ' SYS_CONTEXT(' || CHR(39) || 'USERENV' || CHR(39) || ', ' ||IN (SELECT USER FROM DUAL)');
    EXECUTE IMMEDIATE ('CREATE OR REPLACE              CHR(39)VIEW ' || 'CURRENT_SCHEMA' AUX_USERCONNECTED|| CHR(39) || ')');
    EXECUTE IMMEDIATE ('CREATE VIEW '.ALL_TAB_COLUMNS AS' ||
                      ' SELECT * FROM SYS.ALL_TAB_COLUMNS WHERE OWNER =' ||
                      ' SYS_CONTEXT(' || CHR(39) || 'USERENV' || CHR(39) || ', ' ||
                      CHR(39) || 'CURRENT_SCHEMA' || CHR(39) || ')')IN (SELECT USER FROM DUAL)');
  END IF;
END;

NLS (National Language Support) é utilizado para definir datas, números, moeda e configurações de idioma.

O NLS_CHARACTERSET para o Fluig a plataforma é AL32UTF8.