APEX

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!

How to deal with tablespaces in Oracle XE (10g)

HighTen76May 1 2012 — edited May 2 2012

Hi,

First want to say I'm not a DBA so my knowledge on how to work with tablespaces is very limited. I built an application in Apex 3.2.1 on Oracle XE 10g and today for the first time I received this error when trying to save information to the database:

ORA-01691: Unable to extend lob segment by .... for table space FLOW....

What is the best way to deal with this? For now, after doing some google searching, I set my tablespace to AUTOEXTEND (it had reached about 500MB which was its max size). Is this the correct way to deal with this situation? Or should I create a new tablespace? I've never changed any of the default settings/tablespaces that came with the Apex/Oracle XE installation.

Any advice would be greatly appreciated....

Thanks,
Francois

Edited by: HighTen76 on May 1, 2012 2:02 PM

Locked Post

New comments cannot be posted to this locked post.

Locked on May 30 2012

Added on May 1 2012

#apex-discussions

4 comments

641 views