Need help with ORA-1654 [message #460770] |
Mon, 14 June 2010 11:46 |
ultgnp
Messages: 106 Registered: May 2010 Location: Germany
|
Senior Member |
|
|
Hi,
I am using 8.1.7. I received an error "ORA-1654: Unable to extend index "ULTGNP.PK_A_PT_ORDER_MASTER" by 25435 in tablespace "ULTGNP"
The script for the above index is:
CREATE UNIQUE INDEX ULTGNP.PK_A_PT_ORDER_MASTER ON ULTGNP.A_PT_ORDER_MASTER
(BUS_UNIT, REG_NO, ORDER_NO)
LOGGING
TABLESPACE ULTGNP
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 49816K
NEXT 101740K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
FREELISTS 1
FREELIST GROUPS 1
BUFFER_POOL DEFAULT
)
NOPARALLEL;
There is about 7gb space left in the tablespace. Please let me know if you need more information to solve the problem.
I have created a new datafile, and it seems to solve the problem temporarily. Please guide me.
Best Regards,
|
|
|
|
|
|
|
|
Re: Need help with ORA-1654 [message #460908 is a reply to message #460770] |
Tue, 15 June 2010 08:08 |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
ultgnp wrote on Mon, 14 June 2010 12:46
There is about 7gb space left in the tablespace. Please let me know if you need more information to solve the problem.
I have created a new datafile, and it seems to solve the problem temporarily. Please guide me.
Your index requires 100Mb of contiguous space for each extent after the first one. You didn't say how large the index is going to be. You do not have enough 100Mb chunks of free space in your tablespace.
|
|
|