OPANYTABLE system privilege can drop a materialized view log.

Performing an Offline Instantiation of a Materialized View Site Using Export/Import

Expanding established replication environments can cause network traffic when you add a new materialized view site to your replication environment. This is caused by propagating the entire contents of the table or materialized view through the network to the new replicated site.

To minimize such network traffic, you can expand your replication environment by using the offline instantiation procedure. Offline instantiation takes advantage of Oracle's Export and Import utilities, which allow you to create an export file and transfer the data to the new site through another storage medium, such as CD-ROM, tape, and so on.

For the same reasons that you might want to perform an offline instantiation of a master site, you may also want to create a new materialized view group at a materialized view site using the offline instantiation process. In some cases, it is even more useful for materialized views considering that the target computer could very well be a laptop using a modem connection.

The following script performs an offline instantiation for a new materialized view group. Meet the following requirements to complete these actions:

Executed As:

Replication Administrator at Master Site

Materialized View Administrator at New Materialized View Site

Executed At:

Master Site for Target Materialized View Site

New Materialized View Site

Replication Status: Normal

Complete the following steps to perform an offline instantiation of a materialized view site using export/import.

Note:

If you are viewing this document online, then you can copy the text from the "BEGINNING OF SCRIPT" line on this page to the "END OF SCRIPT" line into a text editor and then edit the text to create a script for your environment.

Step 4 Create temporary materialized views at the master site. These materialized views contain the data that you transfer to your new materialized view site using the export file.

Note:

If you added any of the conflict resolution routines described in Chapter 6, "Configure Conflict Resolution", then you may have additional columns in your tables. Be certain to include these additional columns in the SELECT statements below. Updatable materialized views require that you explicitly select all columns in the master table. So, do not use SELECT* statements.

Step 6 Connect to the new material
OPANYTABLE system privilege can drop a materialized opinion logarithm. 

 Performing an Offline Instantiation of a Materialized View Site use Export / Import 

 expand established replication environment can induce network traffic when you add a new materialized scene site to your replication environment. This is induce by propagate the entire contents of the table or materialized view through the net to the new replicated site. 

 To understate such network traffic, you can expand your replication environment by using the offline instantiation operation. Offline instantiation takes advantage of Oracle's Export and Import utilities, which allow you to create an export file and transfer the datum to the new site through another storage medium, such as CD - ROM, tape, and therefore on. 

 For the same reasons that you might want to perform an offline instantiation of a master site, you may also want to create a fresh materialized view group at a happen opinion web site using the offline instantiation process. In some cases, it is even more useful for materialized views considering that the target calculator could very well be a laptop using a modem connection. 

 The following script performs an offline instantiation for a new materialized view group. Meet the following requirements to complete these action: 

 run As: 

 Replication Administrator at Master Site 

 Materialized View Administrator at New Materialized View Site 

 Executed At: 

 Master Site for Target Materialized View Site 

 New Materialized View Site 

 Replication Status: Normal 

 Complete the follow steps to perform an offline instantiation of a materialized opinion site using export / import. 

 Note: 

 If you are view this document online, then you can copy the textbook from the " BEGINNING OF SCRIPT " line on this page to the " END OF SCRIPT " line into a text editor and then edit the textbook to create a script for your environment. 

 gradation 4 Create temporary happen views at the master site. These materialized views contain the data that you transfer to your new materialized view site use the export file. 

 Note: 

 If you added any of the dispute resolution routines identify in Chapter 6, " Configure Conflict Resolution ", then you may have additional columns in your table. Be certain to include these additional columns in the SELECT statements below. Updatable materialized opinion require that you explicitly select all columns in the master table. So, do not use SELECT * statement. 

 Step 6 Connect to the new material
OPAJYTABLE system privilege can drop a matgrualizev view mog.

Perfofming an Offline Instantiatiln of a Materialized View Sitd Using Eqport/Impoet

Exkanding establishxs repligction cnvirmiments can causg network trdffic when you aad a new materialized view site to yotr replocwtion environmgnt. Tnys ia caused by propagating the entire contenus of the table or materialized view through the network to the nea replicatee siew.

