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

Thread: tablespace problem

  1. #1
    Join Date
    Nov 2000
    Posts
    440

    tablespace problem

    Is there other errors that could occurs other than
    ORA-01658: unable to create INITIAL extent for segment in tablespace TEST

    ORA-01659 unable to allocate MINEXTENTS beyond size in tablespace name

    if my tablespace is autoextend off with pctincrease not equal to 0, and table with next different from initial.

    I want to know the errors possible.

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    1. ORA-03232: unable to allocate an extent of %s blocks from
    tablespace %s

    2. and can lead to fragmentation :-)
    Last edited by adewri; 01-07-2003 at 12:38 PM.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  3. #3
    Join Date
    Jan 2002
    Location
    Canada
    Posts
    195
    What's the best solution in this case?

  4. #4
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Originally posted by dba1
    What's the best solution in this case?

    Why do you want to keep initial and next different and pctincrease other than 0 ?? give me three good reason... (3 my lucky number )

    Well the best solution would be to do table size estimation...
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  5. #5
    Join Date
    Nov 2000
    Posts
    440
    Im only asking error for a tablespace that is not well define and is missing space.

    The reason im asking, is i have a client that have bad tablespace configuration, and i need lots of explication of every change i make in his database, so when i make my report on why i created a locally managed tablespace, i could tell that is to resolve problem like ora-3232.

    Is there other error than ora-3232, ORA-01658, ORA-01659 ?

  6. #6
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    - ORA-01692 unable to extend lob segment string.string partition string by string in tablespace string
    - ORA-01652 unable to extend temp segment by string in tablespace string (for example when creating indexes or CTAS)
    - ORA-01653 unable to extend table string.string by string in tablespace string
    - ORA-01654 unable to extend index string.string by string in tablespace string
    - ORA-01655 unable to extend cluster string.string by string in tablespace string
    - ORA-01680 unable to extend LOB segment by string in tablespace string
    - ORA-01683 unable to extend index string.string partition string by string in tablespace string
    - ORA-01688 unable to extend table string.string partition string by string in tablespace string
    - ORA-01691 unable to extend lob segment string.string by string in tablespace string
    - ORA-01692 unable to extend lob segment string.string partition string by string in tablespace string
    - ORA-03233 unable to extend table string.string subpartition string by string in tablespace string
    - ORA-03234 unable to extend index string.string subpartition string by string in tablespace string
    - ORA-03237 Initial Extent of specified size cannot be allocated in tablespace (string)
    - ORA-03238 unable to extend LOB segment string.string subpartition string by string in tablespace string

    ... to name just a few...
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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