drop MATERIALIZED VIEW storetw.MV_REGULAR_RESULT_STATE
*
ERROR at line 1:
ORA-12003: materialized view "STORETW"."MV_REGULAR_RESULT_STATE" does not exist


drop MATERIALIZED VIEW storetw.MV_REGULAR_RESULT_CHAR
*
ERROR at line 1:
ORA-12003: materialized view "STORETW"."MV_REGULAR_RESULT_CHAR" does not exist


drop MATERIALIZED VIEW storetw.MV_REGULAR_RESULT_CHAR_STATE
*
ERROR at line 1:
ORA-12003: materialized view "STORETW"."MV_REGULAR_RESULT_CHAR_STATE" does not exist


drop MATERIALIZED VIEW storetw.MV_REGULAR_RESULT_ALL
*
ERROR at line 1:
ORA-12003: materialized view "STORETW"."MV_REGULAR_RESULT_ALL" does not exist


drop MATERIALIZED VIEW storetw.MV_REGULAR_RESULT_COUNTY
*
ERROR at line 1:
ORA-12003: materialized view "STORETW"."MV_REGULAR_RESULT_COUNTY" does not exist


drop MATERIALIZED VIEW storetw.MV_REGULAR_RESULT_CHAR_COUNTY
*
ERROR at line 1:
ORA-12003: materialized view "STORETW"."MV_REGULAR_RESULT_CHAR_COUNTY" does not exist



table names and row counts

TABLE_NAME                       NUM_ROWS
------------------------------ ----------
APP_COLUMN_NAME
BIOLOGICAL_RESULT_PROJECT         2403962
CHARACTERISTIC_CHARTYPE
DI_ACTIVITY_INTENT
DI_ACTIVITY_MATRIX
DI_ACTIVITY_MEDIUM                      7
DI_BIOPART
DI_CHARACTERISTIC                   13763
DI_COMMUNITY_SAMPLED
DI_DATE                             55152
DI_DB_CAT
DI_GEO_COUNTY
DI_GEO_STATE
DI_GROUP_TYPE
DI_ORG                                320
DI_PROJECT                           8660
DI_STATN_TYPES
DI_SUBJECT_TAXON
DW_DATA_REQUESTS
FA_BIOLOGICAL_RESULT              2360490
FA_BLOB
FA_HABITAT_RESULT                 6790077
FA_REGULAR_RESULT                63223366
FA_STATION                         397713
HABITAT_RESULT_PROJECT           16521462
LU_CHARTYPE                            10
LU_CHAR_ALIAS                       32978
LU_CHAR_ALIAS_TYPE                      9
LU_ESTRY_PRIMARY
LU_ESTRY_SECONDARY
LU_EXTERNAL_REF_SCHEME               1185
LU_MAD_HDATUM
LU_MAD_HMETHOD
LU_MAD_VDATUM
LU_MAD_VMETHOD
LU_STATION_ALIAS                    46095
LU_UNIT_CONVERSION
MD_ANALYTICAL_PROC                   5252
MD_CITATION                          1675
MD_COOP                               400
MD_COOP_ADDRESS                        55
MD_COOP_EADDRESS                       91
MD_LAB                               1482
MD_LAB_ADDRESS                        392
MD_LAB_EADDRESS                       503
MD_LAB_SAMPLE_PREP_PROCEDURE          901
MD_ORG_ADDRESS                        195
MD_ORG_EADDRESS                       314
MD_PROGRAM                              0
MD_SAMPLE_GEAR                          0
MD_SAMPLE_PRESRV                     1057
MD_SAMPLE_PROC                       1343
MT_ATTRIBUTE_MAP
MT_CHAR_CHARTYPE
MT_WH_CONFIG
REGULAR_RESULT_PROJECT           62068834
SEQ_GEN
STATION_CHAR                      6205886
STATION_PROJECT                    300965
WS_HUC_CHAR_SUMMARY                354012
WS_HUC_ORG_CHAR_SUMMARY            423592
WS_HUC_ORG_SUMMARY                   4725
WS_STATION_DATA                   6205886
WS_STATION_SUMMARY                6192751

regular result table column names and null counts

COLUMN_NAME                     NUM_NULLS
------------------------------ ----------
PK_ISN                                  0
ORGANIZATION_ID                         0
RESULT_VALUE_STATUS                     0
RESULT_IS_NUMBER                        0
ORGANIZATION_IS_NUMBER                  0
ACTIVITY_MEDIUM                         0
FK_ACT_MEDIUM                           0
ACTIVITY_ID                             0
ACTIVITY_CATEGORY                       0
ACTIVITY_TYPE                           0
CHARACTERISTIC_GROUP_TYPE            1297
CHARACTERISTIC_NAME                  1297
FK_CHAR                              1297
RESULT_VALUE_TEXT                   12718
ACTIVITY_START_DATE_TIME           151412
ACTIVITY_ISN                       151412
ACTIVITY_IS_NUMBER                 151412
STATION_ID                         157105
VISIT_START_DATE_TIME              157105
STATION_VISIT_ID                   157105
TRIP_ID                            157105
FK_DATE_ACT_START                  165034
FK_STN_ACT_PT                      217992
FK_STATN_TYPES                     235795
STN_LONGITUDE                      235795
STN_STD_LONGITUDE                  235795
FK_STATION                         235795
FK_ORG                             235795
STN_STD_LATITUDE                   235795
STN_LATITUDE                       235795
LOCATION_POINT_TYPE                294525
POINT_SEQUENCE_NUMBER              294525
ACTIVITY_LONGITUDE                 294525
ACT_STD_LONGITUDE                  294525
ACT_STD_LATITUDE                   294525
ACTIVITY_LATITUDE                  294525
STN_HDATUM                         311571
STN_STD_HDATUM                     311571
FK_ACT_MAD_HMETHOD                 369657
ACT_STD_HDATUM                     370297
FK_ACT_MAD_HDATUM                  370297
SGO_INDICATOR                      657102
STATION_NAME                      1276406
RESULT_VALUE_TYPE                 1887183
PROJECT_ID                        2180732
GENERATED_HUC                     6030333
FK_GEO_STATE                      7193797
FK_GEO_COUNTY                     7210968
REPLICATE_NUMBER                  7723252
RESULT_VALUE                      7736397
ANALYTICAL_PROCEDURE_SOURCE       8853450
ANALYTICAL_PROCEDURE_ID           8853450
RESULT_UNIT                       9154548
FK_UNIT_CONVERSION                9154548
STD_UNIT                          9154548
STD_VALUE                         9566848
LAB_CERTIFIED                    10753671
DILUTION_INDICATOR               12073463
RECOVERY_INDICATOR               12255920
CORRECTION_INDICATOR             12255920
REPLICATE_ANALYSIS_COUNT         12332404
ACT_START_TIME_ZONE              16914119
FIELD_PROCEDURE_ID               19340531
HYDROLOGIC_UNIT_CODE             20952121
FK_DB_CAT                        20952121
FK_GEN_DB_CAT                    20952121
TRIP_NAME                        22429498
SAMPLE_FRACTION_TYPE             23188842
ACTIVITY_DEPTH_UNIT              30039462
ACTIVITY_DEPTH                   30840906
MAP_SCALE                        33709534
CONTAINER_DESC                   37766150
LAB_ID                           38418776
LAB_NAME                         38418776
FK_ACT_MATRIX                    41177691
ACTIVITY_MATRIX                  41177691
FIELD_GEAR_ID                    43253164
DETECTION_LIMIT                  46035885
CAS_NUMBER                       46053680
ANALYSIS_DATE_TIME               46860231
DURATION_BASIS                   47365570
ACTIVITY_INTENT                  47600354
WEIGHT_BASIS_TYPE                47970783
TEMPERATURE_BASIS_LEVEL          48417987
CONF_LVL_CORR_BIAS               48554832
STATISTIC_TYPE                   48899239
LAB_BATCH_ID                     49972224
TEMP_PRESERVN_TYPE               51216909
ACTIVITY_REL_DEPTH               51245753
ACTIVITY_COMMENT                 51609616
RESULT_COMMENT                   51674522
ANALYSIS_TIME_ZONE               53871905
POINT_NAME                       53886067
ACT_STOP_TIME_ZONE               55749678
GEAR_CONFIG_ID                   56034960
PRESRV_STRGE_PRCDR               56194079
ACTIVITY_DEPTH_REF_POINT         56754117
LOWER_QUANTITATION_LIMIT         56771444
VISIT_START_TIME_ZONE            57999479
FIELD_SET                        59007758
ACTIVITY_STOP_DATE_TIME          59146380
ACTIVITY_UPPER_DEPTH             60141680
ACTIVITY_LOWER_DEPTH             60166241
VISIT_STOP_TIME_ZONE             60409418
PRECISION                        60860339
CONFIDENCE_LEVEL                 60863832
DISTANCE_MEASURE_FROM            60869580
DISTANCE_MEASURE_TO              60869580
UPR_LWR_DEPTH_UNIT               61768438
DETECTION_LIMIT_DESCRIPTION      61821042
BIAS                             62270058
UPPER_QUANTITATION_LIMIT         62643919
VISIT_STOP_DATE_TIME             62731659
ACTIVITY_COND_ORG_TEXT           62762641
ITIS_NUMBER                      62922961
WELL_NUMBER                      62954953
PORTABLE_DATA_LOGGER             63001127
ACTIVITY_MEAS_QUAL_CODE          63053803
LAB_REMARK                       63149438
PARTICLE_SIZE                    63171370
ACT_BLOB_TITLE                   63216842
ACT_BLOB_ID                      63219250
TEXT_RESULT                      63219976
BLOB_ID                          63223313
BLOB_TITLE                       63223313
PIPE_NUMBER                      63223359
EPA_REG_NUMBER                   63223366
RESULT_DEPTH_MEAS_VALUE          63223366
RESULT_DEPTH_ALT_REF_PT_TXT      63223366
RESULT_DEPTH_MEAS_UNIT_CODE      63223366
TRIBAL_WATER_QUALITY_MEASURE     63223366
ANALYTICAL_METHOD_LIST_AGENCY
ANALYTICAL_METHOD_LIST_VER
SMPRP_TRANSPORT_STORAGE_DESC
SOURCE_SYSTEM
SOURCE_UID
ETL_ID

