Home » RDBMS Server » Server Administration » Upgrading 8.1.7 to 10g
Upgrading 8.1.7 to 10g [message #125809] Wed, 29 June 2005 05:40 Go to next message
snagra
Messages: 23
Registered: March 2005
Junior Member
I've created a 10g database and copied schemas over using imp/exp. Do I need to run any upgrade scripts etc?
Re: Upgrading 8.1.7 to 10g [message #125836 is a reply to message #125809] Wed, 29 June 2005 08:07 Go to previous messageGo to next message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member
Hi,

No. You should only use the database upgrade scripts when you do an in-pace upgrade.

BTW: Remember to check if there are any application related upgrade scripts that you need to run on the database.

Best regards.

Frank
Re: Upgrading 8.1.7 to 10g [message #125840 is a reply to message #125836] Wed, 29 June 2005 08:19 Go to previous message
snagra
Messages: 23
Registered: March 2005
Junior Member
But when I do a full system backup it says

EXP-00008: Oracle error 6550 encountered
ORA-06550: line 1, column 13:
PLS-00201:identifier 'DMSYS.DBMS_DM_MODEL_EXP' must be declared
ORA-06550: line 1 column 7


Then lots of erros with

EXP-00091:Exporting questionable statistics


I thought this was due to scripts not being run at some point?
Previous Topic: Accessing Oracle DB on windows
Next Topic: ORA-04031: unable to allocate 44352 bytes of shared memory
Goto Forum:
  


Current Time: Fri Sep 27 00:13:12 CDT 2024