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
Messages: 20
Registered: April 2007
Location: Mumbai
Junior Member
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: 65137
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).

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

Current Time: Thu Aug 17 12:16:40 CDT 2017

Total time taken to generate the page: 0.11635 seconds