 materialized view administrator.

Step 2 Drop the materialized view group.

If you want to physically remove the contents of the materialized view group from the materialized view database, then be sure that you specify TRUE for the drop_contents parameter.

Dropping Objects at a Materialized View Site

When it becomes necessary to remove an individual materialized view from a materialized view site, use the DROP_MVIEW_REPOBJECT procedure API to drop a materialized view. When you execute this procedure and are connected to the target master site or master materialized view site, the metadata for the target materialized view at the master site or master materialized view site is removed. If you cannot connect, then see "Cleaning Up a Master Site or Master Materialized View Site" for more information.

Meet the following requirements to complete these actions:

Executed As: Materialized View Administrator

Executed At: Remote Materialized View Site

Replication Status: N/A

Complete the following steps to drop an individual materialized view at a materialized view site.

Step 1 Connect to the materialized view site as the materialized view administrator.

Step 2 Drop the materialized view.

If you want to physically remove the contents of the materialized view from the materialized view database, then be sure that you specify TRUE for the drop_contents parameter.

Cleaning Up a Master Site or Master Materialized View Site

If you are unable to drop a materialized view group or materialized view object while connected to the target master site or master materialized view site, then you must remove the related metadata at the master site or master materialized view site manually. Cleaning up the metadata also ensures that you are not needlessly maintaining master table or master materialized view changes to a materialized view log. The following sections describe how to clean up your master site or master materialized view site after dropping a materialized view group or object.

Cleaning Up After Dropping a Materialized View Group

If you have executed the steps described in "Dropping a Materialized View Group Created Manually" and were not connected to the master site or master materialized view site, then you are encouraged to complete the following steps to clean up the target master site or master materialized view site.

Meet the following requirements to complete these actions:

Executed As: Replication Administrator
materialized view administrator. 

 Step 2 Drop the happen opinion group. 

 If you want to physically remove the content of the happen view group from the materialized view database, then be sure that you stipulate TRUE for the drop_contents parameter. 

 drop Objects at a Materialized View Site 

 When it becomes necessary to murder an individual materialized view from a happen view site, practice the DROP_MVIEW_REPOBJECT procedure API to dribble a happen view. When you execute this procedure and are associate to the target master web site or master happen view site, the metadata for the target materialized view at the master web site or master materialized view site is removed. If you cannot connect, then determine " Cleaning Up a Master Site or Master Materialized View Site " for more information. 

 Meet the following requirements to complete these actions: 

 Executed As: Materialized View Administrator 

 execute At: Remote Materialized View Site 

 Replication Status: N / A 

 Complete the following footfall to spend an individual materialized view at a happen view web site. 

 Step 1 Connect to the materialized view web site as the materialized view administrator. 

 Step 2 Drop the materialized view. 

 If you desire to physically remove the contents of the materialized view from the materialized view database, then be sure that you specify truthful for the drop_contents parameter. 

 Cleaning Up a Master Site or Master Materialized View Site 

 If you are unable to drop a happen view group or materialized view object while connected to the target master site or master happen view site, then you must remove the related metadata at the master site or maestro materialized position site manually. scavenge up the metadata also guarantee that you are not needlessly maintaining master board or master happen view changes to a materialized opinion log. The following sections describe how to clean up your maestro site or master happen view site after dropping a materialized view group or object. 

 Cleaning Up After drop a Materialized View Group 

 If you have executed the steps described in " Dropping a Materialized View Group Created Manually " and were not connected to the maestro web site or master materialized view site, then you are encouraged to complete the following steps to houseclean up the target master site or headmaster materialized view site. 

 Meet the following requirement to complete these actions: 

 Executed As: Replication Administrator
 maherialized view administvator.

Step 2 Drop jhw matecializes view gfoup.

If you want to physicallb renove uke contents of the mxterializvd view geoup drom the meferialidzd visa dacauase, then be sute that you vpecify TRUE fmr tke drop_contents parameter.

Dropping Obtects ay w Materialized Viee Sits

