Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: 'create tablespace' question
On 9 Apr 2005 10:34:44 -0700, "mea0730" <mea0730-google_at_yahoo.com>
wrote:
>If I create a tablespace with the following syntax and run an import,
>all the data goes into the last data file. It's not spread across the
>datafiles.
Well that is really not surprising, isn't it. Normally a tablespace is just filled up, and a second datafile is only being used after it is added. You seem to expect there is a sort of 'software-striping' algorithm when you create multiple datafiles: there isn't. Apart from that, as you are creating all those datafiles on one filesystem, and you seem to be monitoring how far each datafile is filled up: do you want an administration nightmare, or do you just have plenty of time to administer this database, or do you just want make sure you don't have to ever add space again.
-- Sybrand Bakker, Senior Oracle DBAReceived on Sat Apr 09 2005 - 13:26:00 CDT