Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: imp issue...very confusing!
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
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlReceived on Tue Jul 13 2004 - 09:52:22 CDT
-----------------------------------------------------------------
![]() |
![]() |