OraFAQ Forum: Server Administration » unable to extend index

Home » RDBMS Server » Server Administration » unable to extend index

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

unable to extend index [message #197297]

Tue, 10 October 2006 22:27

alamax
Messages: 8
Registered: October 2006
Location: KL

Junior Member

11-OCT-06 SP_LOT_CUSTOMER_SNAPSHOT
LOT_CUSTOMER_SNAPSHOT -1654
ORA-01654: unable to extend index ODS.PK_LOT_CUSTOMER_SNAPSHOT by 2 in tablespac
e SSINDEX

How solve the above isues?

Report message to a moderator

Re: unable to extend index [message #197314 is a reply to message #197297]

Tue, 10 October 2006 23:40

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

try to add datafile in index tbs.

Report message to a moderator

Re: unable to extend index [message #197335 is a reply to message #197314]

Wed, 11 October 2006 00:16

alamax
Messages: 8
Registered: October 2006
Location: KL

Junior Member

Will lose data when I add datafile in index tbs?

Report message to a moderator

Re: unable to extend index [message #197342 is a reply to message #197335]

Wed, 11 October 2006 00:35

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

No

Add datafile's mean increase space in index tbs.

Report message to a moderator

Re: unable to extend index [message #197345 is a reply to message #197342]

Wed, 11 October 2006 00:39

alamax
Messages: 8
Registered: October 2006
Location: KL

Junior Member

what is the command to add datafile?

Report message to a moderator

Re: unable to extend index [message #197377 is a reply to message #197345]

Wed, 11 October 2006 01:56

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

SQL> select file_name
2 from dba_data_files
3 where tablespace_name LIKE 'EX%';

FILE_NAME
--------------------------------------------------------------------------------

D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\EXAMPLE01.DBF

SQL> ALTER TABLESPACE "EXAMPLE"
2 ADD DATAFILE 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\EXAMPLE02.DBF' SIZE 10M

3 /

Tablespace altered.

Report message to a moderator

Re: unable to extend index [message #197886 is a reply to message #197377]

Fri, 13 October 2006 01:55

alamax
Messages: 8
Registered: October 2006
Location: KL

Junior Member

Finally, it was solved. Thanks.

Regards,

Alamax

Report message to a moderator

Re: unable to extend index [message #198038 is a reply to message #197886]

Sat, 14 October 2006 00:47

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

You're Welcome

Report message to a moderator

Re: unable to extend index [message #198329 is a reply to message #197297]

Mon, 16 October 2006 11:18

Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland

Senior Member

okay, even if its solved ..... adding datafile will not always work.
In Case of max-files you can reach a limit and sometimes a resize of datafiles brings a lot of mor benefit.
During the newer past it will be no big deal to work wiss less files but bigger ones, I guess .....

only a suggestion Cool

Report message to a moderator

Previous Topic:	will solaris 10 ZFS supports oracle 9i ora ...???
Next Topic:	2 Databases in 1 Unix box

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 12 23:25:29 CST 2024