OraFAQ Forum: Server Utilities » 8.05 to 8i IMPORT INVALID OBJECTS

Home » RDBMS Server » Server Utilities » 8.05 to 8i IMPORT INVALID OBJECTS

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

8.05 to 8i IMPORT INVALID OBJECTS [message #72595]

Mon, 28 July 2003 15:23

saustin
Messages: 43
Registered: June 2003

Member

Hi All,
Has anyone migrated from Oracle 8.05 to 8i (1.7.4) and seen
INVALID OBJECTS after the conversion (IMPORT) ? Normally compiling
the invalid objects takes care of this but to no avail here.

ALTER PACKAGE DBMSOBJG COMPILE BODY;
ALTER PACKAGE DBMS_DEFER COMPILE BODY;
ALTER PACKAGE DBMS_IAS_INST_UTL COMPILE BODY;
ALTER PACKAGE DBMS_IAS_MT_INST COMPILE BODY;
ALTER PACKAGE DBMS_OFFLINE_RGT COMPILE BODY;
ALTER PACKAGE DBMS_REPCAT_ADMIN COMPILE BODY;
ALTER PACKAGE DBMS_REPCAT_CONF COMPILE BODY;
ALTER PACKAGE DBMS_REPCAT_FLA COMPILE BODY;
ALTER PACKAGE DBMS_REPCAT_FLA_MAS COMPILE BODY;
ALTER PACKAGE DBMS_REPCAT_FLA_UTL COMPILE BODY;
ALTER PACKAGE DBMS_REPCAT_MAS COMPILE BODY;
ALTER PACKAGE DBMS_REPCAT_MIG_INTERNAL COMPILE BODY;
ALTER PACKAGE DBMS_REPCAT_RGT_CUST COMPILE BODY;
ALTER PACKAGE DBMS_REPCAT_SNA_UTL COMPILE BODY;
ALTER PACKAGE DBMS_REPCAT_UTL COMPILE BODY;
ALTER PACKAGE DBMS_REPCAT_UTL2 COMPILE BODY;
ALTER PACKAGE DBMS_REPCAT_UTL3 COMPILE BODY;
ALTER PACKAGE DBMS_REPCAT_UTL4 COMPILE BODY;
ALTER PACKAGE DBMS_REPCAT_VALIDATE COMPILE BODY;
ALTER PACKAGE DBMS_REPUTIL COMPILE BODY;

Still get MGR-00072: Warning: PACKAGE DBMS_REPCAT_UTL created with compilation errors on all of the above.

Have run utlrp, catalog, catproc, catexp.

Any ideas greatly appreciated, Steve.

Report message to a moderator

Re: 8.05 to 8i IMPORT INVALID OBJECTS [message #72596 is a reply to message #72595]

Mon, 28 July 2003 17:33

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

which method did you use to upgrade?
conventional methods ( scripts and odma) require 805 to be first upgraded to 806 and then you can upgrade to 8174

Report message to a moderator

Re: 8.05 to 8i IMPORT INVALID OBJECTS [message #72603 is a reply to message #72596]

Tue, 29 July 2003 07:27

saustin
Messages: 43
Registered: June 2003

Member

It was a full export dump of 8.0.5.2 and a full import of the dump. Can see the data just fine. The problem we are having is when setting up replication. This is when all the invalid objects give us trouble.
What would you try ?

Report message to a moderator

Re: 8.05 to 8i IMPORT INVALID OBJECTS [message #72604 is a reply to message #72603]

Tue, 29 July 2003 07:54

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

export/import will work fine only for data.
to upgrade the code( objects like procedures)
you have to go through the process of upgrade.
Becuase there might be many dictionary objects that are changed in the newer releases or certain options NO longer supported.
from 8052 first you have to migrate to 806 and then to 8i

Report message to a moderator

Previous Topic:	OMS service not starting in windows 2000
Next Topic:	export from oracle 8i to oracle 8.0.5

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jun 28 22:21:17 CDT 2024