initial extent and minextent
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: initial extent and minextent

  1. #1
    Join Date
    Feb 2007
    Posts
    1

    initial extent and minextent

    Hi,

    I have created a new database and I want to import one schema to my new database. While importing I am getting the following errors. If anybody knows what the exact problem is, please help me soon..

    Error regarding INITIAL EXTENT

    IMP-00003: ORACLE error 1658 encountered
    ORA-01658: unable to create INITIAL extent for segment in tablespace TS_ERIC
    IMP-00017: following statement failed with ORACLE error 1659:

    "CREATE TABLE "CON_KEY_TRANS" ("AGREEMENT_ID" VARCHAR2(15), "VERSION" NUMBER"
    "(4, 0), "PRODUCT_NO" VARCHAR2(24), "REVISION_STATE" VARCHAR2(7), "VIA_ID" N"
    "UMBER(10, 0), "TYPE_ID" NUMBER(38, 0), "PART_DATE_FROM" DATE, "CON_KEY" NUM"
    "BER(10, 0)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING STORAGE("
    "INITIAL 19398656 NEXT 8962048 MINEXTENTS 8 MAXEXTENTS 4096 PCTINCREASE 50 F"
    "REELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)


    Error regarding MINEXTENT

    IMP-00003: ORACLE error 1659 encountered
    ORA-01659: unable to allocate MINEXTENTS beyond 3 in tablespace TS_ERIC
    IMP-00017: following statement failed with ORACLE error 1659:

    "CREATE TABLE "CON_SUB_OPTION_VALID_VALUES" ("OPTION_ID" NUMBER(10, 0),
    "VALID_VALUE" VARCHAR2(250)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
    LOGGING STORAGE(INITIAL 19398656 NEXT 8962048 MINEXTENTS 8 MAXEXTENTS 4096
    PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) "

    This is the command I have given to create tablespace.

    CREATE TABLESPACE TS_ERIC
    DATAFILE 'ERIC01.DMP' SIZE 3072M
    AUTOEXTEND ON MAXSIZE UNLIMITED
    MINIMUM EXTENT 1K
    DEFAULT STORAGE (INITIAL 1K NEXT 60K)
    LOGGING;

    I have read that this error can happen because of two reasons ie either tablespace size is small or extent size is too large. Here both extents I have given 1K. Also I added more datafiles into the table space. Even I am getting the same error.

    Thanks in advance,
    Remya

  2. #2
    Join Date
    Jun 2006
    Location
    Chennai, INDIA
    Posts
    72

    Wink

    Hi,
    use compress=n while importing.

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    compress is an export option, not an import one

    but your tablespace is now too small to hold the data

  4. #4
    Join Date
    Feb 2005
    Posts
    158

    Quota ?

    The tablespace is set to autoextend indefinately, so maybe you have run out of physical disk on that device (or the amount available to oracle).
    Check the quota the user has on the tablespace too.

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