Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\reposasst\drop_misc.sql
drop table UOIDMAPPING cascade constraints; drop table WBALLPROPERTIES cascade constraints; drop table FullClassNameLookup cascade constraints; drop view OWBP_IMPACT_ROOT_V; drop view OWBP_IMPACT_V; drop view OWBP_LINEAGE_ROOT_V; drop view OWBP_LINEAGE_V; drop view ALL_IV_ADVANCED_QUEUES; drop view ALL_IV_COLLECTIONS; drop view ALL_IV_COLLECTION_ITEMS; drop view ALL_IV_CURSORS ; drop view ALL_IV_EXTERNAL_COLUMNS; drop view ALL_IV_EXTERNAL_TABLES ; drop view ALL_IV_FILE_SCHEMAS ; drop view ALL_IV_GATEWAY_SCHEMAS ; drop view ALL_IV_LOGICAL_CONNECTORS ; drop view ALL_IV_LOGICAL_LOCATIONS ; drop view ALL_IV_MIV_SCHEMAS ; drop view ALL_IV_OBJECT_TYPES ; drop view ALL_IV_PACKAGED_APPS_SCHEMAS ; drop view ALL_IV_PACKAGES ; drop view ALL_IV_PLS_COLLECTIONS ; drop view ALL_IV_PLS_RECORDS ; drop view ALL_IV_PLS_ROWTYPES ; drop view ALL_IV_PREDEFINED_SCHEMAS; drop view ALL_IV_PROCESSES ; drop view ALL_IV_PROCESS_ACTIVITIES ; drop view ALL_IV_PROCESS_PARAMETERS ; drop view ALL_IV_PROCESS_SCHEMAS ; drop view ALL_IV_PROCESS_TRANSITIONS; drop view ALL_IV_PROCESS_VARIABLES ; drop view ALL_IV_RUNTIME_LOCATIONS ; drop view ALL_IV_SQL_COLLECTIONS ; drop view ALL_IV_TABLE_FUNCTIONS ; drop view ALL_IV_WAREHOUSE_SCHEMAS ; drop view ALL_IV_XML_SCHEMAS ; drop view PCTREE_UV ; drop view TREEVIEW_V; drop view ALL_IV_DIM_LEVEL_IMPLS; drop view ALL_IV_RECORD_FIELDS; drop view CMPALLFOLDERFCONAMES_X; drop package ERRORPKG ; drop package SNAPSHOTERROR ; drop package SNAPSHOTMXS ; drop package WBSECURITYHELPER ; drop package WBSECURITYSERVICEIMPL ; drop package WB_ENV_UTIL; drop type OBJECTUOIDARRAY; drop view ASSOCIATIONDEFINITION_X; drop view DEPENDENCYDEFINITION_X; drop view CLASSDEFINITION_X; drop view CLASSINHERITANCEDEFINITION_X; drop view CLASSUSAGEDEFINITION_X; drop view COMPONENTDEFINITION_X; drop view DEFINITIONELEMENT_X; drop view DEFINITIONINTERESTUSAGE_X; drop view DEFINITIONKEYLOOKUPBUNDLE_X; drop view DUMMYINTERESTSET_X; drop view DUMMYINTERESTUSAGE_X; drop view INTERESTSET_X; drop view INTERESTUSAGE_X; drop view LOADINGSTRATEGY_X; drop view PROPERTYDEFINITION_X; drop view PROPERTYGROUPDEFINITION_X; drop view PROPERTYSETDEFINITION_X; drop view PROPERTYUSAGECHOICE_X; drop view PROPERTYUSAGEDEFINITION_X; drop view PUBLICAPISET_X; drop view ROLEDEFINITION_X; drop view TREENODE_X; drop view VERTICALTREE_X; drop view WBABSTRACTTYPE_X; drop view WBARRAYTYPE_X; drop view WBCOLLECTIONPROPERTY_X; drop view WBCOLLECTIONTYPE_X; drop view WBDOMAIN_X; drop view WBEXTENSIBLETYPE_X; drop view WBPRIMITIVEPROPERTY_X; drop view WBPRIMITIVETYPE_X; drop view WBPROPERTY_X; drop view WBRANGE_X; drop view WBREFERENCEPROPERTY_X; drop view WBSCALARPROPERTY_X; drop view WBSCALARTYPE_X; drop sequence dblinkname_seq; drop sequence semantics_seq; rem Drop miscellaneous object (bug 4283054) - gggraham drop package DATA_PROFILE_UTL; drop package DEP_DETAILMAP; drop package DEP_DETAILPFLOW; drop package OWB_MATCH_MERGE; drop package OWBUOIDRECONCILE; drop package SECURITYCHECKCASCADE; drop package OPTIMIZERSTATISTICS; drop package BIOINFORMATICS; drop view MAP_DETAILVIEW_V; drop view OWB_PLS_ROWTYPES; drop view OWB_SQL_COLLECTIONS; drop view OWB_XML_MODULES; drop view PROCESSFLOW_DETAILVIEW_V; drop view WBARRAYPROPERTY_X; drop table DATAFLOW_DEPENDENCY_T cascade constraints; drop table UOIDERRORTABLE cascade constraints; drop table UOIDREFERENCETABLE cascade constraints; drop table UOIDREFERENCETARGETTABLE cascade constraints; drop function WB_RT_MODE; drop function WB_RT_MODE_CNT; drop function WB_RT_CONCAT; drop type WB_RT_MODE_T force; drop type WB_RT_MODE_CNT_T force; drop type WB_RT_CONCAT_T force; drop type WB_RT_INTTABLE force; drop type WB_RT_VARCHAR2TABLE force; drop type BLAST_SQL_TABLE_OF_NUMBERS force; rem drop data profile view types (bug 4283046) - bloper drop type profile_column_prop_set force; drop type profile_uk_prop_set force; drop type profile_fk_prop_set force; drop type profile_fd_prop_set force; drop type profile_rr_prop_set force; drop type profile_column_prop_type force; drop type profile_uk_prop_type force; drop type profile_fk_prop_type force; drop type profile_fd_prop_type force; drop type profile_rr_prop_type force; drop type profile_column_query_set force; drop type profile_uk_query_set force; drop type profile_fk_query_set force; drop type profile_fd_query_set force; drop type profile_rr_query_set force; drop type profile_column_query_type force; drop type profile_uk_query_type force; drop type profile_fk_query_type force; drop type profile_fd_query_type force; drop type profile_rr_query_type force; rem drop browserasst packages for repos upgrade feature - 10/18/2007 epaglina drop package OWB_UPROP; drop package OWB_UPROP_TUNE; drop view SUB_ALL_PERSISTED_PROPS; drop view SUB_FQ_PUSAGE_DEF; rem drop workspace packages for repos upgrade feature - 10/18/2007 epaglina drop package OWB_WORKSPACE_MANAGER; drop package WB_WORKSPACE_MANAGEMENT; drop sequence CWMWORKSPACESEQ; drop procedure START_ENABLE_OWB_ROLES; drop synonym IDX_SCOMAPCONNECTFROM; drop synonym IDX_SCOMAPMAPOP; drop view TREEVIEW_X; drop table OWB_UPROP_NLS cascade constraints; drop table PUBLIC_VIEWS cascade constraints; drop table USER_LOGIN_INFO cascade constraints; drop function GETENTERPRISEMODE;
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de