Re: occurs ORA-01031 when create view with DBA privilege

From: Wayne Smith <wts_at_maine.edu>
Date: Mon, 7 Oct 2013 11:28:49 -0400
Message-ID: <CAEgY-F7ZrsX=gPghe0BFJLdOB-np2i74Y94TQ3xZS9R7pxoTGg_at_mail.gmail.com>

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 - 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> 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
> See me: http://luolee.me [http://luolee.me]
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Oct 07 2013 - 17:28:49 CEST