...

TRANSFER schema procedures

All of these scripts were designed to be executed with TRANSFER schema owner privileges--operating within a given database instance and its web of application-specific permissions and configurations.

BOX script

These scripts assist in automating shipboard beginning of expedition (BOX) database preparations.

BOX_ASMAN_CATALOG_DELETE
BOX_LIME_AUDIT_DELETE
BOX_LIMS_CLEANUP
BOX_LIMS_DEFRAG
BOX_LIMS_EXPEDITION_DELETE
BOX_SM_DELETE_REQUEST_CODES

Container load script

One of the shipboard systems (moisture and density) requires data for pre-weighed containers. This script aids in loading content from an Excel file into the shipboard LIMS.

CLHistory. These scripts were once routinely

Data copy script - formerly applied for EOX ETL

These COPY_* scripts were (routinely) applied by shipboard developers to prepare a copy of expedition data for transport to shore via an export of the TRANSFER schema. These EOX activities have been droppedThis EOX activity no longer occurs (since Dec 2022, Exp 398). Prior to Dec 2022 the scripts were named as-shown, but without the COPY_ prefix.

The scripts are retained as they for occasional use. They provide a semi-automated means for aggregating an expedition's data for transport into a test environment via the supporting tables in the TRANSFER schemas.

COPY_ASMAN_CATALOG_TO_NEW
COPY_DESCINFO_TO_NEW
COPY_LIMS_EXPEDITION_TO_NEW
COPY_MERGE_NEW_TO_LIMS

OVERVIEW script

These scripts support the computation of summary data presented by the database OVERVIEW application. Each script summarizes a different kind of data.

...

The OEM (Oracle Enterprise Manager) hosts on shore and ship host an NSF mount point used by each ODA (Oracle Data Appliance). Scripts used for a variety of database management purposes may be found here: /backup/scripts, /backup/scripts/rci_work

EOX load and merge - rci_work/exp

The collection of scripts in this location is used to automate the shore components of EOX processing: retrieve last expedition content from the database dump, create and apply moratorium supports, merge the data into production; provide statistics which give quality assurance/quality control on the process.

These are the scripts (in-order) that are typically used

# Shore EOX processing for a data load
# per Sunil Armarni from a Slack thread.
export EOX=#
chk_eox_count.ksh
select sum(bytes)/1024/1024 from dba_free_space where tablespace_name = 'TRANSFER'
import_transfer.ksh
transfer_upd_stat.ksh
data_pre_01_crt_unq.ksh
data_pre_01_chk_dup.ksh
eox_gen_in_moratorium_script.ksh <GROUP>
in_moratorium_<GROUP>.ksh
crt_user_exp.ksh $EOX
chk_tablespace_free.ksh
grp_cnt_transfer.ksh
data_pre_03_dis_trig.ksh
dis_trig_all_<YYYMMDD_HHMMSS>.sql
chk_eox_count.ksh exp#
exec transfer.lims_expedition_delete('#')
chk_eox_count.ksh
grp_cnt_lims.ksh
data_pre_05_without_DI_v6.ksh # calls scors also
grp_cnt_lims.ksh
chk_scale_data.ksh
data_pre_05_scale_data.ksh
chk_scale_data.ksh
enb_trig_all_<YYYMMDD_HHMMSS>.sql
merge_descinfo2_data_v2.ksh
insert_dbo_#.sql - N/A
dbo_compute_v4.sql exp#
data_post_06_upd_stat.ksh

Other script

tbd