biological result table column names and null counts

COLUMN_NAME                     NUM_NULLS
------------------------------ ----------
PK_ISN                                  0
ORGANIZATION_ID                         0
ORGANIZATION_IS_NUMBER                  0
ACTIVITY_MEDIUM                         0
ACTIVITY_START_DATE_TIME                0
TR_START_DEPTH                          0
RESULT_VALUE_STATUS                     0
RESULT_IS_NUMBER                        0
FK_DATE_ACT_START                       0
FK_ACT_MEDIUM                           0
ACTIVITY_ISN                            0
ACTIVITY_IS_NUMBER                      0
TR_STOP_DEPTH                           0
RESULT_VALUE_TEXT                       0
ACTIVITY_ID                             0
ACTIVITY_TYPE                           0
ACTIVITY_CATEGORY                       0
LOCATION_POINT_TYPE                     3
FK_ACT_MAD_HMETHOD                      3
ACT_STD_LONGITUDE                       3
ACT_STD_LATITUDE                        3
ACTIVITY_LONGITUDE                      3
ACTIVITY_LATITUDE                       3
POINT_SEQUENCE_NUMBER                   3
FK_CHAR                               252
CHARACTERISTIC_GROUP_TYPE             256
CHARACTERISTIC_NAME                   256
ACTIVITY_INTENT                       495
FK_ACT_INTENT                         495
FIELD_PROCEDURE_ID                   3315
ACT_STD_HDATUM                       3318
FK_ACT_MAD_HDATUM                    3318
RESULT_VALUE_TYPE                   10790
STATION_ID                          21830
STN_LONGITUDE                       21830
STN_STD_LONGITUDE                   21830
STN_STD_LATITUDE                    21830
SGO_INDICATOR                       21830
VISIT_START_DATE_TIME               21830
FK_STATN_TYPES                      21830
FK_STN_ACT_PT                       21830
FK_STATION                          21830
FK_ORG                              21830
TRIP_ID                             21830
STATION_VISIT_ID                    21830
STN_LATITUDE                        21830
STATION_NAME                        22379
STN_HDATUM                          25148
STN_STD_HDATUM                      25148
DILUTION_INDICATOR                  41398
RECOVERY_INDICATOR                  41893
LAB_CERTIFIED                       41893
CORRECTION_INDICATOR                41893
REPLICATE_NUMBER                    44196
REPLICATE_ANALYSIS_COUNT            44622
RESULT_VALUE                        99529
RESULT_UNIT                        105152
STD_UNIT                           105152
STD_VALUE                          108058
FK_UNIT_CONVERSION                 225531
TSRUOM_ORG_ID                      225531
FIELD_GEAR_ID                      322247
PROJECT_ID                         425045
TRIP_NAME                          508164
ACTIVITY_COMMUNITY                 583031
BIO_GROUP_TYPE                     583031
FK_GROUP_TYPE                      583031
FK_COMMUNITY_SAMPLED               583031
BIO_GROUP_ID                       583031
NUMBER_IN_GROUP                    627316
RESULT_COMMENT                     658928
FEEDING_GROUP                      769195
ITIS_NUMBER                        770283
POLLUTION_TOLERANCE                778307
STATISTIC_TYPE                     905346
MAP_SCALE                          911755
TROPHIC_LEVEL                      922997
WEIGHT_BASIS_TYPE                  937675
TEMPERATURE_BASIS_LEVEL            963406
DURATION_BASIS                     963406
GEAR_CONFIG_ID                     997366
LAB_ID                            1038421
LAB_NAME                          1038421
FK_GEO_STATE                      1050319
FK_GEO_COUNTY                     1050393
GENERATED_HUC                     1211771
HYDROLOGIC_UNIT_CODE              1324040
FK_GEN_DB_CAT                     1324040
FK_DB_CAT                         1324040
ANALYTICAL_PROCEDURE_SOURCE       1654269
ANALYTICAL_PROCEDURE_ID           1654269
POINT_NAME                        1766613
ACTIVITY_COMMENT                  1768680
ACTIVITY_SUBJECT_TAXON            1778160
FK_SUBJECT_TAXON                  1778160
ACT_START_TIME_ZONE               1880766
CONTAINER_DESC                    1891471
SAMPLE_FRACTION_TYPE              1941770
ACTIVITY_REL_DEPTH                2033987
ACTIVITY_DEPTH_REF_POINT          2056629
BIOPART_NAME                      2099355
FK_BIOPART                        2099355
PHYS_BIO_INDICATOR                2099744
BIO_GROUP_DESCRIPTION             2127302
CAS_NUMBER                        2130945
VISIT_START_TIME_ZONE             2136041
VISIT_STOP_TIME_ZONE              2167110
BIO_GROUP_COUNT_TYPE              2170972
PRESRV_STRGE_PRCDR                2173008
BIO_GROUP_SUBJECT_TXN             2179477
LAB_BATCH_ID                      2182399
ACTIVITY_DEPTH_UNIT               2183439
TEMP_PRESERVN_TYPE                2190263
ACTIVITY_DEPTH                    2203550
PRECISION                         2204437
DISTANCE_MEASURE_FROM             2205089
CONFIDENCE_LEVEL                  2205089
DISTANCE_MEASURE_TO               2205089
GROUP_DESC_LIFESTAGE              2225079
GROUP_DESC_SEX                    2225232
LOWER_BOUND_AMOUNT                2234966
BIO_RCI_UNITS                     2234966
UPPER_BOUND_AMOUNT                2234966
ANALYSIS_TIME_ZONE                2238818
PRIMARY_CLASS_DESC                2240075
ACT_STOP_TIME_ZONE                2240518
DETECTION_LIMIT                   2253629
FIELD_SET                         2274716
HABIT                             2280366
ACTIVITY_STOP_DATE_TIME           2292708
CONF_LVL_CORR_BIAS                2306878
UPR_LWR_DEPTH_UNIT                2310978
BIAS                              2318481
DETECTION_LIMIT_DESCRIPTION       2323702
PARTICLE_SIZE                     2329678
LOWER_QUANTITATION_LIMIT          2337976
UPPER_QUANTITATION_LIMIT          2338002
VISIT_STOP_DATE_TIME              2338010
ANALYSIS_DATE_TIME                2338075
CELL_FORM                         2342594
CELL_SHAPE                        2345449
ACTIVITY_COND_ORG_TEXT            2351735
COMMON_CLASS_DESC                 2355345
SECONDARY_CLASS_DESC              2355666
REL_CURRENT_DIR                   2356011
REL_WIND_DIR                      2356011
FISHED_DURATION                   2356109
FISHED_DISTANCE                   2356109
BOAT_SPEED                        2356109
TRAWL_COMMENT                     2357528
TR_START_POINT_NAME               2359229
TR_START_LONGITUDE                2359229
TR_START_LATITUDE                 2359229
TR_START_HDATUM                   2359229
TR_STOP_STD_LONGITUDE             2359229
TR_STOP_STD_LATITUDE              2359229
TR_STOP_HDATUM                    2359229
TR_STOP_LONGITUDE                 2359229
TR_STOP_LATITUDE                  2359229
TR_STOP_POINT_NAME                2359229
TR_START_STD_HDATUM               2359229
TR_START_STD_LONGITUDE            2359229
TR_START_STD_LATITUDE             2359229
TR_STOP_STD_HDATUM                2359229
VOLTAGE_MEASURE                   2359592
AMPERAGE_MEASURE                  2359592
PASS_LENGTH                       2359592
TOTAL_ENERGZD_TIME                2359592
CURRENT_TYPE_CODE                 2359592
INDIVIDUAL_NUMBER                 2359832
PULSE_RATE                        2359893
ELECTROSHOCK_COMMENT              2359893
SAMPLING_DURATION                 2359980
TRAP_NET_COMMENT                  2359980
PASS_COUNT                        2360097
ACT_BLOB_TITLE                    2360204
ACTIVITY_UPPER_DEPTH              2360237
ACTIVITY_LOWER_DEPTH              2360237
ORIENTATION_TO_CURRENT            2360392
LAB_REMARK                        2360439
ACT_BLOB_ID                       2360463
WELL_NUMBER                       2360490
ACTIVITY_MEAS_QUAL_CODE           2360490
RESULT_DEPTH_ALT_REF_PT_TXT       2360490
RESULT_DEPTH_MEAS_UNIT_CODE       2360490
RESULT_DEPTH_MEAS_VALUE           2360490
TRIBAL_WATER_QUALITY_MEASURE      2360490
BLOB_TITLE                        2360490
BLOB_ID                           2360490
TEXT_RESULT                       2360490
PIPE_NUMBER                       2360490
VOLTINISM                         2360490
EPA_REG_NUMBER                    2360490
ANALYTICAL_METHOD_LIST_AGENCY
ANALYTICAL_METHOD_LIST_VER
SMPRP_TRANSPORT_STORAGE_DESC
SOURCE_SYSTEM

