Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

adding datafile to a tablespace

Status
Not open for further replies.

beksalur

Technical User
Jan 2, 2003
74
TR
i want to add a raw datafile to a tablespace in Oracle 9i.
can i do it when the database is online?

Regards.
 
Yes of course, that is the whole idea. Just do alter tablespace <tablespace_name> add datafile '<datafile_name>' ...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top