Re: Change the table space name

From: Brian Peasland <oracle_dba_at_remove_spam.peasland.com>
Date: Tue, 22 Apr 2003 18:01:52 GMT
Message-ID: <3EA58390.72FBA636@remove_spam.peasland.com>

ALTER TABLE my_table MOVE TABLESPACE eco;

That should do the trick!
HTH,
Brian

priya wrote:
>
> Just started on with oracle 9i v 9.2.0.1
> I have created a table space named 'ECO' and created some tables under
> tablespace eco from the enterpris managers console front end.
>
> But some of the tables which were created has gone under the table pace
> 'SYSTEM'
>
> I would like to put all these tables also under the tablespace 'ECO'.
>
> Can some one give me a 'alter table ...' command to change the tablespace of
> these tables(Which has rows, primary and secondary keys under it ) which is
> under tablespace 'SYSTEM' to tablespace 'ECO'
>
> priya,
Received on Tue Apr 22 2003 - 13:01:52 CDT