| Errors Migrating from oracle 9i enterprise edition to oracle 10g r2 standard [message #425264] |
Thu, 08 October 2009 05:59  |
vags76
Messages: 12
Registered: February 2009
|
Junior Member |
|
|
guys
I had a database under oracle 9i enterprise edition and had to migrate it to oracle 10g patched to 10.2.0.4.0
i finalised the structure fo database and tried to import data but got the following errors:
1) First,
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 14, column 5:
PLS-00201: identifier 'SYS.LTADM' must be declared
ORA-06550: line 14, column 1:
PL/SQL: Statement ignored
2) Second
IMP-00017: following statement failed with ORACLE error 439:
"CREATE TABLE "LOGSTDBY$APPLY_PROGRESS" ("XIDUSN" NUMBER, "XIDSLT" NUMBER, ""
"XIDSQN" NUMBER, "COMMIT_SCN" NUMBER, "SPARE1" NUMBER, "SPARE2" NUMBER, "SPA"
"RE3" VARCHAR2(2000)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 TABLESP"
"ACE "SYSTEM" LOGGING PARTITION BY RANGE ("COMMIT_SCN" ) (PARTITION "P0" VA"
"LUES LESS THAN (0) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(I"
"NITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "SYSTEM" LOGGING NOC"
"OMPRESS )"
IMP-00003: ORACLE error 439 encountered
ORA-00439: feature not enabled: Partitioning
and
3) Third
IMP-00017: following statement failed with ORACLE error 439:
"CREATE ROLE "GLOBAL_AQ_USER_ROLE" IDENTIFIED GLOBALLY "
IMP-00003: ORACLE error 439 encountered
ORA-00439: feature not enabled: Enterprise User Security
and finally the following error
3) IMP-00017: following statement failed with ORACLE error 439:
"CREATE ROLE "GLOBAL_AQ_USER_ROLE" IDENTIFIED GLOBALLY "
could please someone advice me???and gimme some possible hints and tips on those???
Thanx in advance
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
