Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: alter table move... What Oracle version?
This is not only for IOT's. See below:
SQL> CREATE TABLE test_move (
2 id NUMBER,
3 name VARCHAR2(20))
4 TABLESPACE users;
Table created.
SQL> select table_name,tablespace_name from user_tables 2 where table_name ='TEST_MOVE';
TABLE_NAME TABLESPACE_NAME
-------------------- ------------------------------ TEST_MOVE USERS
SQL> alter table test_move move tablespace tools;
Table altered.
SQL> select table_name,tablespace_name from user_tables 2 where table_name ='TEST_MOVE';
TABLE_NAME TABLESPACE_NAME
-------------------- ------------------------------ TEST_MOVE TOOLS
See, the table moved!
HTH,
Brian
Falco Paul wrote:
>
> I believe this only works for IOT's.
> Heap tables don't move at all with this command (at least not in 8.1.6,
> didn't test 8.1.7 yet).
> I heard Oracle 9 should support a 'true'ALTER TABLE REBUILD (storage specs)
> command.
>
> Falco
>
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> schreef in bericht
> news:t6c6pddh43757f_at_beta-news.demon.nl...
> > 8.1 aka 8i only.
> >
> > Hth,
> >
> > Sybrand Bakker, Oracle DBA
> >
> > "Syltrem" <syltrem_at_videotron.ca> wrote in message
> > news:Wmo96.7224$hP5.247921_at_wagner.videotron.net...
> > > I think there is a new command to move tables between tablespaces in
Oracle
> > > 8, but is it available on 805 or only starting with 810?
> > >
> > > And would this be the correct syntax?
> > > ALTER TABLE XX MOVE TABLESPACE ZZ STORAGE (INITIAL nn);
> > >
> > > Thanks!
> > > --
> > > Syltrem
> > > http://pages.infinit.net/syltrem (OpenVMS Web Site)
> > >
> > >
> > >
> > >
> > >
> > >
> >
> >
-- ======================================== Brian Peasland Raytheons Systems at USGS EROS Data Center These opinions are my own and do not necessarily reflect the opinions of my company! ========================================Received on Thu Jan 18 2001 - 08:17:38 CST