Portal
Language
 
Home>Knowledge Base>Root>CampaignMax>How to resize an Oracle tablespace
User Login
Username
Password
 
 Login
Information
Article ID31
Created On4/21/2003
Modified9/11/2008

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.