RE: imp issue...very confusing!
- From: "M Rafiq" <rafiq9857@xxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 13 Jul 2004 11:39:32 -0400
If any user is given 'resource' role or that user already have this role
then by default it get 'unlimited tablespace'. Revoke this from user and
assign it quota on specific tablespace.
Regards
Rafiq
From: "Denham Eva" <EVAD@xxxxxxxxxx>
Reply-To: oracle-l@xxxxxxxxxxxxx
To: <oracle-l@xxxxxxxxxxxxx>
Subject: RE: imp issue...very confusing!
Date: Tue, 13 Jul 2004 16:57:02 +0200
Thanks Ron for the input, I am going to investigate this issue.
Regards
Denham
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Smith, Ron L.
Sent: Tuesday, July 13, 2004 4:37 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: imp issue...very confusing!
I found that when I give a user (touser) unlimited tablespace on his/her
own tablespace, for some reason the user also gets granted unlimited
tablespace on all tablespaces. When that happens, the fromuser touser
option results in all the objects getting put back into the fromuser
tablespace. When I revoke unlimited tablespace, the import works fine.
Ron Smith
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
_________________________________________________________________
MSN Toolbar provides one-click access to Hotmail from any Web page ? FREE
download! http://toolbar.msn.click-url.com/go/onm00200413ave/direct/01/
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
