Re: Importing in an other tablespace

From: Nuno Souto <nsouto_at_optushome.com.au.nospam>
Date: Thu, 24 Jan 2002 14:06:59 GMT
Message-ID: <3c5014ce.3020126@news-vip.optusnet.com.au>

Sybrand Bakker doodled thusly:

>because of the resource role your user has unlimited tablespace
>privilege and hence can create tables in any tablespace.

Oh crap! That one STILL there? That's been wrong for so long!

>You need to revoke the unlimited tablespace privilege
>and issue alter user <username> quota 0 on <orig_tablespace> quota
>unlimited on ts_entelec.
>Then your objects will end up in the new tablespace
>

Exactly. Pity Oracle hasn't fixed this yet...

Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam Received on Thu Jan 24 2002 - 08:06:59 CST