Conference orarep::nomahs::dbstars

749.0. "Dropping a DBI Oracle catalog" by BROKE::GREEN () Tue Feb 18 1997 14:11

Copyright (c) 1997 by Oracle Corporation.  All Rights Reserved.

KEYWORDS: DBI catalog Oracle Distributed Option drop upgrade convert	

TITLE:    Commands to drop a Distributed Option Oracle catalog in SQLPLUS

PRODUCT:  Rdb Distributed Option

OP/SYS:   OpenVMS VAX & AXP

SOURCE:   Oracle Worldwide Customer Support


SYMPTOM:  You want to drop a Distributed Option Oracle catalog.


RESPONSE:  These are the commands to execute in SQLPLUS which will drop a
           Rdb Distributed Option Oracle catalog.

DROP VIEW DBI.DBI_PROXY_USER_VIEW;
DROP VIEW DBI.DBI_PROXY_DBADM_VIEW;
DROP INDEX DBI.DBI_LINK_NAME_NDX;
DROP INDEX DBI.DBI_USER_NAME_NDX;
DROP INDEX DBI.DBI_FIELDS_NAME_NDX;
DROP INDEX DBI.DBI_REL_REL_ID_NDX;
DROP INDEX DBI.DBI_REL_REL_NAME_NDX;  
DROP INDEX DBI.DBI_RFR_REL_NAME_FLD_ID_NDX;
DROP INDEX DBI.DBI_VIEW_REL_NAME_NDX;
DROP INDEX DBI.DBI_VIEW_VIEW_NAME_NDX;
DROP INDEX DBI.DBI_NDX_NDX_NAME_NDX;
DROP INDEX DBI.DBI_NDX_SEG_NAM_FLD_POS_NDX;
DROP INDEX DBI.DBI_INTER_CON_NAM_NDX;
DROP INDEX DBI.DBI_INTER_ENTITY_NDX;
DROP INDEX DBI.DBI_CS_CAT_SCHEMA_ID_NDX;
DROP INDEX DBI.DBI_CS_CAT_SCHEMA_NAME_NDX;
DROP INDEX DBI.DBI_SYN_STORED_NAME_NDX;
DROP INDEX DBI.DBI_SYN_VISIBLE_NAME_NDX;
DROP INDEX DBI.DBI_VIEW_PARTN_ID_NDX;
DROP INDEX DBI.DBI_VIEW_PARTN_NDX;
DROP INDEX DBI.DBI_VIEW_PARTN_FLD_NDX; 
DROP INDEX DBI.DBI_RTN_ID_NDX;
DROP INDEX DBI.DBI_RTN_NAME_NDX;
DROP INDEX DBI.DBI_PRM_NAME_NDX;
DROP INDEX DBI.DBI_MOD_ID_NDX;
DROP INDEX DBI.DBI_MOD_NAME_NDX;
DROP INDEX DBI.DBI_PRV_REL_FLD_IDS_NDX;
DROP INDEX DBI.DBI_USERS_ID_NDX;
DROP INDEX DBI.DBI_USERS_NAME_NDX;
DROP SEQUENCE DBI.DBI_DB_DESCRIP_SEQ;
DROP SEQUENCE DBI.DBI_DB_DB_PARAM_SEQ;
DROP SEQUENCE DBI.DBI_DB_XT_PARAM_SEQ;
DROP SEQUENCE DBI.DBI_DB_LINKS_DESCRIP_SEQ;
DROP SEQUENCE DBI.DBI_FLD_VALID_BLR_SEQ;
DROP SEQUENCE DBI.DBI_FLD_COMPUTED_BLR_SEQ;
DROP SEQUENCE DBI.DBI_FLD_MISSING_VALUE_SEQ;
DROP SEQUENCE DBI.DBI_FLD_DESCRIP_SEQ;
DROP SEQUENCE DBI.DBI_FLD_VALID_SRC_SEQ;
DROP SEQUENCE DBI.DBI_FLD_COMPUTED_SRC_SEQ;
DROP SEQUENCE DBI.DBI_FLD_QUERY_HEADER_SEQ;
DROP SEQUENCE DBI.DBI_FLD_DEF_VAL_SEQ;
DROP SEQUENCE DBI.DBI_FLD_XT_PARAM_SEQ;
DROP SEQUENCE DBI.DBI_FLD_CDD_NAME_SEQ;
DROP SEQUENCE DBI.DBI_FLD_DEF_VAL2_SEQ;
DROP SEQUENCE DBI.DBI_REL_VIEW_BLR_SEQ;
DROP SEQUENCE DBI.DBI_REL_DESCRIP_SEQ;
DROP SEQUENCE DBI.DBI_REL_VIEW_SRC_SEQ;
DROP SEQUENCE DBI.DBI_REL_XT_PARAM_SEQ;
DROP SEQUENCE DBI.DBI_REL_CDD_NAME_SEQ;
DROP SEQUENCE DBI.DBI_REL_UDB_INFO_SEQ;
DROP SEQUENCE DBI.DBI_REL_FLD_QUERY_HEADER_SEQ;
DROP SEQUENCE DBI.DBI_REL_FLD_DESCRIP_SEQ;
DROP SEQUENCE DBI.DBI_REL_FLD_DEF_VAL_SEQ;
DROP SEQUENCE DBI.DBI_REL_FLD_XT_PARAM_SEQ;
DROP SEQUENCE DBI.DBI_REL_FLD_DEF_VAL2_SEQ;
DROP SEQUENCE DBI.DBI_REL_FLD_LINK_DB_INFO_SEQ;
DROP SEQUENCE DBI.DBI_REL_FLD_HIGH_VALUE_SEQ;
DROP SEQUENCE DBI.DBI_REL_FLD_LOW_VALUE_SEQ;
DROP SEQUENCE DBI.DBI_IND_DESCRIP_SEQ;
DROP SEQUENCE DBI.DBI_IND_XT_PARAM_SEQ;
DROP SEQUENCE DBI.DBI_IND_UDB_INFO_SEQ;
DROP SEQUENCE DBI.DBI_CAT_SCHEMA_DESCRIP_SEQ;
DROP SEQUENCE DBI.DBI_VP_PARTN_QUAL_BLR_SEQ;
DROP SEQUENCE DBI.DBI_VP_PARTN_QUAL_SRC_SEQ;
DROP SEQUENCE DBI.DBI_VP_PARTN_BLR_SEQ;
DROP SEQUENCE DBI.DBI_VP_PARTN_SRC_SEQ;
DROP SEQUENCE DBI.DBI_VP_RANGE1_VALUE_SEQ;
DROP SEQUENCE DBI.DBI_VP_RANGE2_VALUE_SEQ;
DROP SEQUENCE DBI.DBI_RTN_BLR_SEQ;
DROP SEQUENCE DBI.DBI_RTN_SRC_SEQ;
DROP SEQUENCE DBI.DBI_RTN_DESCR_SEQ;
DROP SEQUENCE DBI.DBI_RTN_EXT_PARAM_SEQ;
DROP SEQUENCE DBI.DBI_RTN_UDB_INFO_SEQ;
DROP SEQUENCE DBI.DBI_PRM_DESCR_SEQ;
DROP SEQUENCE DBI.DBI_MOD_EXT_PARAM_SEQ;
DROP SEQUENCE DBI.DBI_MOD_HDR_SRC_SEQ;
DROP SEQUENCE DBI.DBI_MOD_DESCR_SEQ;
DROP TABLE DBI.DBI_DATABASE_LINKS;
DROP TABLE DBI.DBI_LINK_PROXIES;
DROP TABLE DBI.DBI_FIELDS;
DROP TABLE DBI.DBI_RELATIONS;
DROP TABLE DBI.DBI_RELATION_FIELDS;
DROP TABLE DBI.DBI_VIEW_RELATIONS;
DROP TABLE DBI.DBI_INDICES;
DROP TABLE DBI.DBI_INDEX_SEGMENTS;
DROP TABLE DBI.DBI_INTERRELATIONS;
DROP TABLE DBI.DBI_CATALOG_SCHEMA;
DROP TABLE DBI.DBI_SYNONYMS;
DROP TABLE DBI.DBI_VIEW_PARTITIONS;
DROP TABLE DBI.DBI_VIEW_PARTITION_FIELDS;
DROP TABLE DBI.DBI_BLOBS;
DROP TABLE DBI.DBI_ROUTINES;
DROP TABLE DBI.DBI_PARAMETERS;
DROP TABLE DBI.DBI_MODULES;
DROP TABLE DBI.DBI_PRIVILEGES;
DROP TABLE DBI.DBI_USERS;
DROP TABLE DBI.DBI_DATABASE;



\
\ CONTRIBUTORS:
\
\	Technical: Don Green
\	Editorial: 
\
\