COLUMN_NAME                     NUM_NULLS
------------------------------ ----------
SOURCE_UID
ETL_ID

habitat result table column names and null counts

COLUMN_NAME                     NUM_NULLS
------------------------------ ----------
PK_ISN                                  0
ORGANIZATION_ID                         0
ORGANIZATION_IS_NUMBER                  0
STATION_ID                              0
ACTIVITY_START_DATE_TIME                0
TRIP_ID                                 0
CHARACTERISTIC_GROUP_TYPE               0
CHARACTERISTIC_NAME                     0
STATION_VISIT_ID                        0
STN_STD_LATITUDE                        0
STN_HDATUM                              0
STN_LONGITUDE                           0
STN_LATITUDE                            0
CORRECTION_INDICATOR                    0
RECOVERY_INDICATOR                      0
DILUTION_INDICATOR                      0
REPLICATE_ANALYSIS_COUNT                0
LAB_CERTIFIED                           0
VISIT_START_DATE_TIME                   0
ACTIVITY_ISN                            0
FK_ACT_MAD_HMETHOD                      0
FK_ACT_MAD_HDATUM                       0
ACT_STD_HDATUM                          0
ACT_STD_LONGITUDE                       0
ACT_STD_LATITUDE                        0
ACTIVITY_LONGITUDE                      0
ACTIVITY_LATITUDE                       0
FK_STATN_TYPES                          0
FK_STN_ACT_PT                           0
SGO_INDICATOR                           0
POINT_SEQUENCE_NUMBER                   0
LOCATION_POINT_TYPE                     0
ACTIVITY_CATEGORY                       0
ACTIVITY_TYPE                           0
REPLICATE_NUMBER                        0
ACTIVITY_ID                             0
ACTIVITY_IS_NUMBER                      0
FK_DATE_ACT_START                       0
FK_ORG                                  0
FK_STATION                              0
RESULT_IS_NUMBER                        0
STN_STD_HDATUM                          0
STN_STD_LONGITUDE                       0
RESULT_VALUE_STATUS                     0
RESULT_VALUE_TEXT                       0
RESULT_VALUE                          717
FK_GEO_COUNTY                        1451
FK_GEO_STATE                         1451
STATION_NAME                         2985
PROJECT_ID                           3196
HABITAT_CLASS_NAME                  53062
GENERATED_HUC                       60769
HYDROLOGIC_UNIT_CODE                76980
FK_GEN_DB_CAT                       76980
FK_DB_CAT                           76980
POINT_NAME                        1604267
ACTIVITY_COMMENT                  6482403
WEIGHT_BASIS_TYPE                 6730586
FK_CHAR                           6737015
TRIP_NAME                         6738793
MAP_SCALE                         6743884
RESULT_VALUE_TYPE                 6761311
TEMPERATURE_BASIS_LEVEL           6765593
DURATION_BASIS                    6765593
STATISTIC_TYPE                    6766329
ACT_START_TIME_ZONE               6768604
VISIT_START_TIME_ZONE             6772312
VISIT_STOP_TIME_ZONE              6774054
RESULT_UNIT                       6778190
STD_UNIT                          6778190
STD_VALUE                         6778190
FK_UNIT_CONVERSION                6778190
SAMPLE_FRACTION_TYPE              6778894
ACT_STOP_TIME_ZONE                6779629
LAB_BATCH_ID                      6779695
ANALYSIS_TIME_ZONE                6779695
CONFIDENCE_LEVEL                  6779695
PRECISION                         6779695
DISTANCE_MEASURE_TO               6779695
DISTANCE_MEASURE_FROM             6779695
FIELD_SET                         6781585
CONF_LVL_CORR_BIAS                6782873
ANALYTICAL_PROCEDURE_SOURCE       6782959
ANALYTICAL_PROCEDURE_ID           6782959
BIAS                              6783979
BLOB_TITLE                        6786807
ACT_BLOB_TITLE                    6787614
ACT_BLOB_ID                       6787615
VISIT_STOP_DATE_TIME              6787816
ACTIVITY_STOP_DATE_TIME           6788214
RESULT_COMMENT                    6789357
LAB_ID                            6789537
LAB_NAME                          6789537
UPPER_QUANTITATION_LIMIT          6789537
DETECTION_LIMIT_DESCRIPTION       6789537
DETECTION_LIMIT                   6789537
LOWER_QUANTITATION_LIMIT          6789537
BLOB_ID                           6789966
TEXT_RESULT                       6790075
EPA_REG_NUMBER                    6790077
ACTIVITY_MEAS_QUAL_CODE           6790077
RESULT_DEPTH_MEAS_VALUE           6790077
RESULT_DEPTH_ALT_REF_PT_TXT       6790077
RESULT_DEPTH_MEAS_UNIT_CODE       6790077
ACTIVITY_COND_ORG_TEXT            6790077
TRIBAL_WATER_QUALITY_MEASURE      6790077
PIPE_NUMBER                       6790077
WELL_NUMBER                       6790077
LAB_REMARK                        6790077
ANALYSIS_DATE_TIME                6790077
ETL_ID

