-- This script retrieves all CERA information of the loading
--    tables (=LOAD_* and NEW_*) into getLOAD.lst
SET LINESIZE 130
SET PAGESIZE 5000
SET PAUSE OFF
SET TRIMSPOOL ON
SET TRIMOUT ON
spool getLOAD
-- tables NEW_*
select * from NEW_access_constraint;
select * from NEW_access_type;
select * from NEW_aggregation;
select * from NEW_citation;
select * from NEW_citation_type;
select * from NEW_contact_type;
select * from NEW_currentness_ref;
select * from NEW_fees;
select * from NEW_format;
select * from NEW_general_key;
select * from NEW_hor_coord_sys;
select * from NEW_location;
select * from NEW_institute;
select * from NEW_person;
select * from NEW_presentation;
select * from NEW_progress;
select * from NEW_project;
select * from NEW_ref_type;
select * from NEW_spatial_data_org;
select * from NEW_storage;
select * from NEW_topic;
select * from NEW_unit;
select * from NEW_use_constraint;
select * from NEW_ver_coord_sys;
-- tables LOAD_*
select * from LOAD_ENTRY;
select * from LOAD_CONTA;
select * from LOAD_REFER;
select * from LOAD_PARAM;
select * from LOAD_COVER;
select * from LOAD_DISTR;
select * from LOAD_SPATI;
select * from LOAD_PROCE;
select * from LOAD_KEY_C;
--
spool off
SET PAUSE ON
SET PAGESIZE 36
