Re: Moving objects between datafiles

Hi,

Jean-Michel Coulon wrote:
>
> If I remember...
>

Your memory does not serve you well...!

> You can't drop a datafile !

Of course you can drop a datafile, but you should take all the data out of it first.

> You can't know in which datafile of your tablespace your object is !

Of course you can. Try "select file_id from sys.dba_extents where segment_name=;" I think you meant you can't tell oracle which file to put the extents in within a tablespace  

> I think you have to export the objects in this tablespace, drop this > one, create again with correct datafile(s) and then import the
> objects. Or may be move objects by 'create ... as select...' in
> an other tablespace instead of export/import.

That would be fine.

> Michael Forester wrote in message <36c29a68.445580_at_news2.ibm.net>...
> >
> >I need to consolidate some tablespaces and would like to move all the
> >objects in one datafile to another datafile, then drop the empty
> >datafile. Is this possible? I'm trying to avoid a complete
> >re-engineering of the database.
> >
> >Thanks,
> >
> >Michael Forester
> >DBA/MCSE
> >IT Legal Systems
> >PricewaterhouseCoopers
> >
> >michael.forester_at_us.pwcglobal.com
> >michael.forester_at_ibm.net
> >
Received on Fri Feb 12 1999 - 00:28:29 CST