sventhan
asked on
ORA-01688: unable to extend table SCHEMA.TABLE_NAME partition P20091124 by 4096 in tablespace ABC_TBLSPACE
Experts -
I'm getting the following error.
ORA-01688: unable to extend table SCHEMA.TABLE_NAME partition P20091124 by 4096 in tablespace ABC_TBLSPACE
Thanks for your help.
-sve.
unable-to-extent.txt
I'm getting the following error.
ORA-01688: unable to extend table SCHEMA.TABLE_NAME partition P20091124 by 4096 in tablespace ABC_TBLSPACE
Thanks for your help.
-sve.
unable-to-extent.txt
ASKER
Now, this error pops up. When I'm trying to add datafile to the tblspace.
ORA-15041: diskgroup space exhausted
ORA-15041: diskgroup space exhausted
is the disc full on the server ?
ASKER
@ Greert -
Its almost. But I still see around 200GB free space on the disk.
Its almost. But I still see around 200GB free space on the disk.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Geert. The disk was full and i'm cleaning up now.
ASKER
Error: ORA 1688
Text: unable to extend table %s.%s partition %s by %s in tablespace %s
--------------------------
Cause: Failed to allocate an extent for table segment in tablespace.
Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files
to the tablespace indicated.
This is ASM managed datafiles. How can I add more data files into this tablespace?