Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Location
    Israel
    Posts
    2

    Red face Unanswered: ORA-01630: max # extents (300) reached in temp segment in tablespace PSAPBTABI

    Hi everyone. I'm a junior in Oracle and SAP/R3 systems so please try to help me.
    I'm trying to import SAP database using SAP tool called R3Setup.
    Durring this process I incresed the problematic tablespaces and all tablespaces's extents are 505 exclude PSAPTEMP which his mzx extents are 1000.
    Now after I solved few problems the process failed with this error:

    #Trying to create primary key "S034~0"
    DbSl Trace: ORA-1630 occured; SQL statement is ==>

    (IMP) ERROR: CREATE statement failed for object "S034"
    (CREATE UNIQUE INDEX "S034~0" ON "S034" ( "MANDT", "SSOUR",
    "VRSIO", "SPMON", "SPTAG", "SPWOC", "SPBUP", "WERKS",
    "LGORT", "MATNR", "CHARG" ) TABLESPACE PSAPBTABI STORAGE (INITIAL
    0000000016K NEXT 0000000040K MINEXTENTS 0000000001 MAXEXTENTS
    0000000300 PCTINCREASE 0000 ))
    DbSlExecute: rc = 99
    (SQL error 1630)
    error message returned by DbSl:
    ORA-01630: max # extents (300) reached in temp segment in tablespace PSAPBTABI

    There is space on PSAPBTABI tablespace and his Max extents is 505.
    So what is the problem?
    Please give me any idea

    Thanks
    Miki Barzilay
    rrr@superior.co.il

    My System: WinNT4.0/Oracle 8.0.6.1.0/SAP/R3 4.6C

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    either precreate the table with an larger initial extent or increase the default extent setting for your tablespace

    or take an exp with compress option, but then keep in mind that all tables need a continuous chunk of data in its tablespace

  3. #3
    Join Date
    Mar 2004
    Location
    Israel
    Posts
    2
    Originally posted by osy45
    either precreate the table with an larger initial extent or increase the default extent setting for your tablespace

    or take an exp with compress option, but then keep in mind that all tables need a continuous chunk of data in its tablespace
    Hi again and thanks for your help.
    As I said before I use Oracle Storage Manager and there I can see that the max extents for PSAPTABI is 505, and there is free space in thre tablespace.
    Any idea?

    Thanks
    Miki

  4. #4
    Join Date
    Jan 2004
    Posts
    370
    (IMP) ERROR: CREATE statement failed for object "S034"
    (CREATE UNIQUE INDEX "S034~0" ON "S034" ( "MANDT", "SSOUR",
    "VRSIO", "SPMON", "SPTAG", "SPWOC", "SPBUP", "WERKS",
    "LGORT", "MATNR", "CHARG" ) TABLESPACE PSAPBTABI STORAGE (INITIAL
    0000000016K NEXT 0000000040K MINEXTENTS 0000000001 MAXEXTENTS
    0000000300 PCTINCREASE 0000 ))
    It looks like it is the object that has reached its max extents - not the tablespace.
    In this case it is an index with initial 16K, next 40K, pctincrease 0, max extents 300.
    That works out about only 12Mb for 300 extents.

    You could import using indexfile and edit the storage parameters.
    Check out the details in the Utilities Manual.

    Or follow osy45's advice.

Posting Permissions

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