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!

How does oracle write to datafiles in a tablespace?

627138Sep 5 2010 — edited Sep 8 2010

hi all

Suppose I have a tablespace consisting of two datafiles. When I need to wirte data onto it，how does ORACLE
write ? Does it initially write to the first datafile and then write to the second datafile when the first datafile getting full or write to two datafiles in an random manner?

Thanks for your reply.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 6 2010

Added on Sep 5 2010

#general-database-discussions

25 comments

3,713 views