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: tables

Re: tables

From: Dr. Jan Dieckmann <JDieckmann_at_psi.de>
Date: Tue, 16 Mar 1999 16:46:46 +0100
Message-ID: <36EE7CE6.764B065F@psi.de>


Hi,

you can move an index with the command REBUILD but as far as I know you can not move the table.

regards Jan Dieckmann

naveen_arora_at_my-dejanews.com wrote:

> hi,
> i initially created tables from a user account with tablespace A
> i now have changed the default tablespace of user to B
> is there any way to move the extends and data from tablespace A to B ?
> thanks for any help
> naveen_at_cdotd.ernet.in
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Tue Mar 16 1999 - 09:46:46 CST

Original text of this message

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