General:10g Soft limit - MAXDATAFILES, MALOGFILES, MAXINSTANCES, MAXLOGMEMBERS

-- no need to re-create controlfile
http://laurentschneider.blogspot.com/2006/01/change-maxdatafiles-malogfiles.html

Capacity: 10g: drop datafile

--
-- Drop empty datafile (not one only one and not first in tablespace)
--
alter tablespace ft add datafile 'C:\PROJECT\OCP\FT.DBF1' size 1m;
Tablespace altered.
alter tablespace ft drop datafile 'C:\PROJECT\OCP\FT.DBF1';
Tablespace altered
--
-- but if datafile not empty
--
alter database datafile 'C:\PROJECT\OCP\FT.DBF1' resize 10m;
Database altered.
alter table test.t_all allocate extent (size 1k datafile 'C:\PROJECT\OCP\FT.DBF1');
Table altered.
--
alter tablespace ft drop datafile 'C:\PROJECT\OCP\FT.DBF1';
alter tablespace ft drop datafile 'C:\PROJECT\OCP\FT.DBF1'
*
ERROR at line 1:
ORA-03262: the file is non-empty
--
-- and for first file
--
alter tablespace ft drop datafile 'C:\PROJECT\OCP\FT.DBF';
alter tablespace ft drop datafile 'C:\PROJECT\OCP\FT.DBF'
*
ERROR at line 1:
ORA-03263: cannot drop the first file of tablespace FT

Capacity: 10g Segment growth prediction

select * from
table(dbms_space.OBJECT_GROWTH_TREND
('TEST','TEST','TABLE'));

--
-- set serveroutput off;
-- if - EXCEPTION in chrow processing - code: -14551 msg: ORA-14551: cannot perform a
-- DML operation inside a query
--