oracle error 1658!!!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: oracle error 1658!!!

  1. #1
    Join Date
    Mar 2002
    Posts
    17
    This is the error I get when doing an import. The Layout table has an extremly large amount of records. What is the best way to resolve this. In addition, when I fix this problem I want to be able to drop all user objects and import again with getting the same error.

    Note.. There were 50 other tables in the imp (USERS Tablespace) that did import successfully

    Oracle version 8.0.6

    IMP-00017: following statement failed with ORACLE error 1658:
    "CREATE TABLE "LAYOUT" ("LAYOUT_ID" NUMBER(10, 0) NOT NULL ENABLE, "PRINTER_"
    "TYPE" VARCHAR2(1) NOT NULL ENABLE, "NUM_OF_INS" NUMBER(10, 0) NOT NULL ENAB"
    "LE, "DATA_STREAM_LEN" NUMBER(10, 0) NOT NULL ENABLE, "TOTAL_DATA_LEN" NUMBE"
    "R(10, 0) NOT NULL ENABLE, "GENERATE_IND" VARCHAR2(1) NOT NULL ENABLE, "INSE"
    "RT_DATE" VARCHAR2(10) NOT NULL ENABLE, "LASTUPD_DATE_TIME" VARCHAR2(19) NOT"
    " NULL ENABLE, "LASTUPD_MICROSEC" NUMBER(10, 0) NOT NULL ENABLE, "REVISION" "
    "NUMBER(10, 0) NOT NULL ENABLE, "VERSION" NUMBER(10, 0) NOT NULL ENABLE, "DE"
    "SCRIPTION" LONG RAW) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING"
    " STORAGE(INITIAL 35389440 NEXT 589824 MINEXTENTS 1 MAXEXTENTS 400 PCTINCREA"
    "SE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "USERS""
    IMP-00003: ORACLE error 1658 encountered
    ORA-01658: unable to create INITIAL extent for segment in tablespace USERS


    Thanks,

    Kevin

  2. #2
    Join Date
    Mar 2001
    Posts
    144
    increase the space for the tablespace "USERS" or precreate the table with a smaller initial extent size.

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    You don't have enough contiguous free space. Either pre-create your table with a smaller initial extent and use ignore=y, or make more space in the USERS tablespace.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  4. #4
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    Or execute export(exp) whithout parameter :
    COMPRESS=y
    has to be :
    COMPRESS=N

  5. #5
    Join Date
    Mar 2002
    Posts
    17
    Thanks, I will give your suggestions a try.

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