Error while creating view in oracle 11g [message #426972] |
Tue, 20 October 2009 07:56  |
mandark
Messages: 23 Registered: October 2009
|
Junior Member |
|
|
Hi,
I am using oracle 11g as database. Whenever i am trying to create view in the following way:
create view v_man
as
select
.............
.............
from
table1
union
select
.............
.............
from
table2;
Error "ORA-01031: insufficient privileges" is being displayed.
Is this issue arising due to some new features in oracle 11g?
Because same query was working fine with oracle 8i database.
please Help me with this.
|
|
|
|
Re: Error while creating view in oracle 11g [message #426975 is a reply to message #426972] |
Tue, 20 October 2009 07:58   |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
You simply do not have the privileges plain and simple.
This database was not set up with the same privileges as your previous one. Either you do not have privileges on the tables in other schemas or you cannot create views. Talk to your DBA about setting up the same privileges.
|
|
|
|