ALTER DATABASE DATAFILE '/directory/filename' RESIZE xxx;Where 'xxx' is the number of bytes. This can also be expressed in megabytes by using "xxxM" instead.
A datafile does not belong to any schema. A datafile only belongs to a tablespace. A tablespace can contain many...
segments from many schemas. Please review the Oracle Concepts guide for more information.
Dig Deeper on Oracle database backup and recovery
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading