Home » SQL & PL/SQL » SQL & PL/SQL » Error while creating view in oracle 11g (oracle 11g)
Error while creating view in oracle 11g [message #426972] Tue, 20 October 2009 07:56 Go to next message
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 #426973 is a reply to message #426972] Tue, 20 October 2009 07:58 Go to previous messageGo to next message
Its_me_ved
Messages: 979
Registered: October 2009
Location: India
Senior Member
You need to have the CREATE VIEW privilege to create in your schema or to create in other schema CREATE ANY VIEW privilege required

Please go with the ORACLE DOCUMENTATION

[Updated on: Tue, 20 October 2009 07:59]

Report message to a moderator

Re: Error while creating view in oracle 11g [message #426975 is a reply to message #426972] Tue, 20 October 2009 07:58 Go to previous messageGo to next message
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.
Re: Error while creating view in oracle 11g [message #426979 is a reply to message #426972] Tue, 20 October 2009 08:09 Go to previous message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Read CREATE VIEW Prerequisites section and check your privileges.

Regards
Michel
Previous Topic: Using Case in Cursor
Next Topic: how to know no of users in sql prompt
Goto Forum:
  


Current Time: Tue Feb 18 01:51:00 CST 2025