Question:
I recently cloned a 10g database and I tried to execute an export on that database and I also noticed that the export never completed and stayed in the process list whenever I would do a 'ps -ef|grep exp'. I checked the logs and noticed these messages:
EXP-00090: cannot pin type "SYS"."AQ$_DEQUEUE_HISTORY
_T"
EXP-00056: ORACLE error 22303 encountered
OCI-22303: type "SYS"."AQ$_DEQUEUE_HISTORY
_T" not found
EXP-00000: Export terminated unsuccessfully
I searched for solution and I found one, one that stated that I should run '@utlrp.sql' in order to recompile invalid objects. I found that I had about 124 objects that had re-compliation errors. When I queried the UTL_RECOMP_ERRORS' table I got mostly these types of responses:
SQL> select * from UTL_RECOMP_ERRORS;
OBJ#
----------
ERROR_AT
--------------------------
----------
----------
----------
----------
---------
COMPILE_ERR
--------------------------
----------
----------
----------
----------
----------
----
16657
22-APR-08 06.04.26.210858 PM
ORA-04045: errors during recompilation/revalidation
of PUBLIC.PTSQL_FUNCTION_ARG
S
ORA-00980: synonym translation is no longer valid
16656
OBJ#
----------
ERROR_AT
--------------------------
----------
----------
----------
----------
---------
COMPILE_ERR
--------------------------
----------
----------
----------
----------
----------
----
22-APR-08 06.04.26.215549 PM
ORA-04045: errors during recompilation/revalidation
of PUBLIC.PTSQL_CONSTRDATA
ORA-00980: synonym translation is no longer valid
16655
22-APR-08 06.04.26.218910 PM
ORA-04045: errors during recompilation/revalidation
of PUBLIC.PTSQL_TABLES
How do I make these objects valid to that my exports run completely?
Thanks,
7Souls
purchased 6 Dell Computers and I have 6 product keys (and discs) in my IT safe. I forgot to assign the product key with the appropriate computer when I ran the setup. How do I locate the product key on each of the systems so that I am able to label my discs for future reference?
Start Free Trial
