Database administrators can now resize Oracle datafiles at the tablespace level using the BIGFILE tablespace feature in 10g. Bob Watkins explains how in this Oracle tip. Oracle 10g introduced a new ...
create smallfile tablespace TESTDATA datafile 'testdata.dbf' SIZE 300M LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO; But it fails with ORA-1119 in the log: ...