Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: exporting from Oracle8 using Exp80
First I would like to thank you for replying to the group and my email. It
makes it easy to know when there is new replies.
You are completely correct about the role of the GET user. He has Unlimited Tablespace granted to him.
Now when creating a User from scratch, can you grant the unlimited tablespace on just one tablespace? I always thought that unlimited tablespace was just for the User's default tablespace.
John Seitz
Protel, Inc.
Sybrand Bakker <postmaster_at_sybrandb.demon.nl> wrote in message
news:934997294.22646.0.pluto.d4ee154e_at_news.demon.nl...
> Hi John,
> This is quite simple.
> 1 The tablespace clause is in the export file
> 2 The user GET has received the resource role and this means he has
> unlimited tablespace privilege:
> he can create tables in any tablespace, without quota
> What you need to do is to revoke the resource role, make sure the correct
> tablespace is the default tablespace
> and GET has unlimited quota on that tablespace only.
> This can be accomplished by
> alter user GET quota unlimited on <tablespace>
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
Received on Wed Aug 18 1999 - 15:17:53 CDT