Results 1 to 4 of 4

Thread: import error

  1. #1
    Join Date
    Dec 2003
    Location
    India
    Posts
    33

    Unhappy Unanswered: import error

    Hi all,

    I am facing the following error while importing a table "BEARER" from a dump file which has been exported by another user. (1 Million rows)

    imp impuser/passwd@dbname fromuser=expuser touser=impuser file=\Dump\bckup\exp_01.dmp log=\Dump\bckup\exp_01.log tables=('BEARER')


    __________________________________________________ ____________
    Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
    With the Partitioning, OLAP and Oracle Data Mining options
    JServer Release 9.2.0.1.0 - Production

    Export file created by EXPORT:V09.02.00 via conventional path

    Warning: the objects were exported by EXPUSER, not by you

    import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
    IMP-00017: following statement failed with ORACLE error 1659:
    "CREATE TABLE "BEARER" ("BNO" NUMBER(9, 0), ........ , "HOLIDAY" VARCHAR2(20)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255"
    " STORAGE(INITIAL 111984640 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "TBS_01" LOGGING NOCOMPRESS"
    IMP-00003: ORACLE error 1659 encountered
    ORA-01659: unable to allocate MINEXTENTS beyond 53 in tablespace TBS_01
    Import terminated successfully with warnings.
    __________________________________________________ _______________


    But the TBS_01 tablespace has 2GB space and the user IMPUSER has unlimited quota over its default tablespace TBS_01.

    Please advice.
    Papps...

  2. #2
    Join Date
    May 2004
    Location
    Germany
    Posts
    25
    Your 2 GB may not be enough. Increase the size of your tablespace. Do not expact the table to have the same size like the export file. The table needs significant more space.

    Oracle errormessages

    ORA-01659 unable to allocate MINEXTENTS beyond string in tablespace string

    Cause: Failed to find sufficient contiguous space to allocate MINEXTENTS for the segment being created.

    Action: Use ALTER TABLESPACE ADD DATAFILE to add additional space to the tablespace or retry with smaller value for MINEXTENTS, NEXT or PCTINCREASE.

  3. #3
    Join Date
    Nov 2002
    Posts
    833
    you need a continuous chunk in your tablespace of 111.984.640 bytes and your greatest chunk doen't fit this size
    either lower the inital extent or increase your tablespace

  4. #4
    Join Date
    Dec 2003
    Location
    India
    Posts
    33
    Thanks boss, I got the reults. The problem was with the storage parameters.
    Papps...

Posting Permissions

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