station table column names and null counts

COLUMN_NAME                     NUM_NULLS
------------------------------ ----------
STD_LATITUDE                            0
STD_LONGITUDE                           0
FK_STATN_TYPES                          0
FK_PRIMARY_TYPE                         0
STATION_ID                              0
LOCATION_POINT_TYPE                     0
LATITUDE                                0
RF1_SEGMENT_CODE                        0
NRCS_WATERSHED_ID                       0
TSMALP_IS_NUMBER                        0
SPRING_USGS_LITHOLOGIC_UNIT             0
SPRING_USGS_GEOLOGIC_UNIT               0
STATION_GROUP_TYPE                      0
ORGANIZATION_IS_NUMBER                  0
STATION_IS_NUMBER                       0
NATV_AMERICAN_LAND_NAME                 0
RF1_SEGMENT_NAME                        0
LONGITUDE                               0
POINT_SEQUENCE_NUMBER                   0
ORGANIZATION_ID                         0
PK_ISN                                  0
FK_ORG                                  0
FK_MAD_HDATUM                         163
FK_STD_HDATUM                         163
FK_HORIZONTAL_DATUM                   163
FK_MAD_HMETHOD                       1399
FK_GEOPOSITIONING_METHOD             1399
SGO_INDICATOR                        2950
ON_REACH_IND                        17831
STATION_NAME                        22725
GENERATED_HUC                       29664
RF1_MILEAGE                         64752
FK_GEO_STATE                        65538
FK_COUNTRY_CODE                     65538
FK_STATE_POSTAL_CODE                65538
FK_GEO_COUNTY                       65828
ELEVATION                           70277
DESCRIPTION_TEXT                    80368
FK_DB_CAT                          214905
HYDROLOGIC_UNIT_CODE               214905
FK_GEN_DB_CAT                      214905
FRS_KEY_IDENTIFIER                 264472
STATION_VISITED                    300166
ELEV_UNITS                         302504
MAP_SCALE                          305401
POINT_NAME                         320383
FK_MAD_VDATUM                      326180
FK_ELEVATION_DATUM                 326180
FK_MAD_VMETHOD                     326286
FK_ELEVATION_METHOD                326286
FK_ESTRY_PRIMARY                   371310
FK_PRIMARY_ESTUARY                 371310
BLOB_TITLE                         386491
OTHER_ESTUARY_NAME                 386872
OCEAN_NAME                         388919
BLOB_ID                            396816
FK_ESTRY_SECONDARY                 396829
FK_SECONDARY_ESTUARY               396829
WELL_NUMBER                        396980
WELL_NAME                          396980
GREAT_LAKE_NAME                    397523
PIPE_NUMBER                        397526
NAICS_CODE                         397709
SPRING_TYPE_IMPROVEMENT            397710
SPRING_PERMANENCE                  397710
SPRING_OTHER_NAME                  397710
FK_SECONDARY_TYPE                  397713
PROJECT_ID                         397713
TRIBAL_WATER_QUALITY_MEASURE       397713
HORIZONTAL_ACCURACY                397713
SOURCE_SYSTEM
SOURCE_UID

table names and indexes

