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 -> Re: tablesspace copy and rename

Re: tablesspace copy and rename

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 9 Feb 2005 07:59:45 -0800
Message-ID: <1107964785.052725.158560@f14g2000cwb.googlegroups.com> 





Upgrade to version 10g then there is an ALTER TABLESPACE RENAME x TO x1
command.



Until then add a new tablespace and migrate the objects.



For changing the object owner try an exp followed by an imp using the
FROMUSER= TOUSER= parameters



HTH -- Mark D Powell --
Received on Wed Feb 09 2005 - 09:59:45 CST












Original text of this message













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