-
errors after migrating from oracle 9i enterprise ed. to oracle 10g r2 standard
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
-
The standard version of 10g does not have partitioning. If you migrate via import, you should create your partitioned tables as regular tables before you import and specify ignore=y on the import. You can also upgrade to enterprise edition.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|