Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Moving objects between datafiles

Moving objects between datafiles

From: Michael Forester <michael.forester_at_ibm.net>
Date: Thu, 11 Feb 1999 08:58:02 GMT
Message-ID: <36c29a68.445580@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 - 02:58:02 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US