Job Seekers   Employers
dbapool: Authors | Submissions | Contact Us
   Forgot password? | Sign up
  Home   Discussion Forum   Articles   Interview Questions   FAQs   Scripts   Rewards   Analyzer   White Papers   Blog   Certification   Downloads   Tools

Topic: Database Administration >> ORA-1654: unable to extend index XXXXXX by 128 in tablespace SYSAUX

Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property. You may review the entire Oracle Certification Program Candidate Agreement online Here.


 Title: ORA-1654: unable to extend index XXXXXX by 128 in tablespace SYSAUX
 MSB  Posted: Jun 03, 2009 08:30:09 AM

 Total Post: 30
 Joined: May, 2008

 I was receiving this alert from one of our client's PROD box.

ORA-1654: unable to extend index XXXXX by 128 in tablespace SYSAUX
so i connected and found:

FILE_NAME BYTES/(1024*1024) MAXBYTES/(1024*1024) AUT
---------------------------------------------------------------------- ----------------- -------------------- ---
/data/d03/oraprod/proddata/sysaux01.dbf 1999 2000 YES

SQL> select bytes/1024 from dba_free_space where TABLESPACE_NAME='SYSAUX';


So, I added one new datafile to the SYSAUX tablespace. Please let me know what i did is correct or not?


Posted: Jun 04, 2009 10:03:10 AM  

 Total Post: 22
 Joined: Nov, 2006


You need to check the index is related to the user_data or system data.
If it is for the user data, then you need to move the index to the user tablespace not the system tablespaces... Pl. check once whether the index is created on which tablespace and why...


Sai Kiran.

Posted: Jun 07, 2009 05:34:30 PM  

 Total Post: 615
 Joined: Jun, 2008

 Time Zone: EDT


Forum Rules & Description

Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user


Get FREE Magazines

Top 10 Forum User

  Murtuja Khokhar857
  Mohammed Taj746
  menon srivalsala kumar639
  positive fanatic615
  Gitesh Trivedi580
  Jayanta Sur480
  Vinoth Kumar436
  Vishant Sanghavi414
  Vigyan Kaushik403
  Gopu Gopi367

oracle Mag

  About Us Advertise Terms of Use Privacy Newsletters Contact Us    

Home   Discussion Forum   FAQs  Articles  Jobs   Newsletters  Directory  Downloads 

Our Premium Sponsor