terça-feira, 24 de novembro de 2009

Oracle Application Development Tools Statement of Direction: Oracle Forms, Oracle Reports and Oracle Designer

http://www.oracle.com/technology/products/forms/pdf/10g/ToolsSOD.pdf

sábado, 21 de novembro de 2009

Invalid Objects After Removing OLAP or Migration of a Database to 64 Bit

Doc Id: 565773.1

-> conn / as sysdba
SQL> @?/olap/admin/catnoamd.sql
SQL> @?/olap/admin/olapidrp.plb
SQL> @?/olap/admin/catnoaps.sql
SQL> @?/olap/admin/catnoxoq.sql

Determine all PUBLIC synonyms referring to objects in the OLAPSYS schema:

SQL>spool olapdrop.sql
SQL> select 'drop public synonym ' || synonym_name || ';'
from dba_synonyms
where owner='PUBLIC' and table_owner='OLAPSYS';
SQL>spool off


Modify the datapump handler table to remove handlers used to export OLAP data:

SQL>select * from sys.exppkgact$ where package = 'DBMS_AW_EXP' and
schema= 'SYS';
SQL>delete from sys.exppkgact$ where package = 'DBMS_AW_EXP'
and schema= 'SYS';
SQL>commit;

quinta-feira, 19 de novembro de 2009

PL/SQL Web - File Upload and Download Procedures

http://www.oracle-base.com/articles/9i/FileUploadDownloadProcedures9i.php

quinta-feira, 12 de novembro de 2009

Oradebug - Diagnosing Library Cache Latch Contention

http://arup.blogspot.com/2008/08/diagnosing-library-cache-latch.html

segunda-feira, 9 de novembro de 2009

RAC One Node tips

http://www.dba-oracle.com/t_rac_one_node.htm

Oracle Enterprise Manager Desktop Widgets

http://blogs.oracle.com/emwidgets/