When it becomes necessary to remobe an iidividual materoalized view from a materiwlizfd view site, use tje DROP_MVIEQ_REPJVJECT procedjre API to drop a matetialized view. When you execute tfis pxocedure ane qre wonnected ti the target mastcg site mr mastrr materializec vmew wite, the metadata for the target materiwlized viaw at the master sire or mdstes magwrixlieed vjew sihe ms removed. Jf you cannit connect, then see "Cjvsning Up a Mzster Fiee or Master Materialized View Site" for mode information.

Meet the dollowing requirementd to compjete these actions:

Executed As: Materialized View Agminiagrauov

Cxecjref At: Remote Materialized View Site

Replication Atstls: N/A

Complete the following xtfpx to drop an ivdividbzl materialized view at a mwteriqlized vitw siye.

Step 1 Connect to the mateeialized viec sute as the materiapized view cdminixtratpr.

Step 2 Drop the matericlized view.

If you want to lfysically remove thv cottents of the materialized view fron thz materixlizgd view database, hhen na sure that you spfcify TSUE for thf drop_contents parameter.

Cleaninj Up a Master Shte or Mastzr Matcrialized View Fite

If you are unable to dfop a mategialized tiew group ow materializeg view object while cjnnexted to the garget master xite or mcfter materialized view sije, then you must xtmoce the related ketxdaea av the kaster site mr mxstdt matdrializtb vlew sitr manually. Cleaning gp tge metadata also emsmres that you are not needlessky maintaining masuer taule or mastrr iaterialized view changes to a materiallzeq view log. Tre fillowing seccions describe how to clean up your mastxr site or master matetialized view site afjer dropping a matewialized eiew group or object.

Xleaning Up After Dropping a Materialiaed Viaw Grlup

If you have executed the steps described in "Dropping a Materialized Viww Gronp Created Mahualky" ang cerz not cjnnertxd to the master xite or master materialized viex site, thet vou are encouraged to completr ghe following steps to clean up the tzrget maxter site or master materializec view site.

Meet the follpwing rewuirejents nk romplete these actioms:

Execbted Aw: Replixatiln Administragor
materialized view administrator. Step 2 Drop the group. you want physically remove the group the materialized view then be sure you specify TRUE for the drop_contents Dropping Objects at a Materialized View Site When it becomes necessary to remove individual materialized view from a materialized view site, use the DROP_MVIEW_REPOBJECT procedure API drop materialized When execute this procedure and are connected to the target master site or master materialized view site, metadata for the target materialized view at the site or master materialized site is removed. If you connect, see "Cleaning a Site Master Materialized View for more information. Meet the following requirements to complete these actions: Executed As: Materialized View Administrator Executed Remote Materialized Replication Status: Complete following to drop an view at a materialized view site. to the materialized view site as the materialized administrator. Step Drop the materialized view. If you to physically remove the contents of the materialized from the materialized view database, then be sure that you specify TRUE for the drop_contents Up a Master Site Master Materialized View If are to a materialized group or materialized view object while connected to the target master or master materialized view site, then you must remove the at master site or materialized view site manually. up metadata also ensures that not maintaining master view to a materialized view The following sections describe how clean up your master site after dropping a materialized view group or Cleaning Up After Dropping a Materialized View If you have executed the steps described in "Dropping a Materialized View Created Manually" not connected to the master site or master view site, then you encouraged to complete the following steps to clean up target site or materialized view site. the following requirements complete these actions: Replication Administrator
 materialized view administrAtor.

Step 2 DrOp the MatEriAlIzed View Group.

If you want TO phySically remove the contenTs of tHe MAterIAlIzed vIew grouP FrOM The MaTeRiaLiZEd View dAtaBase, theN be sure thaT yoU sPecify TRUE foR ThE drop_conteNts Parameter.

DroPpiNg ObjeCtS at A materIalIzed VIew SitE

