How to add a new data file to Oracle Tablespace using sqlplus

First login as the "oracle" user, and issue the command "sqlplus "/ as sysdba"" (I am assuming that you already have configured the 
PATH environment variable correctly) and then type the following:
alter tablespace tablespace_name 
add datafile '/oracle/data/file1.dbf' size 12G autoextend off;
The above command adds a data file named "file1.db" of size 12 GB to the "/oracle/data" path with the autoextend feature turned off

About SoCRaT

Systems Engineer, OSS & Linux Geek
This entry was posted in Uncategorized and tagged , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s