Re: ORA-01653: unable to extend table MILREPO.TS_CHANGES by 1598 in tablespace

ted nguyen wrote:
>
> Hi there,
>
> Does anybody know how I get this message and how to get rid of it:
>
> ORA-01653: unable to extend table MILREPO.TS_CHANGES by 1598 in tablespace
> REPOSIT_TABELSPACE
Well, the error equates to:
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.

You've hit the limit of your tablespaces free space. Either add another datafile, increase the size of the current datafile(s), or turn autoextend on.

Cheers,
GC Received on Wed Jun 21 2000 - 00:00:00 CDT