Reply from satya_pal on Jan 3 at 2:16 PM Hello Fellas Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated. Regard Satyapal
| | | ---------------Original Message--------------- From: Michel BRANDELIK Sent: Tuesday, January 03, 2012 11:25 AM Subject: ORA-1654: unable to extend index SYS.I_HH_OBJ#_COL# by 62 in Tablespace System Check your tablespace and in particular your datafiles. 3 possibilities: - Quota exceeded --> increase quota of user where error popped up. - Datafile is filled up : - you can set datafile in autoextend mode OR add a new datafile to the tablespace - disk full: check for remaining space on another disk or add a new disk to your server and have it formatted the right way (filesystem) or have it recognized in ASM so as to add it to the group. | | Reply to this email to post your response. __.____._ | _.____.__ |
No comments:
Post a Comment