Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: duplicate user
"Titi" <thierry.constant2_at_wanadoo.fr> a écrit dans le message de news:
3cbf22d1$0$15183$626a54ce_at_news.free.fr...
> Hi,
>
> I have to duplicate a user (schema) in an other tablespace:
> I export the userA
> I put quota 0 to tablespaceA for userB
> but when I import the userA to userB, table go into tablespaceB
> I have errors about constraints ...Why ?
>
> Is there a better way to do that ??
>
Sorry, the version is 8.1.7
Received on Thu Apr 18 2002 - 14:52:02 CDT