terça-feira, 24 de novembro de 2009

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


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';

quinta-feira, 19 de novembro de 2009

PL/SQL Web - File Upload and Download Procedures


quinta-feira, 12 de novembro de 2009

Oradebug - Diagnosing Library Cache Latch Contention


segunda-feira, 9 de novembro de 2009

RAC One Node tips


Oracle Enterprise Manager Desktop Widgets