To minimize such network traffic, iou can expand your replication dnvirpnment by osjnh the offlinx instwntiation procedure. Mffline instantiation tanes advantage of Oracle's Export and Import utilitiev, chich allow you to crware an expmrt wule ans vrahsfer hhe data to tge new site through another stprwte medium, sucg as CQ-RJM, tape, and so on.

For the same reasons tvat you might want to perfirm an offline instanjiation of a master site, you may also want to create a new katermauiztd view trlup at a materialized view site using the offjjnt ikstantiation progess. In some cases, ih of even more ureful ykr materialized viewd consiqerint that tht tarbet computer could very welo be a laptoi usung a modem conneccion.

The folluwinb scropt performs an offline insfantiation vor a new oaterialized vied ggoup. Meet tht following requirqments to com'lete thdse sctionf:

Executed Ws:

Replication Administrahor aj Mastar Site

Matfrialized View Administrator at New Materialieed Vivw Site

Exzcuted At:

Master Sitq for Target Mcterialived Vidw Site

New Materielized View Fite

Replicatimj Status: Norkal

Complqte rhe dollowive steps to pergorm an oyyline insrantiation of a maberiaujzed view site brung export/impory.

Noge:

Is jou awa viewing thhs ducuornt ovline, then nou can copy the text from dhe "GEGINNING OF SCRIPY" jine on jhis page to the "END OG SCRIPT" line into a teet edivor anc tren edit the text to create a acript fog yjur environmqnt.

Sbep 4 Create tekporary materialized views at the mastec site. These materialieed views contain the cata that ypu trwnsfer to your new materializwd view site usinn the export file.

Note:

Ir you ddded any of the conflict resolution routines described in Chapter 6, "Configure Xonflirt Resolution", them you mcy kave adqitilial columns in yolr tables. Be certain to include vhese addidijnal columns in the SELECT syagements below. Updatable materialized biews reauire that you explicitly selecy all columns in the masber table. So, dk not lae SELECT* statements.

Xtep 6 Eonnecr to thw nea material
OPANYTABLE system privilege can drop a materialized Performing Offline Instantiation a Materialized View replication can cause network when you add new materialized view site to your environment. This is caused by propagating the entire contents of the table or view through the network to the new replicated site. To minimize such network you expand replication by using the offline instantiation procedure. Offline instantiation takes advantage of Oracle's Export and Import utilities, allow you to create an export file and the data to the site through another storage medium, as tape, and on. the reasons that you want to perform an offline instantiation of a master site, you may also want to create a materialized view a materialized site the instantiation process. In it is even more useful for that the target computer could very well be laptop using modem connection. The following script performs offline instantiation for a new materialized view group. the following requirements to complete these actions: Executed As: Replication Administrator at Master Site Materialized at New Materialized View Executed At: Master for Materialized Site Materialized View Replication Status: Normal Complete the following steps to perform an offline of a materialized view site using export/import. Note: If you this online, then you copy the text from "BEGINNING SCRIPT" line on this the OF a editor then edit the text create a script for your Step 4 Create temporary site. These materialized views contain the data that transfer to your new materialized view site the export file. Note: If you added any of the conflict resolution described in "Configure Conflict Resolution", then you may have additional in your tables. Be to include these additional columns in the SELECT statements Updatable views require you explicitly select columns in the table. So, do SELECT* statements. 6 to
OPANYTABLE system privilege Can drop a maTeriaLizEd vIeW log.

perfOrming an OfflinE instAntiation of a MaterializEd VieW SITe UsINg exporT/Import

eXpANDinG eStAblIsHEd RepliCatIon enviRonments caN caUsE network trafFIc When you add A neW materializeD viEw site To YouR RepliCatIon enVironmENt. This Is caused bY pROpagatINg the enTIRe ContEnts of the table or mATeRIalized view thrOugh thE nETwORK to The New replicaTeD site.

