Managing tablespaces - REUSE
696316Oct 10 2011 — edited Oct 10 2011Hello, my question is regarding the use of tablespace.
Currently I have a tablespace users with a single dbf file 13 GB.
Because of my limited hard drive, I had to limit it and put AUTOEXTESIBLE = NO.
Today he says it is full, and I have all tables truncated.
I would like to option to "reuse existing file."
but I've noticed that I have not found anything that allows me to do something like:
SQL: ALTER DATAFILE '/ u01/oracle/oradata/sicbi11g/users01.dbf' REUSE;
Everything I've read to use the new datafiles reuse is about, of course that I can not afford it because I can not create me a new datafile and do not have the space.
an idea that allows me to reuse the space of user tablespace when the tables are truncated and do not occupy that space?