Home » Developer & Programmer » Data Integration » ORA-01653
ORA-01653 [message #93423] Thu, 23 December 2004 21:39 Go to next message
Cyril Sluchanko
Messages: 1
Registered: December 2004
Junior Member
I have a database which keeps some periodical data. After reaching defined time treashold old data is deleting by job or by administrator.
By now, though I have free space in datafiles after deletion of old data, I'm getting ORA01653 Unable to extend the table.
How can I resolve this issue? I cannot add more datafiles as I have no free space on disks and it is wrong way. I need to insert data instead of deleted ones.

Best regards!
Re: ORA-01653 [message #93424 is a reply to message #93423] Tue, 28 December 2004 02:28 Go to previous messageGo to next message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member

Try to "reorg" the table by doing an export, drop, and import. If that doesn't help, but more space.

$ oerr ora 01653
01653, 00000, "unable to extend table %s.%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.

Best regards.

Re: ORA-01653 [message #93452 is a reply to message #93424] Fri, 28 January 2005 02:13 Go to previous message
Sandeep Roy
Messages: 1
Registered: January 2005
Junior Member
Yes, to solve this problem we have to add a extra datafile or resize the datafile for particular tablespace.
I don't find any other alternative.....
If any one knows plz mail me
Previous Topic: Create FACT and DIMENSION table commands
Next Topic: Documentation for DW
Goto Forum:

Current Time: Sat May 25 04:18:56 CDT 2024