DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: error during import........

  1. #1
    Join Date
    Jul 2002
    Posts
    228

    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

    How I wrong?

    Problem of version?
    Must I drop and recreate tablespace?

    Help!
    Thanks in advance!

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    alter user afm_secure quota unlimited on AFM_P1; (or specify a size instead of unlimited)

    you gave them no rights to create any data in that tablespaces

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