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!

tablespace with multiple datafiles

723711Nov 20 2009 — edited Nov 20 2009

Hi All,

We have RHEL4 server with oracle 10gR2 in it.

can we create a tablespace with multiple datafiles?I mean while creating a tablespace itself we should be able to create two or more datafiles(shouldn't use ALTER tablespace command ).

If this is possible,please give me the SQL statement to do this(suppose I need to create a tablespace with two datafiles).

Thanks in advance.....

This post has been answered by Satish Kandi on Nov 20 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 18 2009

Added on Nov 20 2009

#general-database-discussions

8 comments

7,733 views