Re: Moving a table to another tablespace

From: Epicentre Team B Annecy <carmanet_at_epicentre.fr>
Date: Wed, 4 Sep 2002 18:33:12 +0200
Message-ID: <al5ci2$bdc$1@wanadoo.fr>

It seams to me that there is an easier way:

     ALTER TABLE table_name MOVE TABLESPACE new_tablespace_name;

 HTH.  Regards,

---

Celine Armanet - Division ORACLE
EPICENTRE - 529 Route des Vernes 74370 PRINGY Tel. : +33 04 50 09 7000
Fax : +33 04 50 66 92 19
E-Mail : carmanet_at_epicentre.fr

---

> "Lars Steinmetz" <no_spam_lsteinmetz_at_jakrause.com> a écrit dans le message
> news: 1031120115.839708_at_news.thyssen.com...
> > Hello NG,
> >
> > by a mistake a table with a long raw collumn was createt in the wrong
> > tablespace. How can I move this table (with content, of course) into the
> > correct tablespace?
> > I tried the alter table command but i always get the ORA-00997 Error.
 Any
> > ideas?
> >
> > Thanx for you help!
> >
> >
> > --
> > ==================
> > Lars Steinmetz
> > ==================
> >
> >
>
>
Received on Wed Sep 04 2002 - 11:33:12 CDT