Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Moving objects between datafiles
If I remember...
You can't drop a datafile !
You can't know in which datafile of your tablespace your object is !
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.
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 Thu Feb 11 1999 - 15:22:52 CST