Home » SQL & PL/SQL » SQL & PL/SQL » Materialized View (Materialized View)
Materialized View [message #275064] Thu, 18 October 2007 03:55 Go to next message
ashishmcajec
Messages: 20
Registered: April 2007
Location: Mumbai
Junior Member
hi,
friends i am creating Materialized View can you tell we which all grant are given. Also when i am building a materialized view i got the oracle error sequence does not exists. ORA-02289
Re: Materialized View [message #275077 is a reply to message #275064] Thu, 18 October 2007 04:13 Go to previous message
Michel Cadot
Messages: 64133
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
With what you posted, the only thing we can say is:
ORA-02289: sequence does not exist
 *Cause: The specified sequence does not exist, or the user does
           not have the required privilege to perform this operation.
 *Action: Make sure the sequence name is correct, and that you have
            the right to perform the desired operation on this sequence.

And this not a Performance question.

Please read and follow OraFAQ Forum Guide
Please always post your Oracle version (4 decimals).

Regards
Michel
Previous Topic: errors in a package
Next Topic: Group function
Goto Forum:
  


Current Time: Thu Dec 08 04:25:47 CST 2016

Total time taken to generate the page: 0.18896 seconds