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!

alter database create datafile

694352Oct 17 2009 — edited Oct 18 2009

Hi

I notice that I can create datafile by issuing:

alter database create datafile '/oracle/users02.dbf';

and I dont need to specify size.
When should I use this method? and Why I cannot use this method on windows?

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 15 2009

Added on Oct 17 2009

#general-database-discussions

12 comments

2,906 views