Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

tablespace exceed

928660May 22 2012 — edited May 22 2012
Hi,


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,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 19 2012
Added on May 22 2012
17 comments
956 views