OraFAQ Forum: SQL & PL/SQL » How do I create table by select data from another table which has an object assigned to it?

Home » SQL & PL/SQL » SQL & PL/SQL » How do I create table by select data from another table which has an object assigned to it?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How do I create table by select data from another table which has an object assigned to it? [message #20979]

Thu, 04 July 2002 03:16

Somdeb Majumdar
Messages: 1
Registered: July 2002

Junior Member

I have a table A.
The columns are:
c1 number(2)
c2 varchar2(90)
c3 my_object

where my_object is my defined object.

I want to create table B as select * from tabel A.
It is giving an error inconsistent datatypes as I am creating it in another User.
How to proceed?

Please Help
Thanks

Report message to a moderator

Re: How do I create table by select data from another table which has an object assigned to it? [message #20984 is a reply to message #20979]

Thu, 04 July 2002 07:04

vipin
Messages: 40
Registered: May 2002

Member

Hi,
Try to give a grant all on the object to the other user.

vipin

Report message to a moderator

Previous Topic:	Re: How can I order by the PL/SQL table?
Next Topic:	Keyword COMPUTE : how to remove -------- and ****** lines from my report????

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 11:46:58 CDT 2024