Critical Qs on materialized views 2005-08-26 - By oracle-l-bounce@(protected)
We need to create the Materlialized view on PRE-Built Table WITHOUT
adding a Constraint to the Master/source Table. This is needed because
the Production (LIVE) Database(Master/Source) has NO existing
constraints & creating the same on the large 600 GB production
Database's tables would be nearly impossible.
NOTE - We are getting the following Errors when attempting to create a
Materlialized view on PRE-Built Table WITHOUT adding a Constraint to the
Master/source Table:-
SQL> create materialized view d1 BUILD IMMEDIATE
2 refresh complete as select * from d1@(protected);
refresh complete as select * from d1@(protected)
*
ERROR at line 2:
ORA-12014 (See ORA-12014.ora-code.com): table 'D1' does not contain a primary key constraint
SQL> create materialized view d1 BUILD IMMEDIATE refresh complete with
rowid
2 as select * from d1@(protected) ;
as select * from d1@(protected)
*
ERROR at line 2:
ORA-00955 (See ORA-00955.ora-code.com): name is already used by an existing object
SQL> create materialized view d1 on prebuilt table refresh complete with
rowid
2 as select * from d1@(protected);
as select * from d1@(protected)
*
ERROR at line 2:
ORA-12058 (See ORA-12058.ora-code.com): materialized view cannot use prebuilt table
Give Command with respective syntax, if possible.
Another basic question - When a constraint is created does it
automatically create an internal underlying index on the respective
table?
Thanks indeed
**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely
for the use of the addressee(s). If you are not the intended recipient, please
notify the sender by e-mail and delete the original message. Further, you are
not to copy, disclose, or distribute this e-mail or its contents to any other
person and any such actions are unlawful. This e-mail may contain viruses.
Infosys has taken every reasonable precaution to minimize this risk, but is not
liable for any damage you may sustain as a result of any virus in this e-mail.
You should carry out your own virus checks before opening the e-mail or
attachment. Infosys reserves the right to monitor and review the content of all
messages sent to or from this e-mail address. Messages sent to or from this e
-mail address may be stored on the Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***
--
http://www.freelists.org/webpage/oracle-l
|
|
