-
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.
-
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."
-
What's the best solution in this case?
-
-
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 ?
-
- 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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|