Re: Cannot Insert ?

From: Stephen T. Parfitt <steve.parfitt_at_sympatico.ca>
Date: Tue, 18 Sep 2001 22:04:00 -0400
Message-ID: <3BA7FD10.FCA301C1@sympatico.ca>

Sean:

At the risk of stating the obvious:

"ORA-01654 unable to extend index string.string by string in tablespace string
Cause: Failed to allocate an extent for index segment in tablespace. Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated."

In other words, -um- you need to add more space to tablespace CUST1. Perhaps the index segment CUST1.SYS_C00664 is in the same tablespace as the data segment for CUST1 ... not so good, either!

Steve Parfitt

sean wrote:
>
> Hi All,
>
> Does anyone know what this mean ?
>
> [Oracle][ODBC Oracle Driver][Oracle OCI]ORA-01654: unable to extend index
> CUST1.SYS_C00664 by 210 in tablespace CUST1. (#1654)
>
> Appreciate anyone could help
> Sean
Received on Tue Sep 18 2001 - 21:04:00 CDT