Home » SQL & PL/SQL » SQL & PL/SQL » Mview with primary key table and no primary key table
Mview with primary key table and no primary key table [message #213643] Thu, 11 January 2007 12:06 Go to next message
prasanna_anbu
Messages: 34
Registered: November 2006
Location: india
Member
I have a materialized view join of 4 tables and one query(A)
in that 1 table not having primary key,all other 3 tables and
the tables involved in the query(A)having primary key

for that i tried to create the log for the tables involved in the query(A) i have faced ORA-12033

i tried to create the log with rowid and without rowid
primary key ,rowid,including newvalues and simply with primary key but anyway
i faced this Ora-12033

I want fast refersh for the Mview how can i do ? please
help me on this.
Re: Mview with primary key table and no primary key table [message #213650 is a reply to message #213643] Thu, 11 January 2007 13:06 Go to previous message
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
Maybe this will help.

http://www.error-code.org.uk/view.asp?cl=ORACLE&p=ORA&ec=12033

Google is your friend
Previous Topic: one question!
Next Topic: Function-based index not used
Goto Forum:
  


Current Time: Sat Dec 03 16:09:09 CST 2016

Total time taken to generate the page: 0.07567 seconds