OraFAQ Forum: Server Utilities » importing of views

Home » RDBMS Server » Server Utilities » importing of views - reg

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

importing of views - reg [message #72887]

Tue, 02 December 2003 22:54

Senthilkumar P.B.
Messages: 5
Registered: December 2003

Junior Member

Hello,

We have different users in our database named 'SASL' like 'SASL','SASL01' etc. The view "TAB" in the user 'SASL' has been dropped wrongly. How can I restore the view from backup ? or How can I create the view in the particular user?

Regards

Senthil.

Report message to a moderator

Re: importing of views - reg [message #72899 is a reply to message #72887]

Fri, 05 December 2003 04:38

naveen dutt
Messages: 8
Registered: December 2003

Junior Member

Hi,
create view SASL.tab
as
select <name of column you want in tab view>
from dba_tables
where owner='SASL'

Report message to a moderator

Re: importing of views - reg [message #72908 is a reply to message #72899]

Sat, 06 December 2003 02:45

Senthilkumar P.B.
Messages: 5
Registered: December 2003

Junior Member

Hi

Thank you for reply.

When i run the query in SASL user it shows the following error

"ora-01933 cannor create a stored object using privileges from a role".

If i run the query in SYS user it shows the error

ora-00942 table or view does not exist.

but the portion from select is working.

Report message to a moderator

Previous Topic:	Create log file of oracle export on sco unix
Next Topic:	import errors

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 01 07:03:57 CDT 2024