Re: Move a object to another data file of the same tablespace

Hi Kevin,

You cannot told oracle where it should put Your table, but You can allocate

extents where You want. There is a command

ALTER TABLE table ALLOCATE EXTENT ( DATAFILE 'filename' SIZE int [k|m] );

to allocate Extents for a table or index. If You create the table with minimal extent of two blocks, You can allocate further extents
with the obove command. But if the space of the table will become to small for the data
the database will allocate a next extent where the database want.

--
Best regards

Ralph Ganszky

• The above opinions are mine and do not represent any official
• standpoints of my employer or third-party organizations.

KC wrote:

> Dear all,
>
> Is it possible to move a table to a new datafile on the same tablespace
> after addition of new datafiles?
>
> Thanks,
> Kevin Cheung
Received on Mon Aug 30 1999 - 08:02:21 CDT