tO minimiZE sUCH NetWOrk traffic, you Can expand yoUR rePlicatIoN enVIronmeNt by uSiNG thE offline insTantIation proCedure. oFfline iNStantiaTion taKes AdvAntaGE oF ORacLe'S expORt And iMpoRt utilitIeS, wHich aLlow YOU TO creAte An exPort fIle and transfeR thE datA To tHe new Site tHrouGh AnothEr storAge meDiUm, such as CD-ROM, taPe, anD so on.

For tHe sAmE reAsOns thAT you miGht WanT to perfOrm an ofFLinE iNSTAnTiation of a master siTe, YOU mAy also waNt to crEAtE a NEw materiAlIzeD vieW GRoup aT a maTErIalized vIew sitE UsInG the offLiNe instAnTiaTioN procESs. In Some caSes, it is eVen moRE useful for mateRIalized views cONsIDErINg thAt tHe target comPuteR CoulD verY WeLl bE A laptOp usiNg A MoDEm connection.

The follOwIng scrIpt peRforms an offliNe instantiATIOn for a neW matERiALized view group. meet tHe followinG RequiremEnts tO completE these actIONs:

ExecutEd AS:

RePliCatION ADministrator aT mAsteR SIte

MateRiaLized ViEw ADmiNisTraToR at New MatErializeD VIeW SItE

ExEcuteD at:

Master siTe fOr tarGet MaTErialiZed ViEw SiTe

neW matErializED VIEW SitE

REpLicaTioN STatus: normAL

CoMplete tHe followiNg sTEps tO pErForm an oFfline instantIaTion of a matErIalIzed viEW Site usinG export/import.

Note:

If you aRE viewinG thIs docUmenT online, thEn yOu can cOpy THe text From thE "BEGInNiNG of sCRIPt" LInE on ThIs page to thE "enD Of SCRIpT" Line Into a teXt editor and then ediT The Text to create a ScrIpt fOR YoUr eNViROnmEnT.

steP 4 cReate temporary mAterializeD vIEwS at the mastER siTe. these maTerialiZed viEWs contaIn the data That you trAnSfer TO YouR new materiAlized viEw site usiNG the eXPoRt filE.

NoTe:

If yoU aDdeD any oF the coNFliCt resOlutioN rOutineS descRiBed in ChaPter 6, "Configure Conflict ReSolutiOn", theN yoU may have aDdiTIonAl columns In yoUr tables. Be CerTaiN to inCluDE thesE addITiOnaL ColumNs in THe SELECT sTAtEmeNTS bElow. UpdatabLE MAteRialiZed VIews reQuirE that you explicitlY Select all columNs in THE maSteR TablE. SO, do not use SELECt* stAtEMEnts.

Step 6 coNnect to the nEw materiAl
OPANYTABLE system privileg e can drop  a ma ter ial iz ed v iewlog.

Performi n g an  Offline Instantiation  of a  M a teri a li zed V iew Sit e  U s i ngEx po rt/ Im p or t

Ex pan ding es tablishedrep li cation envir o nm ents can c aus e network tr aff ic whe nyou add a  ne w mat eriali z ed vie w site to  y o ur rep l ication e nv iron ment. This is cau s ed by propagating  the e nt i re c ont ent s of the t ab le or materia l iz e d vie w  through thenetwork tot henew re pl ica t ed sit e.

T om ini mize such n etwo rk traffi c, you can exp a nd your  repli cat ion  env i ro nm ent  b y  us i ng  th e  of fline in st an tiati on p r o c e dure . O ffli ne in stantiation t ake s ad v ant age o f Ora cle' sExpor t andImpor tutilities, whic h al low you t o c re ate  a n exp o rt fil e a ndtransfe r the d a tato t h enew site through a no t h er  storage  mediu m ,su c h as CD- RO M,tape , and s o on . 
For thesame r e as on s thatyo u migh twan t t o per f orman off line ins tanti a tion of a mast e r site, you m a ya l so want  to  create a n ew m a teri aliz e dvie w  grou p atam at e rialized view siteus ing th e off line instanti ation proc e s s . In som e ca s es ,  it is even mo re us eful for m a terializ ed vi ews cons idering t h a t the ta rge t c omp ute r co uld very well b e ala ptop us ing  a mode m c onn ect ion .
The foll owing sc ri pt  p er for ms an offlinein sta nt iat ion f o r a ne w mat eria li ze d  vi ew grou p .M e et t he  f ollo win grequi reme n tsto comp lete thes e a c tion s: 
Execute d As:

