Home » SQL & PL/SQL » SQL & PL/SQL » Creation of MV using dblink (oracle 10g)
Creation of MV using dblink [message #388348] Tue, 24 February 2009 07:09 Go to next message
pointers
Messages: 410
Registered: May 2008
Senior Member
Hi,

I wanted to create a materialized view using dblink..

I followed the following steps.

1. create db link
2. materialized view using db link
I got error at step 2 saying privileges are not there for creation of materilized view.

Then I changed the steps as follows..

1. create db link
2. Create a simple view using DB link which uses the same defination to create the Materialized View(I gieven the select query in view defination)
3. Create a Materilized View using the view.

It worked fine this time.

Can you please tell me why was it working in case 2.

Regards,
Pointers.

[Updated on: Tue, 24 February 2009 07:23] by Moderator

Report message to a moderator

Re: Creation of MV using dblink [message #388349 is a reply to message #388348] Tue, 24 February 2009 07:15 Go to previous messageGo to next message
MarcS
Messages: 312
Registered: March 2007
Location: Antwerp
Senior Member
Would it be possible to post the exact error code and message?
Now we can only guess Wink
Re: Creation of MV using dblink [message #388383 is a reply to message #388348] Tue, 24 February 2009 09:05 Go to previous messageGo to next message
pointers
Messages: 410
Registered: May 2008
Senior Member
I am really sorry..It was a production issue. I dont have access to check it now..any guesses with your experience (I dont have Razz )....

Regards,
Pointers.
Re: Creation of MV using dblink [message #388385 is a reply to message #388348] Tue, 24 February 2009 09:09 Go to previous message
pointers
Messages: 410
Registered: May 2008
Senior Member
But I do remember it is related to privileges 'No privileges'...
Previous Topic: SQL Question
Next Topic: Update and select - need help
Goto Forum:
  


Current Time: Wed Dec 07 06:41:40 CST 2016

Total time taken to generate the page: 0.11617 seconds