Re: Tablespaces and Schema Objects
From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 18 Oct 2002 00:27:42 -0700
Message-ID: <a20d28ee.0210172327.378f3dd6_at_posting.google.com>
Date: 18 Oct 2002 00:27:42 -0700
Message-ID: <a20d28ee.0210172327.378f3dd6_at_posting.google.com>
"iulian" <iulian_ilies_at_hotmail.com> wrote in message news:<oRIr9.8844$mxk1.6401_at_news04.bloor.is.net.cable.rogers.com>...
> Hi list. Is there any way to move the objects in a schema from a tablespace
> to another? If yes could you tell me how?
> Thanks in advance.
>
> iulian
in 8i and higher
alter table move
and
alter index rebuild
In 9.i and before: export import
Hth
Sybrand Bakker
Senior Oracle DBA
Sybrand Received on Fri Oct 18 2002 - 09:27:42 CEST