Re: occurs ORA-01031 when create view with DBA privilege
Date: Mon, 07 Oct 2013 23:35:51 +0800
Message-ID: <2695ba58-631e-4c35-b09e-919ace5f319e_at_getmailbird.com>
Wayne,
thanks to you for reply.
There exist no db link.
For instance, I create a view "create view test as select 1 from dual", it says ORA-01031, but when I execute "select 1 from dual", it displays OK. It's just an example, attention.
All the best,
LuoLee
Mobile: +86 15651803071
See me: http://luolee.me [http://luolee.me]
On 2013/10/7 23:28:49, Wayne Smith <wts_at_maine.edu> wrote:
Perhaps a db liink is involved and the domain of the new database is different from the old (making the db link fail)?
Cheers, Wayne
Wayne T Smith - wts_at_maine.edu [mailto:wts_at_maine.edu] - UMS-ITS-ECAS
- "All men die, few men ever truly live" -- Braveheart
On Mon, Oct 7, 2013 at 11:23 AM, LuoLee.me <luolee.me_at_gmail.com [mailto:luolee.me_at_gmail.com]> wrote:
Dear lists,
I migrate a database using expdp/impdp and exp/imp today.
When I export a database using expdp, there isn't any errors.
But there are some views, procedure and others error, so I compile
it manually.
When I re-compile some view, it says ORA-01031, but I have grant dba to
the specail user. When I see the errors, I try to re-compile it again and again.
I grant select on the the special table to the very user, it didn't take. If I just
select the special view on the fly other than create it, it will list ok.
I didn't understand why it occur ORA-01031 here ?
Thanks all in advance!
All the best,
LuoLee
Mobile: +86 15651803071 [tel:%2B86%2015651803071]
See me: http://luolee.me [http://luolee.me] [http://luolee.me [http://luolee.me]]
--
http://www.freelists.org/webpage/oracle-l [http://www.freelists.org/webpage/oracle-l]
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Oct 07 2013 - 17:35:51 CEST