autoextend tablespace into new file
revo1059Aug 27 2009 — edited Aug 28 2009I have a small program that captures images and from time to time the users fill up the image tablespace and I have to manually create a new tablespace. The way I have it setup is that my image tablespace is set to 2GB (the name of the datafile is /opt/oracle/oradata/image1.dbf). How can I (or CAN I) have Oracle (or my program) automatically create another datafile when space is getting low on the 1st. I thought about creating a bigger file to start with, but I don't want to chew up that much space unless it's needed (some clients need it, some don't).
Edited by: user461089 on Aug 27, 2009 11:52 AM