tablespace problem

[steeve123]

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.

[adewri]

1. ORA-03232: unable to allocate an extent of %s blocks from
tablespace %s

2. and can lead to fragmentation :-)

[dba1]

What's the best solution in this case?

[adewri]

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 :D )

Well the best solution would be to do table size estimation...

[steeve123]

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 ?

[jmodic]

- 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...