Customer Support Language
 
HomeKnowledge BaseCampaignMaxHow to resize an Oracle tablespace
Information
Article ID31
Created On4/21/2003
Modified9/11/2008
Share With Others
How to resize an Oracle tablespace
1) Connect to database using SQL*Plus as the SYS or SYSTEM user.

2) Issue the following command:
alter database
datafile 'fullpath\filename' resize XXm;

Note: Substitute the the drive/path/filename within the single quotes and XX with the size in megabytes of the file.