tablespace exceed
928660May 22 2012 — edited May 22 2012Hi,
Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production
PL/SQL Release 11.2.0.2.0 - Production
CORE 11.2.0.2.0 Production
TNS for 32-bit Windows: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production
My Scenario is like Below.
I am trying to insert bulk records into a table which gives me the exception "ORA-01654: unable to extend index" because of tablespace exceed.
Now i need to extend the tablespace and then insert again which will work.
As, We have data which needs to be inserted in our hand and we have the tablespace size.
so Before inserting into table, Is there anyway where we can find whether the data
can be fitted into the tablespace size with out getting ORA-01654: unable to extend index" error.
Hope the question is understandable. Any help would be appreciated.
Regards,