Database Administration (MOSC)

MOSC Banner

question about tables and datafile?

edited Oct 22, 2009 10:07PM in Database Administration (MOSC) 8 commentsAnswered
question about  tables and datafile?

 our customer have a question,

example, we have two table his0901 and his0902 (090* means table create date,each table about 1million row, ) in tablespace gw, in tablespace gw ,we have 24 datafile within the gw.

when we check dba_extents which datafile his0901 or hist0902 belong to, we find a thing ,

that  his0901  is allocated  in of all 24 datafile, and his0902 is also allocated  in of all 24 datafile.

i have a question , what is  table  allocate by datafile mechanism ?

in my opinion, when insert data in table, oracle will  random allocate a datafile to the table, and then all newly insert data to table will in

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center