Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002
    Posts
    227

    Unanswered: error during import dmp....

    hi,
    I did these steps:
    CREATE TABLESPACE AFM_P1 DATAFILE 'c:\....\AFM_P01.dbf' SIZE 1700M EXTENT MANAGEMENT LOCAL UNIFORM;
    CREATE USER AFM_SECURE IDENTIFIED BY AFM DEFAULT TABLESPACE AFM_P1 TEMPORARY TABLESPACE TEMP;
    CREATE USER AFM IDENTIFIED BY AFM DEFAULT TABLESPACE AFM_P1 TEMPORARY TABLESPACE TEMP;
    GRANT CONNECT, RESOURCE, CREATE SYNONYM TO AFM;
    GRANT CONNECT, RESOURCE TO AFM_SECURE;

    imp system/manager@mydb fromuser=afm_secure touser=afm_secure file=C:\...\mydump.dmp log=C:\..\mylog.log

    BUT I GET THESE ERRORS:
    Connected to: Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production
    With the Partitioning option
    JServer Release 9.0.1.1.1 - Production

    Export file created by EXPORT:V09.02.00 via conventional path
    import done in WE8DEC character set and AL16UTF16 NCHAR character set
    import server uses WE8MSWIN1252 character set (possible charset conversion)
    export client uses WE8MSWIN1252 character set (possible charset conversion)
    . importing AFM_SECURE's objects into AFM_SECURE
    IMP-00017: following statement failed with ORACLE error 6550:
    "BEGIN "
    "sys.dbms_logrep_imp.instantiate_schema(schema_nam e=>'AFM_SECURE', export_db"
    "_name=>'CENTOS.US.ORACLE.COM', inst_scn=>'809152');"
    "COMMIT; END;"
    IMP-00003: ORACLE error 6550 encountered
    ORA-06550: line 2, column 1:
    PLS-00201: identifier 'SYS.DBMS_LOGREP_IMP' must be declared
    ORA-06550: line 2, column 1:
    PL/SQL: Statement ignored
    IMP-00017: following statement failed with ORACLE error 922:
    "CREATE TABLE "AFM_GROUPS" ("GROUP_NAME" VARCHAR2(10) NOT NULL ENABLE, "GROU"
    "P_TITLE" VARCHAR2(128), "WW_PREFERENCES" VARCHAR2(2000)) PCTFREE 10 PCTUSE"
    "D 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 16384 FREELISTS 1 FREELIST GRO"
    "UPS 1) TABLESPACE "AFM_P1" LOGGING NOCOMPRESS"
    IMP-00003: ORACLE error 922 encountered
    ORA-00922: missing or invalid option
    IMP-00017: following statement failed with ORACLE error 922:
    "CREATE TABLE "AFM_USERS" ("USER_NAME" VARCHAR2(32) NOT NULL ENABLE, "GROUP_"
    "1" VARCHAR2(10), "GROUP_10" VARCHAR2(10), "GROUP_2" VARCHAR2(10), "GROUP_3""
    " VARCHAR2(10), "GROUP_4" VARCHAR2(10), "GROUP_5" VARCHAR2(10), "GROUP_6" VA"
    "RCHAR2(10), "GROUP_7" VARCHAR2(10), "GROUP_8" VARCHAR2(10), "GROUP_9" VARCH"
    "AR2(10), "USER_LEVEL" NUMBER(*,0), "USER_PWD" VARCHAR2(10)) PCTFREE 10 PCT"
    "USED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 16384 FREELISTS 1 FREELIST "
    "GROUPS 1) TABLESPACE "AFM_P1" LOGGING NOCOMPRESS"
    IMP-00003: ORACLE error 922 encountered
    ORA-00922: missing or invalid option
    IMP-00008: unrecognized statement in the export file:
    yıu
    IMP-00008: unrecognized statement in the export file:
    R
    IMP-00008: unrecognized statement in the export file:

    What I wrong? or dmp file is corrupted??

    Thanks
    Raf

  2. #2
    Join Date
    Sep 2003
    Location
    Virginia, USA
    Posts
    246

    Re: error during import dmp....

    The export and import must be done using the lowest version of the two databases, which is 901 in your case. It looks like you used 920 to do the export, which embeds stuff 901 does not know how to import.
    MarkRem
    Author, Oracle Database 10g: From Nuts to Soup
    http://www.remidata.com/book_nuts2soup.htm

Posting Permissions

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