Home » SQL & PL/SQL » SQL & PL/SQL » create type
create type [message #250709] Wed, 11 July 2007 00:53 Go to next message
subhadip.chanda
Messages: 64
Registered: May 2007
Member
when i am going to use the query

CREATE TYPE Project1 AS OBJECT (
project_no NUMBER(2),
title VARCHAR2(35),
cost NUMBER(7,2));

it raise error massage ORA-01031-insufficient priviledge. Then what should i do?

I am using --
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production versions.

[Updated on: Wed, 11 July 2007 00:55]

Report message to a moderator

Re: create type [message #250714 is a reply to message #250709] Wed, 11 July 2007 01:01 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
subhadip.chanda wrote
Then what should I do


Read the documentation. Google for the error message.
Re: create type [message #250716 is a reply to message #250709] Wed, 11 July 2007 01:04 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Get the requested privilege.

Regards
Michel
Re: create type [message #250718 is a reply to message #250716] Wed, 11 July 2007 01:13 Go to previous messageGo to next message
subhadip.chanda
Messages: 64
Registered: May 2007
Member
how can i get that priviledge?
Re: create type [message #250719 is a reply to message #250718] Wed, 11 July 2007 01:20 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Ask your DBA to grant it to you.

Regards
Michem
Previous Topic: max dates
Next Topic: converting FOR to FORALL
Goto Forum:
  


Current Time: Sat Dec 10 04:49:18 CST 2016

Total time taken to generate the page: 0.25589 seconds