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

    Unanswered: error during import........

    hi,
    I tried to import file dmp oracle but I get always this error:

    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:V08.01.07 via conventional path
    import done in WE8DEC character set and AL16UTF16 NCHAR character set
    import server uses WE8MSWIN1252 character set (possible charset conversion)
    export server uses WE8ISO8859P1 NCHAR character set (possible ncharset conversion)
    . importing AFM_SECURE's objects into AFM_SECURE
    IMP-00017: following statement failed with ORACLE error 1950:
    "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 LOGGING STORAGE(INITIAL 16384 NEXT 16384 MINEX"
    "TENTS 1 MAXEXTENTS 121 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_P"
    "OOL DEFAULT) "
    IMP-00003: ORACLE error 1950 encountered
    ORA-01950: no privileges on tablespace 'AFM_P1'
    IMP-00017: following statement failed with ORACLE error 1950:
    "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 LOGGING STORAGE(INITIAL 16384 NEXT 16384 MI"
    "NEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFE"
    "R_POOL DEFAULT) "
    IMP-00003: ORACLE error 1950 encountered
    ORA-01950: no privileges on tablespace 'AFM_P1'
    Import terminated successfully with warnings.

    I made these steps:

    CREATE TABLESPACE AFM_P1 DATAFILE 'c:\....\AFM_P01.dbf' SIZE 1000M EXTENT MANAGEMENT LOCAL UNIFORM;
    CREATE USER AFM_SECURE IDENTIFIED BY AFM DEFAULT TABLESPACE AFM_P1 TEMPORARY TABLESPACE TEMP;

    imp system/manager@mydb fromuser=afm_secure touser=afm_secure file=c:\myfile.dmp log=c:\myfile.log

    What I wrong?

    Problem of version?
    Must I drop and recreate tablespace?

    Help!
    Thanks in advance!

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    grant connect, resource on AFM_P1 to AFM_SECURE;

Posting Permissions

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