Oracle migration.

[Quoted]         I'm transferring an Oracle database 7.0.16 on Solaris 2.4 to 7.3.4.0.1 on a new Sun E450 (2cpu 1GB RAM 120 MB SGA) running Solaris 2.6. The old database contains Forms 3.0, Menu 5.0, pl/sql & Pro*C applications. I want to transfer all these to the new database. After installing 7.3.4 on new machine and doing a full import of a full export of old database, I'm getting following errors.  

1)
IMP-00041: Warning: object created with compilation warnings
"CREATE PROCEDURE "BILL"."EMAILPURGE"

TIMES"
"TAMP '1999-02-18:16:02:37' "

IMP-00008: unrecognized statement in the export file:   \375\377\207
IMP-00008: unrecognized statement in the export file:   ^F
IMP-00008: unrecognized statement in the export file:  

2)
IMP-00041: Warning: object created with compilation warnings
"CREATE FORCE VIEW "SYSTEM"."MENU_V_PARAM"
("SUBSTI"   "TUTION_STRING","APPLICATION_NAME","PAR_SIZE","PAR_DEF","ECHO","MUST_FILL",""
"RESPONSE_REQUIRED","UPPER_CASE","OBJECT_TEXT_ID","PROMPT") AS "
"SELECT

"SUBSTITUTION_STRING","APPLICATION_NAME","PAR_SIZE","PAR_DEF","ECHO""
","MUST_FILL","RESPONSE_REQUIRED","UPPER_CASE","OBJECT_TEXT_ID","PROMPT"
FRO"
"M MENU_B_PARAM " IMP-00017: following statement failed with ORACLE error 4063:
"GRANT SELECT ON "MENU_V_PARAM" TO "BILL" WITH GRANT OPTION"
IMP-00003: ORACLE error 4063 encountered  

etc....  

        From whatever I've read, I understand pl/sql procedures do not need recompilation. When I'm manually compiling pl/sql applications, it is working fine.

        I've installed Forms 3.0 & Menu 5.0 in a separate ORACLE_HOME. Are the type 2) errors coming because of the absence of both in 7.3.4. How do I import old Forms applications & run in new system.

        Also, since Solaris 2.6 ensures binarty compatibility, should I recompile Pro*C applications.

        Finally, I've ensured all date fields in forms 3.0 applications to be in 'DD-MON-YYYY' form. Will this not ensure Y2K compliance.  

Thanks & regards,
Vikas Received on Fri Oct 01 1999 - 08:20:53 CEST