Re: [Q] Moving tables between tablespaces?

Hi Chris,

        I don't think this will copy constraints or indexes but ...

		CREATE TABLE new_table AS
		SELECT * FROM old_table
		TABLESPACE new_tablespace;

Chris Muir wrote:
>
> Howdy.
>
> Is there a quick and simple way to move tables between tablespaces?
>
> If no what steps have to be done to achieve the same result?
>
> Any help appreciated in advance :)
>
> Regards,
> Chris
>
> cmuir_at_mitswa.com.au.no.spam
>
> If you would like to contact me via email, please remove the
> '.no.spam' from my email address.

--

Jerry Gitomer         	ICT Group
jgitomer_at_ictgroup.com	Langhorne PA
jgitomer_at_yahoo.com 	Opinions are mine not those of ICT Group