errors after migrating from oracle 9i enterprise ed. to oracle 10g r2 standard
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: errors after migrating from oracle 9i enterprise ed. to oracle 10g r2 standard

  1. #1
    Join Date
    Mar 2009
    Posts
    4

    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

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,997
    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.
    this space intentionally left blank

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width