TABLE_NAME                     INDEX_NAME
------------------------------ ------------------------------
APP_COLUMN_NAME                PK_APP_COL
BIOLOGICAL_RESULT_PROJECT      IBP_FK_PROJECT
BIOLOGICAL_RESULT_PROJECT      IBP_FK_PROJECT_RESULT
BIOLOGICAL_RESULT_PROJECT      IBP_FK_RESULT
CHARACTERISTIC_CHARTYPE        CPK_CHAR_CHARTYPE
CHARACTERISTIC_CHARTYPE        I_CCTYPE_FK_CHAR
CHARACTERISTIC_CHARTYPE        I_CCTYPE_FK_CHARTYPE
CHARACTERISTIC_CHARTYPE        UICCT01
DI_ACTIVITY_INTENT             PK_ACTIVITY_INTENT
DI_ACTIVITY_MATRIX             PK_DI_ACTIVITY_MATRIX
DI_ACTIVITY_MEDIUM             IACT_MEDIUM01
DI_ACTIVITY_MEDIUM             PK_ACT_MEDIUM
DI_BIOPART                     PK_BIOPART
DI_CHARACTERISTIC              ICHAR011
DI_CHARACTERISTIC              ICHAR012
DI_CHARACTERISTIC              PK_CHAR1
DI_COMMUNITY_SAMPLED           PK_COMMUNITY_SAMPLED
DI_DATE                        IDATE_FULL_DATE
DI_DATE                        PK_DATE
DI_DB_CAT                      DB_CAT02
DI_DB_CAT                      PK_DB_CAT
DI_GEO_COUNTY                  DB_COUNTY01
DI_GEO_COUNTY                  DB_COUNTY02
DI_GEO_COUNTY                  PK_GEO_COUNTY
DI_GEO_STATE                   GEO_STATE02
DI_GEO_STATE                   GEO_STATE03
DI_GEO_STATE                   GEO_STATE04
DI_GEO_STATE                   PK_GEO_STATE
DI_GROUP_TYPE                  PK_GROUP_TYPE
DI_ORG                         IORGTEMP1
DI_ORG                         PK_ORG
DI_PROJECT                     IPR_ISN_ORGID
DI_PROJECT                     I_DI_PROJECT_SOURCEUID
DI_PROJECT                     PK_PROJECT
DI_STATN_TYPES                 ISTATN_TYPE01
DI_STATN_TYPES                 ISTATN_TYPE02
DI_STATN_TYPES                 PK_STATN_TYPES
DI_SUBJECT_TAXON               PK_SUBJECT_TAXON
DW_DATA_REQUESTS               I_DW_DR_DATETIME
DW_DATA_REQUESTS               PK_DW_DATA_REQUESTS
FA_BIOLOGICAL_RESULT           FA_BIO_RES_SOURCE_SYSTEM
FA_BIOLOGICAL_RESULT           IBR_ACTIVITY_ISN
FA_BIOLOGICAL_RESULT           IBR_ACT_IS_NUM_ORG_ID
FA_BIOLOGICAL_RESULT           IBR_CHAR_DATE_LAT_LONG
FA_BIOLOGICAL_RESULT           IBR_COMMUNITY
FA_BIOLOGICAL_RESULT           IBR_COUNTY_DATE_CHAR
FA_BIOLOGICAL_RESULT           IBR_DATE
FA_BIOLOGICAL_RESULT           IBR_DATE_LAT_LONG
FA_BIOLOGICAL_RESULT           IBR_DB_CAT
FA_BIOLOGICAL_RESULT           IBR_GEN_DB_CAT
FA_BIOLOGICAL_RESULT           IBR_GEO1
FA_BIOLOGICAL_RESULT           IBR_GEO2
FA_BIOLOGICAL_RESULT           IBR_HUC
FA_BIOLOGICAL_RESULT           IBR_HUC_DATE_CHAR
FA_BIOLOGICAL_RESULT           IBR_INTENT
FA_BIOLOGICAL_RESULT           IBR_LAT_LONG
FA_BIOLOGICAL_RESULT           IBR_LBRMK_01
FA_BIOLOGICAL_RESULT           IBR_OID
FA_BIOLOGICAL_RESULT           IBR_ORG1
FA_BIOLOGICAL_RESULT           IBR_PK_CHAR
FA_BIOLOGICAL_RESULT           IBR_PK_DATE_CHAR
FA_BIOLOGICAL_RESULT           IBR_STATE_DATE_CHAR
FA_BIOLOGICAL_RESULT           IBR_STATION
FA_BIOLOGICAL_RESULT           IBR_STATN_TYPES
FA_BIOLOGICAL_RESULT           IBR_STN_ACT_PT
FA_BIOLOGICAL_RESULT           I_FA_BIO_RESULT_SOURCEUID
FA_BIOLOGICAL_RESULT           PK_BIOLOGICAL_RESULT
FA_BLOB                        SYS_IL0000011968C00003$$
FA_HABITAT_RESULT              IHB_ACITIVTY_ISN
FA_HABITAT_RESULT              IHB_ACT_IS_NUM_ORG_ID
FA_HABITAT_RESULT              IHB_CHAR_DATE_LAT_LONG
FA_HABITAT_RESULT              IHB_COUNTY_DATE_CHAR
FA_HABITAT_RESULT              IHB_DATE
FA_HABITAT_RESULT              IHB_DATE_LAT_LONG
FA_HABITAT_RESULT              IHB_DB_CAT
FA_HABITAT_RESULT              IHB_GEN_DB_CAT
FA_HABITAT_RESULT              IHB_GEO1
FA_HABITAT_RESULT              IHB_GEO2
FA_HABITAT_RESULT              IHB_HUC
FA_HABITAT_RESULT              IHB_HUC_DATE_CHAR
FA_HABITAT_RESULT              IHB_LAT_LONG
FA_HABITAT_RESULT              IHB_OID
FA_HABITAT_RESULT              IHB_ORG1
FA_HABITAT_RESULT              IHB_PK_CHAR
FA_HABITAT_RESULT              IHB_PK_DATE_CHAR
FA_HABITAT_RESULT              IHB_RESULT_LBRMK_01
FA_HABITAT_RESULT              IHB_STATE_DATE_CHAR
FA_HABITAT_RESULT              IHB_STATION
FA_HABITAT_RESULT              IHB_STATN_TYPES
FA_HABITAT_RESULT              IHB_STN_ACT_PT
FA_HABITAT_RESULT              PK_HABITAT_RESULT
FA_REGULAR_RESULT              FA_REG_RES_SOURCE_SYSTEM
FA_REGULAR_RESULT              IFA_RESULT_LBRMK_01
FA_REGULAR_RESULT              IRE_ACITIVTY_ISN
FA_REGULAR_RESULT              IRE_ACTBLOB
FA_REGULAR_RESULT              IRE_ACT_IS_NUM_ORG_ID
FA_REGULAR_RESULT              IRE_BLOB
FA_REGULAR_RESULT              IRE_CHAR_DATE_LAT_LONG_MEDIUM
FA_REGULAR_RESULT              IRE_COUNTY_DATE_CHAR_MEDIUM
FA_REGULAR_RESULT              IRE_DATE
FA_REGULAR_RESULT              IRE_DATE_LAT_LONG_MEDIUM
FA_REGULAR_RESULT              IRE_DB_CAT
FA_REGULAR_RESULT              IRE_FK_ACT_MEDIUM
FA_REGULAR_RESULT              IRE_GEN_DB_CAT
FA_REGULAR_RESULT              IRE_GEN_HUC
FA_REGULAR_RESULT              IRE_GEO1
FA_REGULAR_RESULT              IRE_GEO2
FA_REGULAR_RESULT              IRE_HUC_DATE_CHAR
FA_REGULAR_RESULT              IRE_LAT_LONG
FA_REGULAR_RESULT              IRE_MEDIUM_LAT_LONG
FA_REGULAR_RESULT              IRE_OID
FA_REGULAR_RESULT              IRE_ORG1
FA_REGULAR_RESULT              IRE_PK_CHAR
FA_REGULAR_RESULT              IRE_PK_DATE_CHAR
FA_REGULAR_RESULT              IRE_STATE_DATE_CHAR_MEDIUM
FA_REGULAR_RESULT              IRE_STATION
FA_REGULAR_RESULT              IRE_STATN_TYPES
FA_REGULAR_RESULT              IRE_STN_ACT_PT
FA_REGULAR_RESULT              I_FA_REG_RESULT_SOURCEUID
FA_REGULAR_RESULT              PK_REGULAR_RESULT
FA_STATION                     ISD_DB4
FA_STATION                     ISD_FK_ESTRY_PRIMARY
FA_STATION                     ISD_FK_ESTRY_SECONDARY
FA_STATION                     ISD_GEN_DB4
FA_STATION                     ISD_GEO1
FA_STATION                     ISD_GEO2
FA_STATION                     ISD_LOCATION_POINT_TYPE
FA_STATION                     ISD_MAD_HDATUM
FA_STATION                     ISD_MAD_HMETHOD
FA_STATION                     ISD_MAD_VDATUM
FA_STATION                     ISD_MAD_VMETHOD
FA_STATION                     ISD_ORG1
FA_STATION                     ISD_SD_FK_STATN_TYPES
FA_STATION                     ISD_STD_MAD_HDATUM
FA_STATION                     PK_STATION
FA_STATION                     SD_LAT
FA_STATION                     SD_LONG
FA_STATION                     SD_OID
FA_STATION                     SD_OID_ALP
FA_STATION                     SD_OISN
FA_STATION                     SD_SID_OID
FA_STATION                     SD_SISN_OID
FA_STATION                     SD_STD_LAT
FA_STATION                     SD_STD_LONG
HABITAT_RESULT_PROJECT         IHP_FK_PROJECT
HABITAT_RESULT_PROJECT         IHP_FK_PROJECT_RESULT
HABITAT_RESULT_PROJECT         IHP_FK_RESULT
LU_CHARTYPE                    ICHARTYPE01
LU_CHARTYPE                    PK_CHARTYPE
LU_CHAR_ALIAS                  CHAR_ALIAS_ISD_FK_CHAR
LU_CHAR_ALIAS                  CHAR_ALIAS_ISD_FK_CHAR_TYPE
LU_CHAR_ALIAS                  PK_CHAR_ALIAS
LU_CHAR_ALIAS_TYPE             PK_CHAR_ALIAS_TYPE
LU_ESTRY_PRIMARY               IESTRY_PRIMARY01
LU_ESTRY_PRIMARY               PK_ESTRY_PRIMARY
LU_ESTRY_SECONDARY             IESTRY_SECONDARY01
LU_ESTRY_SECONDARY             PK_ESTRY_SECONDARY
LU_EXTERNAL_REF_SCHEME         PK_REF_SCHEME
LU_MAD_HDATUM                  MAD_HDATUM01
LU_MAD_HDATUM                  PK_MAD_HDATUM
LU_MAD_HMETHOD                 MAD_HMETHOD02
LU_MAD_HMETHOD                 PK_MAD_HMETHOD
LU_MAD_VDATUM                  DB_VDATUM01
LU_MAD_VDATUM                  PK_MAD_VDATUM
LU_MAD_VMETHOD                 DB_VMETHOD01
LU_MAD_VMETHOD                 PK_MAD_VMETHOD
LU_STATION_ALIAS               PK_STATION_ALIAS
LU_STATION_ALIAS               STATN_ALIAS_ISD_FK_REF_SCHEME
LU_STATION_ALIAS               STATN_ALIAS_ISD_FK_STATION
LU_UNIT_CONVERSION             PK_UNIT_CONV
MD_ANALYTICAL_PROC             IANLFK
MD_ANALYTICAL_PROC             IANLORGID
MD_ANALYTICAL_PROC             PK_ANALY_PROC
MD_CITATION                    ICITFK
MD_CITATION                    ICIT_ORG_ID
MD_CITATION                    PK_CITATION
MD_COOP                        ICOFK
MD_COOP                        ICOORGID
MD_COOP                        PK_CO_ORG
MD_COOP_ADDRESS                IACOOP
MD_COOP_ADDRESS                IACOORGID
MD_COOP_ADDRESS                PK_CO_OP_ADDR
MD_COOP_EADDRESS               IECOOP
MD_COOP_EADDRESS               IECOORGID
MD_COOP_EADDRESS               PK_CO_ORG_EADDR
MD_LAB                         ILABFK
MD_LAB                         LAB_ORGID
MD_LAB                         LAB_ORG_NO
MD_LAB                         PK_LAB
MD_LAB_ADDRESS                 IALAB
MD_LAB_ADDRESS                 IALBORGID
MD_LAB_ADDRESS                 PK_LAB_ADDR
MD_LAB_EADDRESS                IELAB
MD_LAB_EADDRESS                IELBORGID
MD_LAB_EADDRESS                PK_LAB_EADDR
MD_LAB_SAMPLE_PREP_PROCEDURE   ILSPPFK
MD_LAB_SAMPLE_PREP_PROCEDURE   ILSPPORGID

