http://www.oracle.com/technology/products/forms/pdf/10g/ToolsSOD.pdf
terça-feira, 24 de novembro de 2009
sábado, 21 de novembro de 2009
Invalid Objects After Removing OLAP or Migration of a Database to 64 Bit
10:24
No comments
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;
-> 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;
