✍ Kashif M
Trends

Thursday, 25 July 2013


Increase the Tablespace Size in oracle


By on July 25, 2013



Increasing the Existing Datafile

SQL> ALTER DATABASE DATAFILE 'E:\ORION_DBF\KK1.DBF' RESIZE 100M;

Database altered.

SQL>

• Appending additional DATA file to the Tablespace

SQL> alter tablespace kk add datafile 'e:\orion_dbf\kk2.dbf' size 20m;

Tablespace altered.

Kashif
mkashu: Increase the Tablespace Size in oracle
Review : Kashif | Kashif
Update: July 25, 2013 | Rating: 4.5

Comment for "Increase the Tablespace Size in oracle"

0 comments

Post a Comment

Blog Archive