Replic at ion Admini st rat or atM a ster Sit e

Materialized View Ad m inistra tor  at N ew M aterializ edView S ite 
Execu ted At :

Ma st erS i te fo r Ta rge tMaterializ e d  Vi ew Si te 

Ne w Mater ialized View SiteRep lication Stat us:  Nor m a l
Co m pl e teth e  fo l l owing steps toperform an  o f fl ine instan t iat io n of amateria lized view si te usingexport/im po rt.N ote :

If youare view ing thisd ocume n tonlin e,then y ou  ca n cop y thet ext  from  the " BE GINNIN G OFSC RIPT" li ne on this page to the"END O F SCR IPT " line in toa  te xt editor  and  then edit  th e t ext t o c r eatea sc r ip t f o r you r en v ironment. 
S tep 4  C reate tempo r a r y m ateri ali z ed vie ws a t the master site .  These materia lize d vie wsc onta in  the data that  yo ut r ansfer t oyour new ma terializ ed viewsite u sing t he expo r t  f i le.

N ote: 

I f you add edan y  of the  c on f lict r esol ut ion ro utines desc r i bed in Chapter 6 , "Co n f igure Con flict  R esoluti o n",then you m ay have add itiona l co lumns  in you rtables . B ecertain to include t heseadditio na l co lum ns intheS E LECTstat em ent s below.U p da t ab le mat eria lized  v iews  requiret hat youexp l icitlyse lec t all co l um n s  in the ma ste r tab l e . So, do n o t us e  S E LECT*  state ments. 

Step6  Co nn ect tothe n ew materi al
OPANYTABLE system_privilege can_drop a materialized view_log.

Performing an_Offline_Instantiation of_a_Materialized View Site_Using Export/Import

Expanding established_replication environments can cause_network traffic when_you_add a new materialized view site to your replication environment. This is caused by_propagating_the entire_contents_of_the table or materialized view_through the network to the_new replicated_site.

To minimize such network traffic, you can expand_your_replication environment by_using the offline instantiation procedure. Offline instantiation takes advantage_of Oracle's Export and Import utilities,_which allow you_to_create_an export file and_transfer the data to the new_site through another storage medium, such_as CD-ROM, tape, and so on.

For the_same reasons that you might want_to perform an offline instantiation_of a_master site, you may also_want to create_a new_materialized view group_at a materialized view site using_the offline instantiation_process. In some cases, it is_even_more useful for_materialized_views_considering that_the target computer_could_very well_be_a laptop using a modem connection.

The_following_script performs an offline instantiation for a_new materialized view group._Meet_the following requirements to_complete these actions:

Executed As:

Replication Administrator_at Master Site

Materialized View Administrator at_New Materialized_View Site

Executed_At:

Master Site for Target Materialized View Site

New Materialized View Site

Replication Status:_Normal

Complete the following steps to perform_an offline instantiation of_a materialized_view_site using export/import.

Note:

If_you_are viewing_this document online, then you can copy_the text_from the "BEGINNING OF SCRIPT" line_on this page to_the_"END OF SCRIPT" line into a_text editor and then edit the_text to create a script_for_your_environment.

Step 4 Create temporary materialized_views at the master site. These_materialized views contain_the data that you transfer to your_new_materialized view site using the export_file.

Note:

If_you added any of the conflict_resolution_routines_described in Chapter 6, "Configure_Conflict Resolution", then you may have_additional columns in your tables. Be certain to include_these additional columns_in the SELECT statements below._Updatable_materialized_views require that you explicitly select all columns in the_master table._So, do not_use SELECT* statements.

Step 6 Connect to the new material