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

From: Wayne Smith <>
Date: Mon, 7 Oct 2013 11:28:49 -0400
Message-ID: <>

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 - - UMS-ITS-ECAS

  • "All men die, few men ever truly live" -- Braveheart

On Mon, Oct 7, 2013 at 11:23 AM, <> 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: []
> --

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

Original text of this message