Re: duplicate user

From: Marc Blum <marc_at_marcblum.de>
Date: Fri, 19 Apr 2002 19:19:26 GMT
Message-ID: <3cc06d66.4016535@news.online.de>

On Thu, 18 Apr 2002 21:48:24 +0200, "Titi" <thierry.constant2_at_wanadoo.fr> wrote:

>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

Which user performs the import? System? Which system privileges/roles are granted to userB? What is the default tablespace of userB?

regards
Marc Blum
mailto:marc_at_marcblum.de
http://www.marcblum.de Received on Fri Apr 19 2002 - 14:19:26 CDT