Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: imp issue...very confusing!

RE: imp issue...very confusing!

From: M Rafiq <rafiq9857_at_hotmail.com>
Date: Tue, 13 Jul 2004 11:39:32 -0400
Message-ID: <BAY2-F33mSvux4Jf7zy000e0f6c@hotmail.com>


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_at_TFMC.co.za>
Reply-To: oracle-l_at_freelists.org
To: <oracle-l_at_freelists.org>
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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Smith, Ron L. Sent: Tuesday, July 13, 2004 4:37 PM
To: oracle-l_at_freelists.org
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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
Received on Tue Jul 13 2004 - 10:36:31 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US