TABLE_NAME                     INDEX_NAME
------------------------------ ------------------------------
MD_LAB_SAMPLE_PREP_PROCEDURE   PK_LAB_SPP
MD_ORG_ADDRESS                 IAORG
MD_ORG_ADDRESS                 IORGID
MD_ORG_ADDRESS                 PK_ORG_ADDR
MD_ORG_EADDRESS                IEORG
MD_ORG_EADDRESS                IEORGID
MD_ORG_EADDRESS                PK_ORG_EADDR
MD_PROGRAM                     IPRGORGID
MD_PROGRAM                     IPROFK
MD_PROGRAM                     PK_PROGRAM
MD_SAMPLE_GEAR                 ISGFK
MD_SAMPLE_GEAR                 ISGORGID
MD_SAMPLE_GEAR                 PK_SAMPLE_GEAR
MD_SAMPLE_PRESRV               ISPPFK
MD_SAMPLE_PRESRV               ISPPORGID
MD_SAMPLE_PRESRV               PK_SAMPLE_PRESRV
MD_SAMPLE_PROC                 ISAMPROC_ORG_ID
MD_SAMPLE_PROC                 ISPFK
MD_SAMPLE_PROC                 PK_SAMPLE_PROC
MT_ATTRIBUTE_MAP               I_MT_ATTR_02
MT_ATTRIBUTE_MAP               PK_MT_ATTR_MAP
MT_CHAR_CHARTYPE               I_MT_CHAR_CHARTYPE
MT_WH_CONFIG                   PK_MT_WH_CONFIG
REGULAR_RESULT_PROJECT         IRP_FK_PROJECT
REGULAR_RESULT_PROJECT         IRP_FK_PROJECT_RESULT
REGULAR_RESULT_PROJECT         IRP_FK_RESULT
STATION_CHAR                   ICS_CHAR_TYPE_CODE
STATION_CHAR                   ICS_FK_CHAR
STATION_CHAR                   ICS_FK_CHAR_FK_FA_STATN
STATION_CHAR                   ICS_FK_FA_STATN
STATION_CHAR                   ICS_SEARCH_NAME
STATION_PROJECT                ISP_FK_FA_STATN
STATION_PROJECT                ISP_FK_PROJECT
STATION_PROJECT                ISP_ORGANIZATION_ID
STATION_PROJECT                ISP_STATION_ID
WS_HUC_CHAR_SUMMARY            IWS_HC_HUC
WS_HUC_CHAR_SUMMARY            IWS_HC_HUC_CHARTYPEID
WS_HUC_CHAR_SUMMARY            PK_WS_HUC_CHAR_SUMMARY
WS_HUC_ORG_CHAR_SUMMARY        IWS_HOC_HUC
WS_HUC_ORG_CHAR_SUMMARY        IWS_HOC_HUC_ORGID_CHARTYPEID
WS_HUC_ORG_CHAR_SUMMARY        PK_WS_HUC_ORG_CHAR_SUMMARY
WS_HUC_ORG_SUMMARY             IWS_HO_HUC
WS_HUC_ORG_SUMMARY             IWS_HO_HUC_ORGID
WS_HUC_ORG_SUMMARY             PK_WS_HUC_ORG_SUMMARY
WS_STATION_DATA                IWS_WST_CHAR_ID
WS_STATION_DATA                IWS_WST_HUC
WS_STATION_DATA                IWS_WST_HUC_ORG_STATN
WS_STATION_SUMMARY             IWS_SS_CHARTYPE_STATION_ORG
WS_STATION_SUMMARY             IWS_SS_HUC
WS_STATION_SUMMARY             IWS_SS_HUC_ORG_ID
WS_STATION_SUMMARY             IWS_SS_UNIQUE_STATION_ID

table names and constraints

