Materialized View

[jestrada101]

I create my MV on 9.2.0.4 with no problems. When attempting to do the same on 9.2.0.5 I get the following error. Is the SEQUENCE option not in 9.2.0.5?

Thanks for any guidance!

.
.
With SEQUENCE, rowid, Primary Key -- accounts for pk columns
*
ERROR at line 22:
ORA-00922: missing or invalid option

 

[SantaMufasa]

J,

To troubleshoot your problem, I suggest your building the simplest MV as possible (using a dummy table with as few columns as will exercise your syntax, including "...SEQUENCE..."). Get this super-simple MV working on your 9.2.0.4 platform, then try in on the 9.2.0.5. If it blows up on 9.2.0.5, then post your dummy "CREATE TABLE...", a couple of INSERTs to the DUMMY table, and your MV CREATE here, and I'll try your code between my 9.2.0.4 and 9.2.0.5 installations.

How does that offer/suggestion sound?

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

@ 17:00 (19Nov04) UTC (aka "GMT" and "Zulu"),
@ 10:00 (19Nov04) Mountain Time