| Useless Facts Light Bulb |
| Favorites Citi Bank Tiger Direct Kodak Gallery Mapquest MSN My Yahoo Netflix Peoples CT RD Old Sportsline TD Ameritrade Treasury Direct | Email GMail Hotmail SecureServer Yahoo Calendar Calendar | Gottschee AAA 2003 RD Page Flag.de Gottschee Satellite Image Kocevje | Mispelled Tashma Hall GMail Maps More Spreadsheets Youtube |
Articles Sell a Home |
Links Looselbs A711 Byelbs Cheddar Jones CJNQ erty gotodrew J711 Kobetitsch ReliantDrive YoYoJo |
| Online Business Amazon EBay PayPal TiVo Yahoo Shop Pkg Tracking DHL Fed Ex UPS Brown USPS | Gadgets AES Best Buy Garmin GPS GPSBlowout Magellan GPS Sirius Sony Telecom Verizon Data Tip Verizon Wireless Vonage VOIP | Business Other Consumer Reports MTA New York Starbucks Small Business Small Business Advisor | Business Technology Best Buy Dell HP IBM Levono Linksys Sony | Photo B&H Broadway Photo Kodak Ofoto Picasa Shutterfly VZW Pix |
| Friends Bhandhavi Cheddar Jones Dennis Frankie`s Place Gourds Joe Kobetitsch.com Library Chic Mickey is the Best My Blue Elephant My Blue Elephant the Kids Spectator Spyderban The Murals | Fav Entertain Cylon Evite IMDB Photo B&H Broadway Photo Kodak Ofoto Picasa Shutterfly VZW Pix Stimulating Esperanto | Blogger akobet Jimmyb124 Reference Wikipedia | Music Sirius Radio | Home Media Winter2006 |
| Money BMW Financial Services Citi Bank Equiserve Exchange Traded Funds Fidelity Kitco Gold MS Money Central PAFCU Peoples CT TD Waterhouse | Real Estate Coldwell Banker Realtor.com Zillow | Resources Loan Calculator MedVed Spiders | Charity Glenbrook FD |
#/usr/bin/sh
source ./tts_env.sh
#########################################
# DELETE THE TARGET TABLE SPACES
#########################################
sqlplus /nolog {LT LT}EOF
connect ${CONN_TGT}
-- Setup environment
set sqlprompt ""
set echo off
set feedback off
set heading off
set linesize 120
set verify off
set pagesize 32000
set serveroutput on SIZE 1000000
DROP TABLE ${SCH_TGT}.FCT_RX_WKLY CASCADE CONSTRAINTS
/
DROP TABLESPACE WTS_IDX INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS
/
DROP TABLESPACE WTS_40010 INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS
/
DROP TABLESPACE WTS_40011 INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS
/
DROP TABLESPACE WTS_40012 INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS
/
DROP TABLESPACE WTS_40013 INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS
/
DROP TABLESPACE WTS_40014 INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS
/
DROP TABLESPACE WTS_40015 INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS
/
DROP TABLESPACE WTS_40016 INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS
/
DROP TABLESPACE WTS_40017 INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS
/
DROP TABLESPACE WTS_40018 INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS
/
DROP TABLESPACE WTS_40019 INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS
/
DROP TABLESPACE WTS_40020 INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS
/
DROP TABLESPACE WTS_40021 INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS
/
DROP TABLESPACE WTS_40022 INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS
/
DROP TABLESPACE WTS_40023 INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS
/
DROP TABLESPACE WTS_40024 INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS
/
DROP TABLESPACE WTS_40025 INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS
/
DROP TABLESPACE WTS_40026 INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS
/
DROP TABLESPACE WTS_40027 INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS
/
DROP TABLESPACE WTS_40028 INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS
/
DROP TABLESPACE WTS_OTHER INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS
/
EOF
#########################################
# PREP FOR TRANSPORT
#########################################
sqlplus /nolog {LT LT}EOF
connect ${CONN_SRC}
-- Setup environment
set sqlprompt ""
set echo off
set feedback off
set heading off
set linesize 120
set verify off
set pagesize 32000
-- SET TERMOUT OFF
set serveroutput on SIZE 1000000
DECLARE
n_vio number;
str varchar2(250);
BEGIN
sys.DBMS_TTS.TRANSPORT_SET_CHECK('WTS_IDX,WTS_40010,WTS_40011,WTS_40012,WTS_40013,WTS_40014,WTS_40015,WTS_40016,WTS_40017,WTS_40018,WTS_40019,WTS_40020,WTS_40021,WTS_40022,WTS_40023,WTS_40024,WTS_40025,WTS_40026,WTS_40027,WTS_40028,WTS_OTHER', TRUE);
SELECT count(*) INTO n_vio
FROM sys.TRANSPORT_SET_VIOLATIONS;
IF n_vio > 0 THEN
DBMS_OUTPUT.PUT_LINE('*****');
DBMS_OUTPUT.PUT_LINE('ERROR: Violations in the TTS');
DBMS_OUTPUT.PUT_LINE('*****');
ELSE
DBMS_OUTPUT.PUT_LINE('*****');
DBMS_OUTPUT.PUT_LINE('OKAY FOR TRANSPORT');
DBMS_OUTPUT.PUT_LINE('*****');
str := 'ALTER TABLESPACE WTS_IDX READ ONLY';
execute immediate str;
str := 'ALTER TABLESPACE WTS_40010 READ ONLY';
execute immediate str;
str := 'ALTER TABLESPACE WTS_40011 READ ONLY';
execute immediate str;
str := 'ALTER TABLESPACE WTS_40012 READ ONLY';
execute immediate str;
str := 'ALTER TABLESPACE WTS_40013 READ ONLY';
execute immediate str;
str := 'ALTER TABLESPACE WTS_40014 READ ONLY';
execute immediate str;
str := 'ALTER TABLESPACE WTS_40015 READ ONLY';
execute immediate str;
str := 'ALTER TABLESPACE WTS_40016 READ ONLY';
execute immediate str;
str := 'ALTER TABLESPACE WTS_40017 READ ONLY';
execute immediate str;
str := 'ALTER TABLESPACE WTS_40018 READ ONLY';
execute immediate str;
str := 'ALTER TABLESPACE WTS_40019 READ ONLY';
execute immediate str;
str := 'ALTER TABLESPACE WTS_40020 READ ONLY';
execute immediate str;
str := 'ALTER TABLESPACE WTS_40021 READ ONLY';
execute immediate str;
str := 'ALTER TABLESPACE WTS_40022 READ ONLY';
execute immediate str;
str := 'ALTER TABLESPACE WTS_40023 READ ONLY';
execute immediate str;
str := 'ALTER TABLESPACE WTS_40024 READ ONLY';
execute immediate str;
str := 'ALTER TABLESPACE WTS_40025 READ ONLY';
execute immediate str;
str := 'ALTER TABLESPACE WTS_40026 READ ONLY';
execute immediate str;
str := 'ALTER TABLESPACE WTS_40027 READ ONLY';
execute immediate str;
str := 'ALTER TABLESPACE WTS_40028 READ ONLY';
execute immediate str;
str := 'ALTER TABLESPACE WTS_OTHER READ ONLY';
execute immediate str;
END IF;
END;
/
DISCONNECT
EXIT
EOF
sleep 300
#########################################
# CREATE TRANSPORT FILES
# Copy the Data files to the dest database
#########################################
rm -f /cygdrive/${DRIVE_TRANS}/tts/adm_fct_rx_wkly.dmp
rm -f /cygdrive/${DRIVE_TRANS}/tts/adm_fct_rx_wkly_export.log
expdp ${CONN_SRC} DUMPFILE=adm_fct_rx_wkly.dmp DIRECTORY=trans_dir TRANSPORT_TABLESPACES=WTS_IDX,WTS_40010,WTS_40011,WTS_40012,WTS_40013,WTS_40014,WTS_40015,WTS_40016,WTS_40017,WTS_40018,WTS_40019,WTS_40020,WTS_40021,WTS_40022,WTS_40023,WTS_40024,WTS_40025,WTS_40026,WTS_40027,WTS_40028,WTS_OTHER logfile=adm_fct_rx_wkly_export.log
echo
echo "Removing any previous target database files"
rm -f /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_IDX.DBF
rm -f /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_40010.DBF
rm -f /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_40011.DBF
rm -f /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_40012.DBF
rm -f /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_40013.DBF
rm -f /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_40014.DBF
rm -f /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_40015.DBF
rm -f /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_40016.DBF
rm -f /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_40017.DBF
rm -f /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_40018.DBF
rm -f /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_40019.DBF
rm -f /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_40020.DBF
rm -f /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_40021.DBF
rm -f /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_40022.DBF
rm -f /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_40023.DBF
rm -f /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_40024.DBF
rm -f /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_40025.DBF
rm -f /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_40026.DBF
rm -f /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_40027.DBF
rm -f /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_40028.DBF
rm -f /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_OTHER.DBF
echo "Copying source to target database files"
cp /cygdrive/${DRIVE_SRC_2}/oradata/${DB_SRC}/WTS_IDX.DBF /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_IDX.DBF
cp /cygdrive/${DRIVE_SRC_2}/oradata/${DB_SRC}/WTS_40010.DBF /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_40010.DBF
cp /cygdrive/${DRIVE_SRC_2}/oradata/${DB_SRC}/WTS_40011.DBF /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_40011.DBF
cp /cygdrive/${DRIVE_SRC_2}/oradata/${DB_SRC}/WTS_40012.DBF /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_40012.DBF
cp /cygdrive/${DRIVE_SRC_2}/oradata/${DB_SRC}/WTS_40013.DBF /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_40013.DBF
cp /cygdrive/${DRIVE_SRC_2}/oradata/${DB_SRC}/WTS_40014.DBF /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_40014.DBF
cp /cygdrive/${DRIVE_SRC_2}/oradata/${DB_SRC}/WTS_40015.DBF /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_40015.DBF
cp /cygdrive/${DRIVE_SRC_2}/oradata/${DB_SRC}/WTS_40016.DBF /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_40016.DBF
cp /cygdrive/${DRIVE_SRC_2}/oradata/${DB_SRC}/WTS_40017.DBF /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_40017.DBF
cp /cygdrive/${DRIVE_SRC_2}/oradata/${DB_SRC}/WTS_40018.DBF /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_40018.DBF
cp /cygdrive/${DRIVE_SRC_2}/oradata/${DB_SRC}/WTS_40019.DBF /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_40019.DBF
cp /cygdrive/${DRIVE_SRC_2}/oradata/${DB_SRC}/WTS_40020.DBF /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_40020.DBF
cp /cygdrive/${DRIVE_SRC_2}/oradata/${DB_SRC}/WTS_40021.DBF /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_40021.DBF
cp /cygdrive/${DRIVE_SRC_2}/oradata/${DB_SRC}/WTS_40022.DBF /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_40022.DBF
cp /cygdrive/${DRIVE_SRC_2}/oradata/${DB_SRC}/WTS_40023.DBF /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_40023.DBF
cp /cygdrive/${DRIVE_SRC_2}/oradata/${DB_SRC}/WTS_40024.DBF /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_40024.DBF
cp /cygdrive/${DRIVE_SRC_2}/oradata/${DB_SRC}/WTS_40025.DBF /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_40025.DBF
cp /cygdrive/${DRIVE_SRC_2}/oradata/${DB_SRC}/WTS_40026.DBF /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_40026.DBF
cp /cygdrive/${DRIVE_SRC_2}/oradata/${DB_SRC}/WTS_40027.DBF /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_40027.DBF
cp /cygdrive/${DRIVE_SRC_2}/oradata/${DB_SRC}/WTS_40028.DBF /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_40028.DBF
cp /cygdrive/${DRIVE_SRC_2}/oradata/${DB_SRC}/WTS_OTHER.DBF /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_OTHER.DBF
cp /cygdrive/${DRIVE_SRC_2}/oradata/${DB_SRC}/WTS_IDX.DBF /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_IDX.DBF
echo "Changing permissions on target database files"
chmod 777 /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_IDX.DBF
chmod 777 /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_40010.DBF
chmod 777 /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_40011.DBF
chmod 777 /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_40012.DBF
chmod 777 /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_40013.DBF
chmod 777 /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_40014.DBF
chmod 777 /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_40015.DBF
chmod 777 /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_40016.DBF
chmod 777 /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_40017.DBF
chmod 777 /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_40018.DBF
chmod 777 /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_40019.DBF
chmod 777 /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_40020.DBF
chmod 777 /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_40021.DBF
chmod 777 /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_40022.DBF
chmod 777 /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_40023.DBF
chmod 777 /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_40024.DBF
chmod 777 /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_40025.DBF
chmod 777 /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_40026.DBF
chmod 777 /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_40027.DBF
chmod 777 /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_40028.DBF
chmod 777 /cygdrive/${DRIVE_TGT_2}/oradata/${DB_TGT}/WTS_OTHER.DBF
#########################################
# IMPORT TRANSPORT FILES
# Mount the data files
#########################################
rm -f /cygdrive/${DRIVE_TRANS}/tts/adm_fct_rx_wkly_imp.par
cat << EOF >/cygdrive/${DRIVE_TRANS}/tts/adm_fct_rx_wkly_imp.par
DUMPFILE=adm_fct_rx_wkly.dmp
DIRECTORY=trans_dir
TRANSPORT_DATAFILES=${DRIVE_TGT_2}:\\oradata\\${DB_TGT}\\WTS_IDX.DBF
TRANSPORT_DATAFILES=${DRIVE_TGT_2}:\\oradata\\${DB_TGT}\\WTS_40010.DBF
TRANSPORT_DATAFILES=${DRIVE_TGT_2}:\\oradata\\${DB_TGT}\\WTS_40011.DBF
TRANSPORT_DATAFILES=${DRIVE_TGT_2}:\\oradata\\${DB_TGT}\\WTS_40012.DBF
TRANSPORT_DATAFILES=${DRIVE_TGT_2}:\\oradata\\${DB_TGT}\\WTS_40013.DBF
TRANSPORT_DATAFILES=${DRIVE_TGT_2}:\\oradata\\${DB_TGT}\\WTS_40014.DBF
TRANSPORT_DATAFILES=${DRIVE_TGT_2}:\\oradata\\${DB_TGT}\\WTS_40015.DBF
TRANSPORT_DATAFILES=${DRIVE_TGT_2}:\\oradata\\${DB_TGT}\\WTS_40016.DBF
TRANSPORT_DATAFILES=${DRIVE_TGT_2}:\\oradata\\${DB_TGT}\\WTS_40017.DBF
TRANSPORT_DATAFILES=${DRIVE_TGT_2}:\\oradata\\${DB_TGT}\\WTS_40018.DBF
TRANSPORT_DATAFILES=${DRIVE_TGT_2}:\\oradata\\${DB_TGT}\\WTS_40019.DBF
TRANSPORT_DATAFILES=${DRIVE_TGT_2}:\\oradata\\${DB_TGT}\\WTS_40020.DBF
TRANSPORT_DATAFILES=${DRIVE_TGT_2}:\\oradata\\${DB_TGT}\\WTS_40021.DBF
TRANSPORT_DATAFILES=${DRIVE_TGT_2}:\\oradata\\${DB_TGT}\\WTS_40022.DBF
TRANSPORT_DATAFILES=${DRIVE_TGT_2}:\\oradata\\${DB_TGT}\\WTS_40023.DBF
TRANSPORT_DATAFILES=${DRIVE_TGT_2}:\\oradata\\${DB_TGT}\\WTS_40024.DBF
TRANSPORT_DATAFILES=${DRIVE_TGT_2}:\\oradata\\${DB_TGT}\\WTS_40025.DBF
TRANSPORT_DATAFILES=${DRIVE_TGT_2}:\\oradata\\${DB_TGT}\\WTS_40026.DBF
TRANSPORT_DATAFILES=${DRIVE_TGT_2}:\\oradata\\${DB_TGT}\\WTS_40027.DBF
TRANSPORT_DATAFILES=${DRIVE_TGT_2}:\\oradata\\${DB_TGT}\\WTS_40028.DBF
TRANSPORT_DATAFILES=${DRIVE_TGT_2}:\\oradata\\${DB_TGT}\\WTS_OTHER.DBF
REMAP_SCHEMA=(OPS\$MSG:adm_ro)
EOF
impdp ${CONN_TGT} parfile=${DRIVE_TRANS}:\\tts\\adm_fct_rx_wkly_imp.par
#########################################
# SET STAGING TABLESPACES BACK TO READ WRITE
#########################################
sqlplus /nolog {LT LT}EOF
connect ${CONN_SRC}
ALTER TABLESPACE WTS_IDX READ WRITE
/
ALTER TABLESPACE WTS_40010 READ WRITE
/
ALTER TABLESPACE WTS_40011 READ WRITE
/
ALTER TABLESPACE WTS_40012 READ WRITE
/
ALTER TABLESPACE WTS_40013 READ WRITE
/
ALTER TABLESPACE WTS_40014 READ WRITE
/
ALTER TABLESPACE WTS_40015 READ WRITE
/
ALTER TABLESPACE WTS_40016 READ WRITE
/
ALTER TABLESPACE WTS_40017 READ WRITE
/
ALTER TABLESPACE WTS_40018 READ WRITE
/
ALTER TABLESPACE WTS_40019 READ WRITE
/
ALTER TABLESPACE WTS_40020 READ WRITE
/
ALTER TABLESPACE WTS_40021 READ WRITE
/
ALTER TABLESPACE WTS_40022 READ WRITE
/
ALTER TABLESPACE WTS_40023 READ WRITE
/
ALTER TABLESPACE WTS_40024 READ WRITE
/
ALTER TABLESPACE WTS_40025 READ WRITE
/
ALTER TABLESPACE WTS_40026 READ WRITE
/
ALTER TABLESPACE WTS_40027 READ WRITE
/
ALTER TABLESPACE WTS_40028 READ WRITE
/
ALTER TABLESPACE WTS_OTHER READ WRITE
/
EOF
echo "*** ***************************************"
echo "*** $0 shell script DONE"
echo "*** ***************************************"