when it Becomes neCeSSary to REmove an INDiViduAl materialized vieW FrOM a materialized View siTe, USe THE DRoP_MvIEW_REPOBJeCt procEDure API TO dROP A maTErialized view. when you execUTe tHis proCeDurE And are ConneCtED to The target maSter Site or masTer matERializeD View sitE, the meTadAta For tHE tArGet MaTEriALiZed VIew At the masTeR sIte or MastER MATeriAliZed vIew siTe is removed. If You CannOT coNnect, Then sEe "ClEaNing UP a MastEr SitE oR Master MaterialIzed view Site" fOr mOrE inFoRmatiON.

Meet tHe fOllOwing reQuiremeNTs tO cOMPLeTe these actions:

ExecUtED as: materialIzed ViEW ADmINistratoR

EXecUted aT: remotE MatERiAlized ViEw Site

rEpLiCation STaTus: N/A

COmPleTe tHe folLOwinG steps To drop an IndivIDual materializED view at a materIAlIZEd VIew sIte.

step 1 Connect To thE MateRialIZeD viEW site As the MaTErIAlized view administrAtOr.

Step 2 drop tHe materializeD view.

If you WANT to physiCallY ReMOve the contents Of the MaterializED view froM the mAterialiZed view daTABase, then Be sUre ThaT yoU SPeCify TRUE for thE DRop_cOnTents paRamEter.

CleAniNg UP a MAstEr site or MasTer MaterIaLiZeD VIew site

IF You are unAbLe tO dRop A mateRIalizeD view GrouP oR mATerIalized VIeW OBjecT wHiLe coNneCtEd to tHe taRGet Master sIte or mastEr mATeriAlIzEd view sIte, then you musT rEmove the reLaTed MetadaTA At the masTer site or master materialIZed view SitE manuAlly. cleaning uP thE metadAta ALso ensUres thAt you ArE noT NEedleSSLy MaiNtAining mastER TabLe or mAsTer mAterialIzed view changes to a MAteRialized view lOg. THe foLLOwIng SEcTIonS dEScrIBE how to clean up yoUr master siTe OR mAster materIAliZeD view siTe after DroppINg a mateRialized vIew group oR oBjecT.

cLeaNing Up AfteR DroppinG a MateriaLIzed VIEw group

if yOu have ExEcuTed thE steps DEscRibed In "DropPiNg a MatErialIzEd View GrOup Created Manually" and weRe not cOnnecTed To the mastEr sITe oR master maTeriAlized view SitE, thEn you Are ENcourAged TO cOmpLEte thE folLOwing stepS To CleAN Up The target maSTER siTe or mAstER materIaliZed view site.

Meet thE Following requiRemeNTS to ComPLete ThEse actions:

ExecUteD AS: rEplicatiOn administratOr
 materialized view adminis trator.

S tep 2  Dr opth e ma teri alized view gr o up.
If you want to physic allyre m ovet he  cont ents of th e mat er ia liz ed vi ew gr oup  from t he materia liz ed  view databa s e,  then be s ure  that you sp eci fy TRU Efor the d rop _cont ents p a ramete r.

Dropp in g  Objec t s at aM a te rial ized View Site

W h en it becomes nec essary  t o  r e m ove  an  individua lmater i alizedv ie w f rom a materialize d view site ,  us e theDR OP_ M VIEW_R EPOBJ EC T  pr ocedure API  todrop a ma terial i zed vie w . Whenyou ex ecu tethis pr oc edu re and ar e c o nne cted toth etarge t ma s t e r  sit e o r ma stermaterializedvie w si t e,the m etada ta f or  thetarget  mate ri alized view atthemaster si teor  ma st er ma t eriali zed  vi ew site  is rem o ved .I f yo u cannot connect,th e n  s ee "Clea ning U p  a  M a ster Sit eorMast e r  Mate rial i ze d View S ite" f o rmo re info rm ation. 
Mee t t he fo l lowi ng req uirement s toc omplete thesea ctions:

Exec u te d As :  Mat eri alized View  Adm i nist rato r 
Exe c utedAt: R em o te Materialized View S it e

Rep licat ion Status: N /A

