Upgrading 8.1.7 to 10g [message #125809] |
Wed, 29 June 2005 05:40 |
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 |
Frank Naude
Messages: 4587 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 |
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?
|
|
|