RE: Critical Qs on materialized views
- To: <tomday2@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 26 Aug 2005 17:50:31 +0530
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@S829mig_teja;
refresh complete as select * from d1@S829mig_teja
*
ERROR at line 2:
ORA-12014: 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@S829mig_teja ;
as select * from d1@S829mig_teja
*
ERROR at line 2:
ORA-00955: 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@S829mig_teja;
as select * from d1@S829mig_teja
*
ERROR at line 2:
ORA-12058: 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***
--
//www.freelists.org/webpage/oracle-l
Other related posts:
