Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Add datafile to another disk

NikolineSep 30 2009 — edited Oct 1 2009

My D disk where are my data files of my K001 tablespace is 85% full and I want to add new datafile to another disk G. Can I do this only with this:

ALTER TABLESPACE "K001" ADD DATAFILE 'G:\ORACLEDATA\K03.DBF' SIZE 10000M AUTOEXTEND ON NEXT 256M MAXSIZE 32676M

Or I need to do another things?

I need to create directory: create directory ORACLEDATA as ‘'G:\ORACLEDATA’ , or not?

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 29 2009

Added on Sep 30 2009

#general-database-discussions

7 comments

1,420 views