Home » Developer & Programmer » Data Integration » Oracle Error : ORA 01653
Oracle Error : ORA 01653 [message #92887] Wed, 09 January 2002 21:31 Go to next message
PANKAJ
Messages: 24
Registered: June 2001
Junior Member
I am getting ORA-01653 error mesage while trying
to load data in one of the tables. The error
Message is
unable to extend table "ORADBA.SALE_TABLE by
512 in
tablespace DATA_TS".

I checked up in DBA_FREE_SPACE and it says
that alomst 300 MB space is free in DATA_TS. The
next extent size of the table being populted is just
4M. What could be causing this problem ?
Re: Oracle Error : ORA 01653 [message #92888 is a reply to message #92887] Thu, 10 January 2002 03:22 Go to previous messageGo to next message
Mike
Messages: 417
Registered: September 1998
Senior Member
So far I know an extent can not be fragmented. So if the biggest framgent of this 300MB of free space is smaller then 4MB it will not be able to create a new extent of 4MB.

You can use the command "ALTER TABLESPACE tablespace_name COALESCE" to coalesces all contiguous free extents into larger contiguous extents.

HTH
Re: Oracle Error : ORA 01653 [message #93356 is a reply to message #92887] Thu, 19 August 2004 23:54 Go to previous messageGo to next message
cybersoft
Messages: 1
Registered: August 2004
Junior Member
Pls inform me why the Error ORA 01653 is appearing ?
Re: Oracle Error : ORA 01653 [message #93394 is a reply to message #93356] Fri, 29 October 2004 10:03 Go to previous message
bl pizdec
Messages: 1
Registered: October 2004
Junior Member
xujnia eta wsio tavarishi!
Previous Topic: Looking for Datawarehousing , BI & OLAP Opportunity in Singapore
Next Topic: unusual error in warehouse builder
Goto Forum:
  


Current Time: Tue Aug 11 14:44:52 CDT 2020