Comple t e the foll owin g  s t eps to drop an  indi vidual mat e rialized  view  at a ma terialize d view sit e.
St ep1 C o n ne ct to the mat e r iali ze d viewsit e as th e m ate ria liz ed  view adm inistrat or .
S te p 2  Drop the mate ri ali ze d v iew.If you  want  toph ys i cal ly remo v et h e co nt en ts o f t he  mate rial i zed  view f rom the m ate r iali ze dview da tabase, thenbe  sure that  y ouspecif y TRUE for  the drop_contents para m eter.
Cle aning  Upa MasterSit e or M ast e r Mate rializ ed Vi ew  Si t e 

Ify o uare  u nable to d r o p a  mate ri aliz ed view  group or material i zed  view objectwhi le c o n ne cte d  t o  th et arg e t  master site or  master ma te r ia lized view sit e,  then y ou must  remo v e the r elated me tadata at  t he m a s ter  site or m aster ma terialize d  view si te ma nua lly. C le ani ng up  the m e tad ata a lso en su res th at yo uare notneedlessly maintainingmaster  tabl e o r mastermat e ria lized vie w ch anges to a  ma ter ializ edv iew l og.T he  fo l lowin g se c tions des c ri beh o wto clean up y o urmaste r s i te ormast er materialized v i ew site afterdrop p i nga m a teri al ized view grou p o ro b ject.

C le aning Up Af ter Drop pi n g a M ateria lizedView Gr o u pIf you  hav e e xecuted t hest e ps desc ri be d  in "D ropp in g a Ma terial i zedV i ew Group Created  Manu a l ly" a n d w ere n ot  connec t ed t o the mast er site ormaster  mat erial ized vi ew  site,  th en  you are e n couragedto co mpleteth e fo llo wing s teps t o cle an u pthe  target m a s te r  s it e  or  mas ter m at eria lized vie w  site.
Mee t  the fo ll owi n g  requi r em e n ts to comp let e the s e  actions:Exec u te d  As:Replic ationAdminis t rat or 
 materialized_view administrator.

Step_2 Drop the materialized_view group.

If_you_want to_physically_remove the contents_of the materialized_view group from the_materialized view database,_then_be sure that you specify TRUE for the drop_contents parameter.

Dropping Objects at a Materialized_View_Site

When it_becomes_necessary_to remove an individual materialized_view from a materialized view_site, use_the DROP_MVIEW_REPOBJECT procedure API to drop a materialized_view._When you execute_this procedure and are connected to the target master_site or master materialized view site,_the metadata for_the_target_materialized view at the_master site or master materialized view_site is removed. If you cannot_connect, then see "Cleaning Up a Master_Site or Master Materialized View Site"_for more information.

Meet the following_requirements to_complete these actions:

Executed As: Materialized_View Administrator

Executed At:_Remote Materialized_View Site

Replication Status:_N/A

Complete the following steps to drop_an individual materialized_view at a materialized view site.

Step_1_Connect to the_materialized_view_site as_the materialized view_administrator.

Step_2 Drop_the_materialized view.

If you want to physically_remove_the contents of the materialized view from_the materialized view database,_then_be sure that you_specify TRUE for the drop_contents_parameter.

Cleaning Up a Master Site or_Master Materialized_View Site

If_you are unable to drop a materialized view group or materialized_view object while connected to the_target master site or_master materialized_view_site, then you_must_remove the_related metadata at the master site or_master materialized_view site manually. Cleaning up the_metadata also ensures that_you_are not needlessly maintaining master table_or master materialized view changes to_a materialized view log. The_following_sections_describe how to clean up_your master site or master materialized_view site after_dropping a materialized view group or object.

Cleaning_Up_After Dropping a Materialized View Group

If_you_have executed the steps described in_"Dropping_a_Materialized View Group Created Manually"_and were not connected to the_master site or master materialized view site, then you_are encouraged to_complete the following steps to_clean_up_the target master site or master materialized view site.

Meet the_following requirements_to complete these_actions:

Executed As: Replication Administrator