Re: Changing tablespace of an user

No easy way I know of

So yes you do need to Exp and Imp

Regards

--
Kevin A Lewis (BOCM PAULS LTD - Animal Feed Manufacturer - Ipswich England)

                        <KevinALewis_at_HotMail.com>

The views expressed herein by the author of this document are not necessarily those of BOCM PAULS Ltd. Martin Renner <M.Renner_at_tiscon.de> wrote in message news:7i0ntq$lhj$1_at_nnrp1.deja.com...
> Hello.
>
> I created an Oracle-user and assigned him to a wrong standard- and
> temporary-tablespace. Unfortunately, this user already created some
> tables (about 15) and filled them with some MB of data.
>
> Is there an easy way to assign this user to a different (and
> correct) tablespace without losing his data? Do I have to make an export
> of this data, change the tablespace and then import everything in the
> new table???
>
> Thanks in advance,
> Martin
>
>
> --== Sent via Deja.com http://www.deja.com/ ==--
> ---Share what you know. Learn what you don't.---
Received on Thu May 20 1999 - 06:37:31 CDT