Use http://home.adelphia.net/~marist89/s...ow_invalid.htm to find which objects are still invalid. Then,
Code:ALTER PACKAGE owner.package_name COMPILE BODY;
Printable View
Use http://home.adelphia.net/~marist89/s...ow_invalid.htm to find which objects are still invalid. Then,
Code:ALTER PACKAGE owner.package_name COMPILE BODY;
Jeff,
Compile those objects is not the solution for it. I did try to compile them before I ask you, but it's still INVALID so that I ask you if we have to run any other scripts to compile them, here are some of the invalid objects.
DBMSOBJG
DBMSOBJG2
DBMSOBJGWRAPPER
DBMS_DEFER
DBMS_DEFER_QUERY_UTL
DBMS_DEFER_SYS
DBMS_DEFER_SYS_PART1
DBMS_IAS_INST_UTL
DBMS_IAS_MT_INST
DBMS_INTERNAL_REPCAT
DBMS_OFFLINE_RGT
DBMS_OFFLINE_SNAPSHOT
it had about 30 of them
Thanks
I am still waiting for response. Please help !!!
Looks like the migration did not go through properly!!! What did you use to migrate the database? Looking at the scenario, I would suggest that you run the utl080106.sql script to first migrate the database and then run the catlog, catproc catrep and other necessary scripts.
Before doing any of these, have a good backup.
Sam
Sam,
thanks for your reply, this objects happened after I ran the catrep.sql. Before I ran this, everything was fine. Even those object are invalid but the database still running ok with no problem, how could I tell or check to see if there are problem with my database ??? I used the migration utilities from Oracle to migrate the database
Any idea ???
thanks
To better undestand things, could you tell the scripts that you ran and the order in whcih you ran them.
Sam
Sam,
if you could please refer back to my original post on this thread, basically, I migrate the database to 8.1.7 and I have some weird message, but all of my objects still fine and valid that time, so Jeff advise me to run the catrep.sql and I ran it, after I ran it I found there are INVALID objects owneed by SYS
thanks
Fill me in...Quote:
Originally posted by mike73
Does it mean that the database already upgrade to 8.1.7 Even the message tell me the database is not upgraded ??? and I just need to to run catrap.sql to finish the migration ???
It's really weird b/c the message said the database is not upgraded but when I look into the V$version and I had the new version 8.1.7.2.1 which I don't understand it seem like it migrated to the new version ok but give me that message. Please explain to me what's going on, Jeff.
1. How did you go up to 8.1.7.2.1?
a) Direct
b) First to 8.1.7 and then the patch
2. On the case of option 1.b did you disable the system triggers at the time of running the scripts ( i.e did you follow the readme for the patch )
More questiones, but no solutions :)
Sam
These objects are created by catrep.sql. Are you sure you had replication installed?Quote:
Originally posted by mike73
DBMSOBJG
DBMSOBJG2
DBMSOBJGWRAPPER
DBMS_DEFER
DBMS_DEFER_QUERY_UTL
DBMS_DEFER_SYS
DBMS_DEFER_SYS_PART1
DBMS_IAS_INST_UTL
DBMS_IAS_MT_INST
DBMS_INTERNAL_REPCAT
DBMS_OFFLINE_RGT
DBMS_OFFLINE_SNAPSHOT
Good point!!!Quote:
Originally posted by marist89
These objects are created by catrep.sql. Are you sure you had replication installed?Quote:
Originally posted by mike73
DBMSOBJG
DBMSOBJG2
DBMSOBJGWRAPPER
DBMS_DEFER
DBMS_DEFER_QUERY_UTL
DBMS_DEFER_SYS
DBMS_DEFER_SYS_PART1
DBMS_IAS_INST_UTL
DBMS_IAS_MT_INST
DBMS_INTERNAL_REPCAT
DBMS_OFFLINE_RGT
DBMS_OFFLINE_SNAPSHOT
Sam