TABLE_NAME                     CONSTRAINT_NAME                C
------------------------------ ------------------------------ -
APP_COLUMN_NAME                PK_APP_COL                     P
BIOLOGICAL_RESULT_PROJECT      BI_PROJ_FK_PROJECT             R
BIOLOGICAL_RESULT_PROJECT      BI_PROJ_FK_RESULT              R
CHARACTERISTIC_CHARTYPE        CFK_CHARTYPE                   R
CHARACTERISTIC_CHARTYPE        CPK_CHAR_CHARTYPE              P
CHARACTERISTIC_CHARTYPE        SYS_C005511                    C
CHARACTERISTIC_CHARTYPE        SYS_C005512                    C
DI_ACTIVITY_INTENT             PK_ACTIVITY_INTENT             P
DI_ACTIVITY_INTENT             SYS_C005673                    C
DI_ACTIVITY_INTENT             SYS_C005674                    C
DI_ACTIVITY_MATRIX             PK_DI_ACTIVITY_MATRIX          P
DI_ACTIVITY_MEDIUM             PK_ACT_MEDIUM                  P
DI_BIOPART                     PK_BIOPART                     P
DI_BIOPART                     SYS_C005685                    C
DI_BIOPART                     SYS_C005686                    C
DI_CHARACTERISTIC              PK_CHAR1                       P
DI_CHARACTERISTIC              SYS_C005573                    C
DI_CHARACTERISTIC              SYS_C005577                    C
DI_COMMUNITY_SAMPLED           PK_COMMUNITY_SAMPLED           P
DI_COMMUNITY_SAMPLED           SYS_C005676                    C
DI_COMMUNITY_SAMPLED           SYS_C005677                    C
DI_DATE                        PK_DATE                        P
DI_DATE                        SYS_C005558                    C
DI_DB_CAT                      PK_DB_CAT                      P
DI_DB_CAT                      SYS_C005524                    C
DI_GEO_COUNTY                  FK_GEO_COUNTY01                R
DI_GEO_COUNTY                  PK_GEO_COUNTY                  P
DI_GEO_STATE                   PK_GEO_STATE                   P
DI_GEO_STATE                   SYS_C005528                    C
DI_GROUP_TYPE                  PK_GROUP_TYPE                  P
DI_GROUP_TYPE                  SYS_C005682                    C
DI_GROUP_TYPE                  SYS_C005683                    C
DI_ORG                         PK_ORG                         P
DI_ORG                         SYS_C005547                    C
DI_ORG                         SYS_C005548                    C
DI_PROJECT                     PK_PROJECT                     P
DI_PROJECT                     SYS_C005645                    C
DI_PROJECT                     SYS_C005646                    C
DI_PROJECT                     SYS_C005647                    C
DI_PROJECT                     SYS_C005648                    C
DI_STATN_TYPES                 PK_STATN_TYPES                 P
DI_STATN_TYPES                 SYS_C005551                    C
DI_SUBJECT_TAXON               PK_SUBJECT_TAXON               P
DI_SUBJECT_TAXON               SYS_C005679                    C
DI_SUBJECT_TAXON               SYS_C005680                    C
DW_DATA_REQUESTS               PK_DW_DATA_REQUESTS            P
FA_BIOLOGICAL_RESULT           BR_FK_ACTIVITY_INTENT          R
FA_BIOLOGICAL_RESULT           BR_FK_ACT_MAD_HDATUM           R
FA_BIOLOGICAL_RESULT           BR_FK_ACT_MAD_HMETHOD          R
FA_BIOLOGICAL_RESULT           BR_FK_ACT_MEDIUM               R
FA_BIOLOGICAL_RESULT           BR_FK_BIOPART                  R
FA_BIOLOGICAL_RESULT           BR_FK_COMMUNITY_SAMPLED        R
FA_BIOLOGICAL_RESULT           BR_FK_DATE_ACT_START           R
FA_BIOLOGICAL_RESULT           BR_FK_GROUP_TYPE               R
FA_BIOLOGICAL_RESULT           BR_FK_SD_DB_CAT                R
FA_BIOLOGICAL_RESULT           BR_FK_SD_GEN_DB_CAT            R
FA_BIOLOGICAL_RESULT           BR_FK_SD_GEO_COUNTY            R
FA_BIOLOGICAL_RESULT           BR_FK_SD_GEO_STATE             R
FA_BIOLOGICAL_RESULT           BR_FK_SD_ORG                   R
FA_BIOLOGICAL_RESULT           BR_FK_STATION                  R
FA_BIOLOGICAL_RESULT           BR_FK_STATN_TYPES              R
FA_BIOLOGICAL_RESULT           BR_FK_STN_ACT_PT               R
FA_BIOLOGICAL_RESULT           PK_BIOLOGICAL_RESULT           P
FA_BIOLOGICAL_RESULT           SYS_C005605                    C
FA_BLOB                        SYS_C005689                    C
FA_BLOB                        SYS_C005690                    C
FA_BLOB                        SYS_C005691                    C
FA_BLOB                        SYS_C005692                    C
FA_HABITAT_RESULT              HB_FK_ACT_MAD_HDATUM           R
FA_HABITAT_RESULT              HB_FK_ACT_MAD_HMETHOD          R
FA_HABITAT_RESULT              HB_FK_CHAR                     R
FA_HABITAT_RESULT              HB_FK_DATE_ACT_START           R
FA_HABITAT_RESULT              HB_FK_SD_DB_CAT                R
FA_HABITAT_RESULT              HB_FK_SD_GEN_DB_CAT            R
FA_HABITAT_RESULT              HB_FK_SD_GEO_COUNTY            R
FA_HABITAT_RESULT              HB_FK_SD_GEO_STATE             R
FA_HABITAT_RESULT              HB_FK_SD_ORG                   R
FA_HABITAT_RESULT              HB_FK_STATION                  R
FA_HABITAT_RESULT              HB_FK_STATN_TYPES              R
FA_HABITAT_RESULT              HB_FK_STN_ACT_PT               R
FA_HABITAT_RESULT              PK_HABITAT_RESULT              P
FA_HABITAT_RESULT              SYS_C005616                    C
FA_REGULAR_RESULT              PK_REGULAR_RESULT              P
FA_REGULAR_RESULT              RE_FK_ACT_MAD_HDATUM           R
FA_REGULAR_RESULT              RE_FK_ACT_MAD_HMETHOD          R
FA_REGULAR_RESULT              RE_FK_ACT_MEDIUM               R
FA_REGULAR_RESULT              RE_FK_CHAR                     R
FA_REGULAR_RESULT              RE_FK_DATE_ACT_START           R
FA_REGULAR_RESULT              RE_FK_SD_DB_CAT                R
FA_REGULAR_RESULT              RE_FK_SD_GEN_DB_CAT            R
FA_REGULAR_RESULT              RE_FK_SD_GEO_COUNTY            R
FA_REGULAR_RESULT              RE_FK_SD_GEO_STATE             R
FA_REGULAR_RESULT              RE_FK_SD_ORG                   R
FA_REGULAR_RESULT              RE_FK_STATION                  R
FA_REGULAR_RESULT              RE_FK_STN_ACT_PT               R
FA_REGULAR_RESULT              SYS_C005561                    C
FA_STATION                     FK_SD_DB_CAT                   R
FA_STATION                     FK_SD_ESTRY_PRIMARY            R
FA_STATION                     FK_SD_ESTRY_SECONDARY          R
FA_STATION                     FK_SD_GEN_DB_CAT               R
FA_STATION                     FK_SD_GEO_COUNTY               R
FA_STATION                     FK_SD_GEO_STATE                R
FA_STATION                     FK_SD_MAD_HDATUM               R
FA_STATION                     FK_SD_MAD_HMETHOD              R
FA_STATION                     FK_SD_MAD_VDATUM               R
FA_STATION                     FK_SD_MAD_VMETHOD              R
FA_STATION                     FK_SD_ORG                      R
FA_STATION                     FK_SD_STATN_TYPES              R
FA_STATION                     FK_SD_STD_MAD_HDATUM           R
FA_STATION                     PK_STATION                     P
FA_STATION                     SYS_C005492                    C
HABITAT_RESULT_PROJECT         HB_PROJ_FK_PROJECT             R
HABITAT_RESULT_PROJECT         HB_PROJ_FK_RESULT              R
LU_CHARTYPE                    PK_CHARTYPE                    P
LU_CHAR_ALIAS                  CHAR_ALIAS_FK_CHAR_TYPE        R
LU_CHAR_ALIAS                  PK_CHAR_ALIAS                  P
LU_CHAR_ALIAS                  SYS_C005516                    C
LU_CHAR_ALIAS                  SYS_C005517                    C
LU_CHAR_ALIAS                  SYS_C005518                    C
LU_CHAR_ALIAS_TYPE             PK_CHAR_ALIAS_TYPE             P
LU_CHAR_ALIAS_TYPE             SYS_C005519                    C
LU_ESTRY_PRIMARY               PK_ESTRY_PRIMARY               P
LU_ESTRY_SECONDARY             PK_ESTRY_SECONDARY             P
LU_EXTERNAL_REF_SCHEME         PK_REF_SCHEME                  P
LU_EXTERNAL_REF_SCHEME         SYS_C005664                    C
LU_EXTERNAL_REF_SCHEME         SYS_C005665                    C
LU_EXTERNAL_REF_SCHEME         SYS_C005666                    C
LU_EXTERNAL_REF_SCHEME         SYS_C005667                    C
LU_MAD_HDATUM                  PK_MAD_HDATUM                  P
LU_MAD_HDATUM                  SYS_C005534                    C
LU_MAD_HMETHOD                 PK_MAD_HMETHOD                 P
LU_MAD_HMETHOD                 SYS_C005536                    C
LU_MAD_VDATUM                  PK_MAD_VDATUM                  P
LU_MAD_VDATUM                  SYS_C005538                    C
LU_MAD_VMETHOD                 PK_MAD_VMETHOD                 P
LU_MAD_VMETHOD                 SYS_C005540                    C
LU_STATION_ALIAS               PK_STATION_ALIAS               P
LU_STATION_ALIAS               STATION_ALIAS_FK_REF_SCHEME    R
LU_STATION_ALIAS               STATION_ALIAS_FK_STATION       R
LU_STATION_ALIAS               SYS_C005662                    C
LU_STATION_ALIAS               SYS_C005668                    C
LU_UNIT_CONVERSION             PK_UNIT_CONV                   P
MD_ANALYTICAL_PROC             FK_MD_ANLP                     R
MD_ANALYTICAL_PROC             PK_ANALY_PROC                  P
MD_ANALYTICAL_PROC             SYS_C005781                    C
MD_ANALYTICAL_PROC             SYS_C005783                    C
MD_ANALYTICAL_PROC             SYS_C005784                    C
MD_CITATION                    FK_MD_CIT                      R
MD_CITATION                    PK_CITATION                    P
MD_CITATION                    SYS_C005823                    C
MD_CITATION                    SYS_C005825                    C
MD_CITATION                    SYS_C005826                    C
MD_CITATION                    SYS_C005827                    C
MD_CITATION                    SYS_C005828                    C
MD_CITATION                    SYS_C005829                    C
MD_COOP                        FK_MD_COOP                     R
MD_COOP                        PK_CO_ORG                      P
MD_COOP                        SYS_C005748                    C
MD_COOP                        SYS_C005750                    C
MD_COOP_ADDRESS                FK_MD_ACOOP                    R
MD_COOP_ADDRESS                PK_CO_OP_ADDR                  P
MD_COOP_ADDRESS                SYS_C005754                    C
MD_COOP_ADDRESS                SYS_C005755                    C
MD_COOP_EADDRESS               FK_MD_ECOOP                    R
MD_COOP_EADDRESS               PK_CO_ORG_EADDR                P
MD_COOP_EADDRESS               SYS_C005759                    C
MD_COOP_EADDRESS               SYS_C005760                    C
MD_LAB                         FK_MD_LAB                      R
MD_LAB                         PK_LAB                         P
MD_LAB                         SYS_C005765                    C
MD_LAB                         SYS_C005767                    C
MD_LAB_ADDRESS                 FK_MD_ALAB                     R
MD_LAB_ADDRESS                 PK_LAB_ADDR                    P
MD_LAB_ADDRESS                 SYS_C005771                    C
MD_LAB_ADDRESS                 SYS_C005772                    C
MD_LAB_EADDRESS                FK_MD_ELAB                     R
MD_LAB_EADDRESS                PK_LAB_EADDR                   P
MD_LAB_EADDRESS                SYS_C005776                    C
MD_LAB_EADDRESS                SYS_C005777                    C
MD_LAB_EADDRESS                SYS_C005778                    C
MD_LAB_SAMPLE_PREP_PROCEDURE   FK_MD_LSPP                     R
MD_LAB_SAMPLE_PREP_PROCEDURE   PK_LAB_SPP                     P
MD_LAB_SAMPLE_PREP_PROCEDURE   SYS_C005787                    C
MD_LAB_SAMPLE_PREP_PROCEDURE   SYS_C005789                    C
MD_LAB_SAMPLE_PREP_PROCEDURE   SYS_C005790                    C
MD_ORG_ADDRESS                 FK_MD_ORG                      R
MD_ORG_ADDRESS                 PK_ORG_ADDR                    P
MD_ORG_ADDRESS                 SYS_C005736                    C
MD_ORG_ADDRESS                 SYS_C005739                    C
MD_ORG_EADDRESS                FK_MD_EORG                     R
MD_ORG_EADDRESS                PK_ORG_EADDR                   P
MD_ORG_EADDRESS                SYS_C005743                    C
MD_ORG_EADDRESS                SYS_C005744                    C
MD_ORG_EADDRESS                SYS_C005745                    C
MD_PROGRAM                     FK_MD_PGM                      R
MD_PROGRAM                     PK_PROGRAM                     P
MD_PROGRAM                     SYS_C005793                    C

