Home » RDBMS Server » Server Administration » unable to extend index
unable to extend index [message #197297] Tue, 10 October 2006 22:27 Go to next message
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?
Re: unable to extend index [message #197314 is a reply to message #197297] Tue, 10 October 2006 23:40 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member



try to add datafile in index tbs.
Re: unable to extend index [message #197335 is a reply to message #197314] Wed, 11 October 2006 00:16 Go to previous messageGo to next message
alamax
Messages: 8
Registered: October 2006
Location: KL
Junior Member
Will lose data when I add datafile in index tbs?
Re: unable to extend index [message #197342 is a reply to message #197335] Wed, 11 October 2006 00:35 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

No

Add datafile's mean increase space in index tbs.
Re: unable to extend index [message #197345 is a reply to message #197342] Wed, 11 October 2006 00:39 Go to previous messageGo to next message
alamax
Messages: 8
Registered: October 2006
Location: KL
Junior Member
what is the command to add datafile?
Re: unable to extend index [message #197377 is a reply to message #197345] Wed, 11 October 2006 01:56 Go to previous messageGo to next message
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.
Re: unable to extend index [message #197886 is a reply to message #197377] Fri, 13 October 2006 01:55 Go to previous messageGo to next message
alamax
Messages: 8
Registered: October 2006
Location: KL
Junior Member
Finally, it was solved. Thanks.

Regards,

Alamax
Re: unable to extend index [message #198038 is a reply to message #197886] Sat, 14 October 2006 00:47 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

You're Welcome
Re: unable to extend index [message #198329 is a reply to message #197297] Mon, 16 October 2006 11:18 Go to previous message
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
Previous Topic: will solaris 10 ZFS supports oracle 9i ora ...???
Next Topic: 2 Databases in 1 Unix box
Goto Forum:
  


Current Time: Sat Dec 10 05:02:44 CST 2016

Total time taken to generate the page: 0.13594 seconds