DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: Tablespace has 3 datafiles - import uses which?

Threaded View

  1. 04-16-2004, 06:18 AM #7
    DaPi's Avatar
    DaPi
    DaPi is offline Old Cranky Philosopher
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Originally posted by julian
    Oracle tries to spread the data equally among the files. Round-robin fashion.
    From what I observed with a MOVE, it would seem that this is "simplistic" in its implementation. It looked as if, for each table, Oracle always started with the same file - so that if all your tables had only one extent, they would all be in the first file (not sure how "first" is defined).
    Last edited by DaPi; 04-16-2004 at 06:23 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width