TABLE_NAME                     CONSTRAINT_NAME                C
------------------------------ ------------------------------ -
MD_PROGRAM                     SYS_C005795                    C
MD_PROGRAM                     SYS_C005796                    C
MD_PROGRAM                     SYS_C005797                    C
MD_PROGRAM                     SYS_C005798                    C
MD_SAMPLE_GEAR                 FK_MD_SG                       R
MD_SAMPLE_GEAR                 PK_SAMPLE_GEAR                 P
MD_SAMPLE_GEAR                 SYS_C005809                    C
MD_SAMPLE_PRESRV               FK_MD_SPP                      R
MD_SAMPLE_PRESRV               PK_SAMPLE_PRESRV               P
MD_SAMPLE_PRESRV               SYS_C005817                    C
MD_SAMPLE_PROC                 FK_MD_SP                       R
MD_SAMPLE_PROC                 PK_SAMPLE_PROC                 P
MD_SAMPLE_PROC                 SYS_C005801                    C
MD_SAMPLE_PROC                 SYS_C005803                    C
MT_ATTRIBUTE_MAP               PK_MT_ATTR_MAP                 P
MT_WH_CONFIG                   PK_MT_WH_CONFIG                P
REGULAR_RESULT_PROJECT         RE_PROJ_FK_PROJECT             R
REGULAR_RESULT_PROJECT         RE_PROJ_FK_RESULT              R
STATION_CHAR                   FK_STATION_CHAR01              R
STATION_CHAR                   FK_STATION_CHAR02              R
STATION_CHAR                   SYS_C005498                    C
STATION_CHAR                   SYS_C005499                    C
STATION_CHAR                   SYS_C005500                    C
STATION_CHAR                   SYS_C005501                    C
STATION_CHAR                   TRIBAL_Y_OR_N                  C
STATION_PROJECT                RE_STN_PROJ_FK_PROJ            R
STATION_PROJECT                RE_STN_PROJ_FK_STATION         R
STATION_PROJECT                SYS_C005650                    C
STATION_PROJECT                SYS_C005651                    C
WS_HUC_CHAR_SUMMARY            PK_WS_HUC_CHAR_SUMMARY         P
WS_HUC_CHAR_SUMMARY            SYS_C005838                    C
WS_HUC_CHAR_SUMMARY            SYS_C005839                    C
WS_HUC_CHAR_SUMMARY            SYS_C005840                    C
WS_HUC_ORG_CHAR_SUMMARY        PK_WS_HUC_ORG_CHAR_SUMMARY     P
WS_HUC_ORG_CHAR_SUMMARY        SYS_C005842                    C
WS_HUC_ORG_CHAR_SUMMARY        SYS_C005843                    C
WS_HUC_ORG_CHAR_SUMMARY        SYS_C005844                    C
WS_HUC_ORG_CHAR_SUMMARY        SYS_C005845                    C
WS_HUC_ORG_SUMMARY             PK_WS_HUC_ORG_SUMMARY          P
WS_HUC_ORG_SUMMARY             SYS_C005835                    C
WS_HUC_ORG_SUMMARY             SYS_C005836                    C
WS_STATION_SUMMARY             SYS_C005847                    C
WS_STATION_SUMMARY             SYS_C005848                    C
WS_STATION_SUMMARY             SYS_C005849                    C
WS_STATION_SUMMARY             SYS_C005850                    C

Null Characteristics
--------------------
                   0
drop table station_char_temp
           *
ERROR at line 1:
ORA-00942: table or view does not exist


drop table FA_STATION_WEB
           *
ERROR at line 1:
ORA-00942: table or view does not exist


drop table FA_STATION_MAP
           *
ERROR at line 1:
ORA-00942: table or view does not exist



STATION_COUNT
-------------
       340633
drop table FA_STATION_MAP
           *
ERROR at line 1:
ORA-00942: table or view does not exist



STATION_COUNT
-------------
       340633
AND activity_type = ‘Sample’
                    *
ERROR at line 4:
ORA-00911: invalid character


	WHERE re.ACTIVITY_ISN = f.tsrfdact_is_number
	*
ERROR at line 8:
ORA-00907: missing right parenthesis



TABLE_NAME                      CHAIN_CNT
------------------------------ ----------
DI_CHARACTERISTIC                     301
DI_ORG                                145
DI_PROJECT                           3292
FA_BIOLOGICAL_RESULT                  927
FA_HABITAT_RESULT                  300712
FA_REGULAR_RESULT                 1180524
FA_STATION                          39209
LU_CHAR_ALIAS                         195
LU_STATION_ALIAS                    10483
STATION_CHAR                      1279402
Starting build select of columns to be altered for &DB_T
Dropping Temporary table if exist otherwise Please ignore the error
drop table sem_tab
           *
ERROR at line 1:
ORA-00942: table or view does not exist


