| ORA-01653 [message #93423] |
Thu, 23 December 2004 21:39  |
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  |
Frank Naude
Messages: 4581
Registered: April 1998
|
Senior Member |
|
|
Hi,
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.
Frank
|
|
|
|
| Re: ORA-01653 [message #93452 is a reply to message #93424] |
Fri, 28 January 2005 02:13 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
