public override void FillDataBaseViews(XsdDataBase.TBL_ObjectDataTable nObjectTable, XsdDataBase.TBL_ConnectionRow nConnection, List<string> nSchemaFilter)
{
try
{
var sql = new StringBuilder();
sql.AppendLine(@"SELECT c.table_catalog , c.table_schema, c.table_name, c.table_type FROM information_schema.tables c");
sql.AppendLine(@"WHERE c.table_type = 'VIEW' AND c.table_schema NOT IN('information_schema', 'pg_catalog')");
if (nSchemaFilter != null && nSchemaFilter.Count > 0)
{
string CadenaFiltro = "";
foreach (var Filtro in nSchemaFilter)
{
if (CadenaFiltro != "")
CadenaFiltro += ", ";
CadenaFiltro += "'" + Filtro + "'";
}
sql.AppendLine(@"AND c.table_schema IN(" + CadenaFiltro + ")");
}
sql.AppendLine(@"ORDER BY c.table_schema, c.table_name");
DataTable table = ExecuteQueryGet(sql.ToString());
for (int i = 0; i < table.Rows.Count; i++)
{
DataRow row = table.Rows[i];
var newObjectRow = nObjectTable.NewTBL_ObjectRow();
newObjectRow.fk_Connection = nConnection.id_Connection;
newObjectRow.Catalog_Name = row["table_catalog"].ToString();
newObjectRow.Schema_Name = row["table_schema"].ToString();
newObjectRow.Object_Type = row["table_type"].ToString();
newObjectRow.Generic_Type = "View";
newObjectRow.Object_Name = row["table_name"].ToString();
newObjectRow.Selected = false;
nObjectTable.AddTBL_ObjectRow(newObjectRow);
}
}
catch (Exception ex)
{
throw new Exception("No fue posible obtener el listado de tablas " + base.Connection.DataSource + " , " + ex.Message, ex);
}
}
public override void FillDataBaseStoredProcedures(XsdDataBase.TBL_ObjectDataTable nObjectTable, XsdDataBase.TBL_ConnectionRow nConnection, List<string> nSchemaFilter)
{
try
{
string sql = @"SELECT r.routine_catalog , r.routine_schema , r.routine_name , r.routine_type , 'StoredProcedure' AS generic_type" + ControlChars.CrLf +
"FROM information_schema.routines r" + ControlChars.CrLf +
"WHERE r.routine_type = 'FUNCTION' AND" + ControlChars.CrLf +
"r.specific_schema NOT IN('information_schema', 'pg_catalog')" + ControlChars.CrLf +
"ORDER BY r.routine_schema , r.routine_name";
DataTable table = ExecuteQueryGet(sql);
for (int i = 0; i < table.Rows.Count; i++)
{
DataRow row = table.Rows[i];
var newObjectRow = nObjectTable.NewTBL_ObjectRow();
newObjectRow.fk_Connection = nConnection.id_Connection;
newObjectRow.Catalog_Name = row["routine_catalog"].ToString();
newObjectRow.Schema_Name = row["routine_schema"].ToString();
newObjectRow.Object_Type = row["routine_type"].ToString();
newObjectRow.Generic_Type = "StoredProcedure";
newObjectRow.Object_Name = row["routine_name"].ToString();
newObjectRow.Selected = false;
nObjectTable.AddTBL_ObjectRow(newObjectRow);
}
}
catch (Exception ex)
{
throw new Exception("No fue posible obtener el listado de tablas " + base.Connection.DataSource + " , " + ex.Message, ex);
}
}
public override void FillDataBaseTables(XsdDataBase.TBL_ObjectDataTable nObjectTable, XsdDataBase.TBL_ConnectionRow nConnection, List<string> nSchemaFilter)
{
try
{
var sql = new StringBuilder();
sql.AppendLine(@"SELECT SYS_CONTEXT('userenv', 'DB_NAME') AS table_catalog , owner AS table_schema , tabs.table_name, 'BASE TABLE' AS table_type");
sql.AppendLine(@"FROM DBA_ALL_TABLES tabs");
sql.AppendLine(@"WHERE(IOT_NAME IS NULL)");
sql.AppendLine(@"AND temporary = 'N'");
sql.AppendLine(@"AND NOT EXISTS (SELECT snps.table_name FROM sys.DBA_SNAPSHOTS snps WHERE snps.Owner = tabs.owner AND snps.table_name = tabs.table_name)");
sql.AppendLine(@"AND NOT EXISTS (SELECT 'X' FROM sys.DBA_SNAPSHOT_LOGS slog WHERE slog.log_owner = tabs.owner AND slog.log_table = tabs.table_name) ");
sql.AppendLine(@"AND tabs.table_name NOT LIKE 'USLOG$_%'");
sql.AppendLine(@"AND NOT EXISTS (SELECT 'x' FROM sys.DBA_NESTED_TABLES nt WHERE nt.Owner = tabs.owner AND nt.table_name = tabs.table_name)");
sql.AppendLine(@"AND NOT EXISTS (SELECT queue_table qt FROM sys.DBA_QUEUE_TABLES qt WHERE qt.Owner = tabs.owner AND qt.queue_table = tabs.table_name)");
if (nSchemaFilter != null && nSchemaFilter.Count > 0)
{
string cadenaFiltro = "";
foreach (var filtro in nSchemaFilter)
{
if (cadenaFiltro != "")
cadenaFiltro += ", ";
cadenaFiltro += "'" + filtro + "'";
}
sql.AppendLine(@"AND owner IN(" + cadenaFiltro + ")");
}
sql.AppendLine(@"ORDER BY 1 , 2 , 3");
DataTable table = ExecuteQueryGet(sql.ToString());
for (int i = 0; i < table.Rows.Count; i++)
{
DataRow row = table.Rows[i];
var newObjectRow = nObjectTable.NewTBL_ObjectRow();
newObjectRow.fk_Connection = nConnection.id_Connection;
newObjectRow.Catalog_Name = row["table_catalog"].ToString();
newObjectRow.Schema_Name = row["table_schema"].ToString();
newObjectRow.Object_Type = row["table_type"].ToString();
newObjectRow.Generic_Type = "Table";
newObjectRow.Object_Name = row["table_name"].ToString();
newObjectRow.Selected = false;
nObjectTable.AddTBL_ObjectRow(newObjectRow);
}
}
catch (Exception ex)
{
throw new Exception("No fue posible obtener el listado de tablas " + base.Connection.DataSource + " , " + ex.Message, ex);
}
}
public override void FillDataBaseViews(XsdDataBase.TBL_ObjectDataTable nObjectTable, XsdDataBase.TBL_ConnectionRow nConnection, List<string> nSchemaFilter)
{
try
{
var sql = new StringBuilder();
sql.AppendLine(@"SELECT sys_context('userenv', 'DB_NAME') AS table_catalog , owner AS table_schema , v.view_name AS table_name, 'VIEW' AS table_type");
sql.AppendLine(@"FROM all_views v WHERE ");
sql.AppendLine(@"view_name NOT IN ('_ALL_FILE_GROUP_EXPORT_INFO','_ALL_FILE_GROUP_FILES','_ALL_FILE_GROUP_TABLES','_ALL_FILE_GROUP_TABLESPACES','_ALL_FILE_GROUP_VERSIONS','_ALL_FILE_GROUPS','_ALL_INSTANTIATION_DDL','_ALL_REPCOLUMN','_ALL_REPCOLUMN_GROUP','_ALL_REPCONFLICT','_ALL_REPEXTENSIONS','_ALL_REPFLAVOR_OBJECTS','_ALL_REPGROUPED_COLUMN','_ALL_REPL_NESTED_TABLE_NAMES','_ALL_REPPARAMETER_COLUMN','_ALL_REPRESOLUTION','_ALL_REPSITES_NEW','_ALL_SQLSET_STATEMENTS_ONLY','_ALL_SQLSET_STATEMENTS_PHV','_ALL_SQLSET_STATISTICS_ONLY','_ALL_STREAMS_PROCESSES','_ALL_SYNONYMS_FOR_AUTH_OBJECTS','_ALL_SYNONYMS_FOR_SYNONYMS','_ALL_SYNONYMS_TREE','_DBA_APPLY','_DBA_APPLY_CONF_HDLR_COLUMNS','_DBA_APPLY_CONSTRAINT_COLUMNS','_DBA_APPLY_ERROR','_DBA_APPLY_ERROR_HANDLER','_DBA_APPLY_ERROR_TXN','_DBA_APPLY_MILESTONE','_DBA_APPLY_OBJECT_CONSTRAINTS','_DBA_APPLY_OBJECTS','_DBA_APPLY_PROGRESS','_DBA_APPLY_SOURCE_OBJ','_DBA_APPLY_SOURCE_SCHEMA','_DBA_APPLY_SPILL_TXN','_DBA_APPLY_TABLE_COLUMNS','_DBA_APPLY_TABLE_COLUMNS_H','_DBA_CAPTURE','_DBA_REPL_NESTED_TABLE_NAMES','_DBA_STREAMS_MESSAGE_CONSUMERS','_DBA_STREAMS_MESSAGE_RULES','_DBA_STREAMS_MSG_NOTIFICATIONS','_DBA_STREAMS_NEWLY_SUPTED_10_1','_DBA_STREAMS_NEWLY_SUPTED_10_2','_DBA_STREAMS_PRIVILEGED_USER','_DBA_STREAMS_PROCESSES','_DBA_STREAMS_QUEUES','_DBA_STREAMS_RULES','_DBA_STREAMS_RULES_H','_DBA_STREAMS_TRANSFM_FUNCTION','_DBA_STREAMS_TRANSFORMATIONS','_DBA_STREAMS_UNSUPPORTED_10_1','_DBA_STREAMS_UNSUPPORTED_10_2','_DBA_STREAMS_UNSUPPORTED_9_2','_DEFSCHEDULE','_DEFTRANDEST','_USER_FILE_GROUPS','_USER_REPL_NESTED_TABLE_NAMES','_utl$_gnp_ind','_utl$_gp_ind_parts','_utl$_lc_ind_subs','_utl$_lnc_ind_parts','ALL_ALL_TABLES','ALL_APPLY','ALL_APPLY_CONFLICT_COLUMNS','ALL_APPLY_DML_HANDLERS','ALL_APPLY_ENQUEUE','ALL_APPLY_ERROR','ALL_APPLY_EXECUTE','ALL_APPLY_KEY_COLUMNS','ALL_APPLY_PARAMETERS','ALL_APPLY_PROGRESS','ALL_APPLY_TABLE_COLUMNS','ALL_ARGUMENTS','ALL_ASSOCIATIONS','ALL_AUDIT_POLICIES','ALL_AUDIT_POLICY_COLUMNS','ALL_AW_PS','ALL_AWS','ALL_BASE_TABLE_MVIEWS','ALL_CAPTURE','ALL_CAPTURE_EXTRA_ATTRIBUTES','ALL_CAPTURE_PARAMETERS','ALL_CAPTURE_PREPARED_DATABASE','ALL_CAPTURE_PREPARED_SCHEMAS','ALL_CAPTURE_PREPARED_TABLES','ALL_CATALOG','ALL_CLUSTER_HASH_EXPRESSIONS','ALL_CLUSTERS','ALL_COL_COMMENTS','ALL_COL_PRIVS','ALL_COL_PRIVS_MADE','ALL_COL_PRIVS_RECD','ALL_COLL_TYPES','ALL_CONS_COLUMNS','ALL_CONS_OBJ_COLUMNS','ALL_CONSTRAINTS','ALL_CONTEXT','ALL_DB_LINKS','ALL_DEF_AUDIT_OPTS','ALL_DEPENDENCIES','ALL_DEQUEUE_QUEUES','ALL_DIM_ATTRIBUTES','ALL_DIM_CHILD_OF','ALL_DIM_HIERARCHIES','ALL_DIM_JOIN_KEY','ALL_DIM_LEVEL_KEY','ALL_DIM_LEVELS','ALL_DIMENSIONS','ALL_DIRECTORIES','ALL_ENCRYPTED_COLUMNS','ALL_ERRORS','ALL_EVALUATION_CONTEXT_TABLES','ALL_EVALUATION_CONTEXT_VARS','ALL_EVALUATION_CONTEXTS','ALL_EXTERNAL_LOCATIONS','ALL_EXTERNAL_TABLES','ALL_FILE_GROUP_EXPORT_INFO','ALL_FILE_GROUP_FILES','ALL_FILE_GROUP_TABLES','ALL_FILE_GROUP_TABLESPACES','ALL_FILE_GROUP_VERSIONS','ALL_FILE_GROUPS','ALL_GEOMETRY_COLUMNS','ALL_IND_COLUMNS','ALL_IND_EXPRESSIONS','ALL_IND_PARTITIONS','ALL_IND_STATISTICS','ALL_IND_SUBPARTITIONS','ALL_INDEXES','ALL_INDEXTYPE_ARRAYTYPES','ALL_INDEXTYPE_COMMENTS','ALL_INDEXTYPE_OPERATORS','ALL_INDEXTYPES','ALL_INTERNAL_TRIGGERS','ALL_JOIN_IND_COLUMNS','ALL_LIBRARIES','ALL_LOB_PARTITIONS','ALL_LOB_SUBPARTITIONS','ALL_LOB_TEMPLATES','ALL_LOBS','ALL_LOG_GROUP_COLUMNS','ALL_LOG_GROUPS','ALL_METHOD_PARAMS','ALL_METHOD_RESULTS','ALL_MVIEW_AGGREGATES','ALL_MVIEW_ANALYSIS','ALL_MVIEW_COMMENTS','ALL_MVIEW_DETAIL_RELATIONS','ALL_MVIEW_JOINS','ALL_MVIEW_KEYS','ALL_MVIEW_LOGS','ALL_MVIEW_REFRESH_TIMES','ALL_MVIEWS','ALL_NESTED_TABLE_COLS','ALL_NESTED_TABLES','ALL_OBJ_COLATTRS','ALL_OBJECT_TABLES','ALL_OBJECTS','ALL_OPANCILLARY','ALL_OPARGUMENTS','ALL_OPBINDINGS','ALL_OPERATOR_COMMENTS','ALL_OPERATORS','ALL_PART_COL_STATISTICS','ALL_PART_HISTOGRAMS','ALL_PART_INDEXES','ALL_PART_KEY_COLUMNS','ALL_PART_LOBS','ALL_PART_TABLES','ALL_PARTIAL_DROP_TABS','ALL_PENDING_CONV_TABLES','ALL_PLSQL_OBJECT_SETTINGS','ALL_POLICIES','ALL_POLICY_CONTEXTS','ALL_POLICY_GROUPS','ALL_PROBE_OBJECTS','ALL_PROCEDURES','ALL_PROPAGATION','ALL_PUBLISHED_COLUMNS','ALL_QUEUE_PUBLISHERS','ALL_QUEUE_SUBSCRIBERS','ALL_QUEUE_TABLES','ALL_QUEUES','ALL_REFRESH','ALL_REFRESH_CHILDREN','ALL_REFRESH_DEPENDENCIES','ALL_REFS','ALL_REGISTERED_MVIEWS','ALL_REGISTERED_SNAPSHOTS','ALL_REGISTRY_BANNERS','ALL_REPAUDIT_ATTRIBUTE','ALL_REPAUDIT_COLUMN','ALL_REPCAT','ALL_REPCAT_REFRESH_TEMPLATES','ALL_REPCAT_TEMPLATE_OBJECTS','ALL_REPCAT_TEMPLATE_PARMS','ALL_REPCAT_TEMPLATE_SITES','ALL_REPCAT_USER_AUTHORIZATIONS','ALL_REPCAT_USER_PARM_VALUES','ALL_REPCATLOG','ALL_REPCOLUMN','ALL_REPCOLUMN_GROUP','ALL_REPCONFLICT','ALL_REPDDL','ALL_REPFLAVOR_COLUMNS','ALL_REPFLAVOR_OBJECTS','ALL_REPFLAVORS','ALL_REPGENERATED','ALL_REPGENOBJECTS','ALL_REPGROUP','ALL_REPGROUP_PRIVILEGES','ALL_REPGROUPED_COLUMN','ALL_REPKEY_COLUMNS','ALL_REPOBJECT','ALL_REPPARAMETER_COLUMN','ALL_REPPRIORITY','ALL_REPPRIORITY_GROUP','ALL_REPPROP','ALL_REPRESOL_STATS_CONTROL','ALL_REPRESOLUTION','ALL_REPRESOLUTION_METHOD','ALL_REPRESOLUTION_STATISTICS','ALL_REPSCHEMA','ALL_REPSITES','ALL_REWRITE_EQUIVALENCES','ALL_RULE_SET_RULES','ALL_RULE_SETS','ALL_RULES','ALL_RULESETS','ALL_SCHEDULER_CHAIN_RULES','ALL_SCHEDULER_CHAIN_STEPS','ALL_SCHEDULER_CHAINS','ALL_SCHEDULER_GLOBAL_ATTRIBUTE','ALL_SCHEDULER_JOB_ARGS','ALL_SCHEDULER_JOB_CLASSES','ALL_SCHEDULER_JOB_LOG','ALL_SCHEDULER_JOB_RUN_DETAILS','ALL_SCHEDULER_JOBS','ALL_SCHEDULER_PROGRAM_ARGS','ALL_SCHEDULER_PROGRAMS','ALL_SCHEDULER_RUNNING_CHAINS','ALL_SCHEDULER_RUNNING_JOBS','ALL_SCHEDULER_SCHEDULES','ALL_SCHEDULER_WINDOW_DETAILS','ALL_SCHEDULER_WINDOW_GROUPS','ALL_SCHEDULER_WINDOW_LOG','ALL_SCHEDULER_WINDOWS','ALL_SCHEDULER_WINGROUP_MEMBERS','ALL_SDO_GEOM_METADATA','ALL_SDO_INDEX_INFO','ALL_SDO_INDEX_METADATA','ALL_SDO_LRS_METADATA','ALL_SDO_MAPS','ALL_SDO_STYLES','ALL_SDO_THEMES','ALL_SDO_TOPO_INFO','ALL_SDO_TOPO_METADATA','ALL_SEC_RELEVANT_COLS','ALL_SECONDARY_OBJECTS','ALL_SEQUENCES','ALL_SERVICES','ALL_SNAPSHOT_LOGS','ALL_SNAPSHOTS','ALL_SOURCE','ALL_SOURCE_TABLES','ALL_SQLJ_TYPE_ATTRS','ALL_SQLJ_TYPE_METHODS','ALL_SQLJ_TYPES','ALL_SQLSET','ALL_SQLSET_BINDS','ALL_SQLSET_PLANS','ALL_SQLSET_REFERENCES','ALL_SQLSET_STATEMENTS','ALL_STORED_SETTINGS','ALL_STREAMS_GLOBAL_RULES','ALL_STREAMS_MESSAGE_CONSUMERS','ALL_STREAMS_MESSAGE_RULES','ALL_STREAMS_NEWLY_SUPPORTED','ALL_STREAMS_RULES','ALL_STREAMS_SCHEMA_RULES','ALL_STREAMS_TABLE_RULES','ALL_STREAMS_TRANSFORM_FUNCTION','ALL_STREAMS_UNSUPPORTED','ALL_SUBPART_COL_STATISTICS','ALL_SUBPART_HISTOGRAMS','ALL_SUBPART_KEY_COLUMNS','ALL_SUBPARTITION_TEMPLATES','ALL_SUBSCRIBED_COLUMNS','ALL_SUBSCRIBED_TABLES','ALL_SUBSCRIPTIONS','ALL_SUMDELTA','ALL_SUMMARIES','ALL_SUMMARY_AGGREGATES','ALL_SUMMARY_DETAIL_TABLES','ALL_SUMMARY_JOINS','ALL_SUMMARY_KEYS','ALL_SYNONYMS','ALL_TAB_COL_STATISTICS','ALL_TAB_COLS','ALL_TAB_COLUMNS','ALL_TAB_COMMENTS','ALL_TAB_HISTOGRAMS','ALL_TAB_MODIFICATIONS','ALL_TAB_PARTITIONS','ALL_TAB_PRIVS','ALL_TAB_PRIVS_MADE','ALL_TAB_PRIVS_RECD','ALL_TAB_STATISTICS','ALL_TAB_STATS_HISTORY','ALL_TAB_SUBPARTITIONS','ALL_TABLES','ALL_TRIGGER_COLS','ALL_TRIGGERS','ALL_TYPE_ATTRS','ALL_TYPE_METHODS','ALL_TYPE_VERSIONS','ALL_TYPES','ALL_UNUSED_COL_TABS','ALL_UPDATABLE_COLUMNS','ALL_USERS','ALL_USTATS','ALL_VARRAYS','ALL_VIEWS','ALL_WARNING_SETTINGS','ALL_XML_INDEXES','ALL_XML_SCHEMAS','ALL_XML_SCHEMAS2','ALL_XML_TAB_COLS','ALL_XML_TABLES','ALL_XML_VIEW_COLS','ALL_XML_VIEWS','AQ$_ALERT_QT_F','AQ$_AQ$_MEM_MC_F','AQ$_AQ_EVENT_TABLE_F','AQ$_AQ_SRVNTFN_TABLE_F','AQ$_DEF$_AQCALL_F','AQ$_DEF$_AQERROR_F','AQ$_KUPC$DATAPUMP_QUETAB_F','AQ$_SCHEDULER$_EVENT_QTAB_F','AQ$_SCHEDULER$_JOBQTAB_F','AQ$_SYS$SERVICE_METRICS_TAB_F','AQ$ALERT_QT','AQ$ALERT_QT_R','AQ$ALERT_QT_S','AQ$AQ$_MEM_MC','AQ$AQ$_MEM_MC_S','AQ$AQ_EVENT_TABLE','AQ$AQ_SRVNTFN_TABLE','AQ$DEF$_AQCALL','AQ$DEF$_AQERROR','AQ$INTERNET_USERS','AQ$KUPC$DATAPUMP_QUETAB','AQ$KUPC$DATAPUMP_QUETAB_S','AQ$SCHEDULER$_EVENT_QTAB','AQ$SCHEDULER$_EVENT_QTAB_R','AQ$SCHEDULER$_EVENT_QTAB_S','AQ$SCHEDULER$_JOBQTAB','AQ$SCHEDULER$_JOBQTAB_R','AQ$SCHEDULER$_JOBQTAB_S','AQ$SYS$SERVICE_METRICS_TAB','AQ$SYS$SERVICE_METRICS_TAB_R','AQ$SYS$SERVICE_METRICS_TAB_S','CATALOG','CHANGE_PROPAGATION_SETS','CHANGE_PROPAGATIONS','CHANGE_SETS','CHANGE_SOURCES','CHANGE_TABLES','CODE_PIECES','CODE_SIZE','COL','COLUMN_PRIVILEGES','CS_SRS','CTX_CLASSES','CTX_INDEX_ERRORS','CTX_INDEX_OBJECTS','CTX_INDEX_PARTITIONS','CTX_INDEX_SET_INDEXES','CTX_INDEX_SETS','CTX_INDEX_SUB_LEXER_VALUES','CTX_INDEX_SUB_LEXERS','CTX_INDEX_VALUES','CTX_INDEXES','CTX_OBJECT_ATTRIBUTE_LOV','CTX_OBJECT_ATTRIBUTES','CTX_OBJECTS','CTX_PARAMETERS','CTX_PENDING','CTX_PREFERENCE_VALUES','CTX_PREFERENCES','CTX_SECTION_GROUPS','CTX_SECTIONS','CTX_SQES','CTX_STOPLISTS','CTX_STOPWORDS','CTX_SUB_LEXERS','CTX_THES_PHRASES','CTX_THESAURI','CTX_TRACE_VALUES','CTX_USER_INDEX_ERRORS','CTX_USER_INDEX_OBJECTS','CTX_USER_INDEX_PARTITIONS','CTX_USER_INDEX_SET_INDEXES','CTX_USER_INDEX_SETS','CTX_USER_INDEX_SUB_LEXER_VALS','CTX_USER_INDEX_SUB_LEXERS','CTX_USER_INDEX_VALUES','CTX_USER_INDEXES','CTX_USER_PENDING','CTX_USER_PREFERENCE_VALUES','CTX_USER_PREFERENCES','CTX_USER_SECTION_GROUPS','CTX_USER_SECTIONS','CTX_USER_SQES','CTX_USER_STOPLISTS','CTX_USER_STOPWORDS','CTX_USER_SUB_LEXERS','CTX_USER_THES_PHRASES','CTX_USER_THESAURI','CTX_VERSION','DATABASE_COMPATIBLE_LEVEL','DATABASE_EXPORT_OBJECTS','DATABASE_PROPERTIES','DATAPUMP_DDL_TRANSFORM_PARAMS','DATAPUMP_OBJECT_CONNECT','DATAPUMP_PATHMAP','DATAPUMP_PATHS','DATAPUMP_REMAP_OBJECTS','DATAPUMP_TABLE_DATA','DBA_2PC_NEIGHBORS','DBA_2PC_PENDING','DBA_ADVISOR_ACTIONS','DBA_ADVISOR_COMMANDS','DBA_ADVISOR_DEF_PARAMETERS','DBA_ADVISOR_DEFINITIONS','DBA_ADVISOR_DIRECTIVES','DBA_ADVISOR_FINDINGS','DBA_ADVISOR_JOURNAL','DBA_ADVISOR_LOG','DBA_ADVISOR_OBJECT_TYPES','DBA_ADVISOR_OBJECTS','DBA_ADVISOR_PARAMETERS','DBA_ADVISOR_PARAMETERS_PROJ','DBA_ADVISOR_RATIONALE','DBA_ADVISOR_RECOMMENDATIONS','DBA_ADVISOR_SQLA_REC_SUM','DBA_ADVISOR_SQLA_WK_MAP','DBA_ADVISOR_SQLA_WK_STMTS','DBA_ADVISOR_SQLW_COLVOL','DBA_ADVISOR_SQLW_JOURNAL','DBA_ADVISOR_SQLW_PARAMETERS','DBA_ADVISOR_SQLW_STMTS','DBA_ADVISOR_SQLW_SUM','DBA_ADVISOR_SQLW_TABLES','DBA_ADVISOR_SQLW_TABVOL','DBA_ADVISOR_SQLW_TEMPLATES','DBA_ADVISOR_TASKS','DBA_ADVISOR_TEMPLATES','DBA_ADVISOR_USAGE','DBA_ALERT_ARGUMENTS','DBA_ALERT_HISTORY','DBA_ALL_TABLES','DBA_ANALYZE_OBJECTS','DBA_APPLICATION_ROLES','DBA_APPLY','DBA_APPLY_CONFLICT_COLUMNS','DBA_APPLY_DML_HANDLERS','DBA_APPLY_ENQUEUE','DBA_APPLY_ERROR','DBA_APPLY_EXECUTE','DBA_APPLY_INSTANTIATED_GLOBAL','DBA_APPLY_INSTANTIATED_OBJECTS','DBA_APPLY_INSTANTIATED_SCHEMAS','DBA_APPLY_KEY_COLUMNS','DBA_APPLY_PARAMETERS','DBA_APPLY_PROGRESS','DBA_APPLY_SPILL_TXN','DBA_APPLY_TABLE_COLUMNS','DBA_AQ_AGENT_PRIVS','DBA_AQ_AGENTS','DBA_ASSOCIATIONS','DBA_ATTRIBUTE_TRANSFORMATIONS','DBA_AUDIT_EXISTS','DBA_AUDIT_OBJECT','DBA_AUDIT_POLICIES','DBA_AUDIT_POLICY_COLUMNS','DBA_AUDIT_SESSION','DBA_AUDIT_STATEMENT','DBA_AUDIT_TRAIL','DBA_AUTO_SEGADV_CTL','DBA_AUTO_SEGADV_SUMMARY','DBA_AW_PS','DBA_AWS','DBA_BASE_TABLE_MVIEWS','DBA_BLOCKERS','DBA_CACHEABLE_NONTABLE_OBJECTS','DBA_CACHEABLE_OBJECTS','DBA_CACHEABLE_OBJECTS_BASE','DBA_CACHEABLE_TABLES','DBA_CACHEABLE_TABLES_BASE','DBA_CAPTURE','DBA_CAPTURE_EXTRA_ATTRIBUTES','DBA_CAPTURE_PARAMETERS','DBA_CAPTURE_PREPARED_DATABASE','DBA_CAPTURE_PREPARED_SCHEMAS','DBA_CAPTURE_PREPARED_TABLES','DBA_CATALOG','DBA_CHANGE_NOTIFICATION_REGS','DBA_CLU_COLUMNS','DBA_CLUSTER_HASH_EXPRESSIONS','DBA_CLUSTERS','DBA_COL_COMMENTS','DBA_COL_PRIVS','DBA_COLL_TYPES','DBA_COMMON_AUDIT_TRAIL','DBA_CONNECT_ROLE_GRANTEES','DBA_CONS_COLUMNS','DBA_CONS_OBJ_COLUMNS','DBA_CONSTRAINTS','DBA_CONTEXT','DBA_CPU_USAGE_STATISTICS','DBA_DATA_FILES','DBA_DATAPUMP_JOBS','DBA_DATAPUMP_SESSIONS','DBA_DB_LINKS','DBA_DDL_LOCKS','DBA_DEPENDENCIES','DBA_DIM_ATTRIBUTES','DBA_DIM_CHILD_OF','DBA_DIM_HIERARCHIES','DBA_DIM_JOIN_KEY','DBA_DIM_LEVEL_KEY','DBA_DIM_LEVELS','DBA_DIMENSIONS','DBA_DIRECTORIES','DBA_DML_LOCKS','DBA_DMT_FREE_SPACE','DBA_DMT_USED_EXTENTS','DBA_ENABLED_AGGREGATIONS','DBA_ENABLED_TRACES','DBA_ENCRYPTED_COLUMNS','DBA_EPG_DAD_AUTHORIZATION','DBA_ERRORS','DBA_EVALUATION_CONTEXT_TABLES','DBA_EVALUATION_CONTEXT_VARS','DBA_EVALUATION_CONTEXTS','DBA_EXP_FILES','DBA_EXP_OBJECTS','DBA_EXP_VERSION','DBA_EXPORT_OBJECTS','DBA_EXTENTS','DBA_EXTERNAL_LOCATIONS','DBA_EXTERNAL_TABLES','DBA_FEATURE_USAGE_STATISTICS','DBA_FGA_AUDIT_TRAIL','DBA_FILE_GROUP_EXPORT_INFO','DBA_FILE_GROUP_FILES','DBA_FILE_GROUP_TABLES','DBA_FILE_GROUP_TABLESPACES','DBA_FILE_GROUP_VERSIONS','DBA_FILE_GROUPS','DBA_FREE_SPACE','DBA_FREE_SPACE_COALESCED','DBA_FREE_SPACE_COALESCED_TMP1','DBA_FREE_SPACE_COALESCED_TMP2','DBA_FREE_SPACE_COALESCED_TMP3','DBA_FREE_SPACE_COALESCED_TMP4','DBA_FREE_SPACE_COALESCED_TMP5','DBA_FREE_SPACE_COALESCED_TMP6','DBA_GEOMETRY_COLUMNS','DBA_GLOBAL_CONTEXT','DBA_HIGH_WATER_MARK_STATISTICS','DBA_HIST_ACTIVE_SESS_HISTORY','DBA_HIST_BASELINE','DBA_HIST_BG_EVENT_SUMMARY','DBA_HIST_BUFFER_POOL_STAT','DBA_HIST_BUFFERED_QUEUES','DBA_HIST_BUFFERED_SUBSCRIBERS','DBA_HIST_COMP_IOSTAT','DBA_HIST_CR_BLOCK_SERVER','DBA_HIST_CURRENT_BLOCK_SERVER','DBA_HIST_DATABASE_INSTANCE','DBA_HIST_DATAFILE','DBA_HIST_DB_CACHE_ADVICE','DBA_HIST_DLM_MISC','DBA_HIST_ENQUEUE_STAT','DBA_HIST_EVENT_NAME','DBA_HIST_FILEMETRIC_HISTORY','DBA_HIST_FILESTATXS','DBA_HIST_INST_CACHE_TRANSFER','DBA_HIST_INSTANCE_RECOVERY','DBA_HIST_JAVA_POOL_ADVICE','DBA_HIST_LATCH','DBA_HIST_LATCH_CHILDREN','DBA_HIST_LATCH_MISSES_SUMMARY','DBA_HIST_LATCH_NAME','DBA_HIST_LATCH_PARENT','DBA_HIST_LIBRARYCACHE','DBA_HIST_LOG','DBA_HIST_METRIC_NAME','DBA_HIST_MTTR_TARGET_ADVICE','DBA_HIST_OPTIMIZER_ENV','DBA_HIST_OSSTAT','DBA_HIST_OSSTAT_NAME','DBA_HIST_PARAMETER','DBA_HIST_PARAMETER_NAME','DBA_HIST_PGA_TARGET_ADVICE','DBA_HIST_PGASTAT','DBA_HIST_PROCESS_MEM_SUMMARY','DBA_HIST_RESOURCE_LIMIT','DBA_HIST_ROWCACHE_SUMMARY','DBA_HIST_RULE_SET','DBA_HIST_SEG_STAT','DBA_HIST_SEG_STAT_OBJ','DBA_HIST_SERVICE_NAME','DBA_HIST_SERVICE_STAT','DBA_HIST_SERVICE_WAIT_CLASS','DBA_HIST_SESS_TIME_STATS','DBA_HIST_SESSMETRIC_HISTORY','DBA_HIST_SGA','DBA_HIST_SGA_TARGET_ADVICE','DBA_HIST_SGASTAT','DBA_HIST_SHARED_POOL_ADVICE','DBA_HIST_SNAP_ERROR','DBA_HIST_SNAPSHOT','DBA_HIST_SQL_BIND_METADATA','DBA_HIST_SQL_PLAN','DBA_HIST_SQL_SUMMARY','DBA_HIST_SQL_WORKAREA_HSTGRM','DBA_HIST_SQLBIND','DBA_HIST_SQLSTAT','DBA_HIST_SQLTEXT','DBA_HIST_STAT_NAME','DBA_HIST_STREAMS_APPLY_SUM','DBA_HIST_STREAMS_CAPTURE','DBA_HIST_STREAMS_POOL_ADVICE','DBA_HIST_SYS_TIME_MODEL','DBA_HIST_SYSMETRIC_HISTORY','DBA_HIST_SYSMETRIC_SUMMARY','DBA_HIST_SYSSTAT','DBA_HIST_SYSTEM_EVENT','DBA_HIST_TABLESPACE_STAT','DBA_HIST_TBSPC_SPACE_USAGE','DBA_HIST_TEMPFILE','DBA_HIST_TEMPSTATXS','DBA_HIST_THREAD','DBA_HIST_UNDOSTAT','DBA_HIST_WAITCLASSMET_HISTORY','DBA_HIST_WAITSTAT','DBA_HIST_WR_CONTROL','DBA_IAS_CONSTRAINT_EXP','DBA_IAS_GEN_STMTS','DBA_IAS_GEN_STMTS_EXP','DBA_IAS_OBJECTS','DBA_IAS_OBJECTS_BASE','DBA_IAS_OBJECTS_EXP','DBA_IAS_POSTGEN_STMTS','DBA_IAS_PREGEN_STMTS','DBA_IAS_SITES','DBA_IAS_TEMPLATES','DBA_IND_COLUMNS','DBA_IND_EXPRESSIONS','DBA_IND_PARTITIONS','DBA_IND_STATISTICS','DBA_IND_SUBPARTITIONS','DBA_INDEXES','DBA_INDEXTYPE_ARRAYTYPES','DBA_INDEXTYPE_COMMENTS','DBA_INDEXTYPE_OPERATORS','DBA_INDEXTYPES','DBA_INTERNAL_TRIGGERS','DBA_JOBS','DBA_JOBS_RUNNING','DBA_JOIN_IND_COLUMNS','DBA_KGLLOCK','DBA_LIBRARIES','DBA_LMT_FREE_SPACE','DBA_LMT_USED_EXTENTS','DBA_LOB_PARTITIONS','DBA_LOB_SUBPARTITIONS','DBA_LOB_TEMPLATES','DBA_LOBS','DBA_LOCK','DBA_LOCK_INTERNAL','DBA_LOG_GROUP_COLUMNS','DBA_LOG_GROUPS','DBA_LOGMNR_LOG','DBA_LOGMNR_PURGED_LOG','DBA_LOGMNR_SESSION','DBA_LOGSTDBY_EVENTS','DBA_LOGSTDBY_HISTORY','DBA_LOGSTDBY_LOG','DBA_LOGSTDBY_NOT_UNIQUE','DBA_LOGSTDBY_PARAMETERS','DBA_LOGSTDBY_PROGRESS','DBA_LOGSTDBY_SKIP','DBA_LOGSTDBY_SKIP_TRANSACTION','DBA_LOGSTDBY_UNSUPPORTED','DBA_METHOD_PARAMS','DBA_METHOD_RESULTS','DBA_MVIEW_AGGREGATES','DBA_MVIEW_ANALYSIS','DBA_MVIEW_COMMENTS','DBA_MVIEW_DETAIL_RELATIONS','DBA_MVIEW_JOINS','DBA_MVIEW_KEYS','DBA_MVIEW_LOG_FILTER_COLS','DBA_MVIEW_LOGS','DBA_MVIEW_REFRESH_TIMES','DBA_MVIEWS','DBA_NESTED_TABLE_COLS','DBA_NESTED_TABLES','DBA_OBJ_AUDIT_OPTS','DBA_OBJ_COLATTRS','DBA_OBJECT_SIZE','DBA_OBJECT_TABLES','DBA_OBJECTS','DBA_OPANCILLARY','DBA_OPARGUMENTS','DBA_OPBINDINGS','DBA_OPERATOR_COMMENTS','DBA_OPERATORS','DBA_OPTSTAT_OPERATIONS','DBA_OUTLINE_HINTS','DBA_OUTLINES','DBA_OUTSTANDING_ALERTS','DBA_PART_COL_STATISTICS','DBA_PART_HISTOGRAMS','DBA_PART_INDEXES','DBA_PART_KEY_COLUMNS','DBA_PART_LOBS','DBA_PART_TABLES','DBA_PARTIAL_DROP_TABS','DBA_PENDING_CONV_TABLES','DBA_PENDING_TRANSACTIONS','DBA_PLSQL_OBJECT_SETTINGS','DBA_POLICIES','DBA_POLICY_CONTEXTS','DBA_POLICY_GROUPS','DBA_PRIV_AUDIT_OPTS','DBA_PROCEDURES','DBA_PROFILES','DBA_PROPAGATION','DBA_PROXIES','DBA_PUBLISHED_COLUMNS','DBA_QUEUE_PUBLISHERS','DBA_QUEUE_SCHEDULES','DBA_QUEUE_SUBSCRIBERS','DBA_QUEUE_TABLES','DBA_QUEUES','DBA_RCHILD','DBA_RECOVERABLE_SCRIPT','DBA_RECOVERABLE_SCRIPT_BLOCKS','DBA_RECOVERABLE_SCRIPT_ERRORS','DBA_RECOVERABLE_SCRIPT_PARAMS','DBA_RECYCLEBIN','DBA_REDEFINITION_ERRORS','DBA_REDEFINITION_OBJECTS','DBA_REFRESH','DBA_REFRESH_CHILDREN','DBA_REFS','DBA_REGISTERED_ARCHIVED_LOG','DBA_REGISTERED_MVIEW_GROUPS','DBA_REGISTERED_MVIEWS','DBA_REGISTERED_SNAPSHOT_GROUPS','DBA_REGISTERED_SNAPSHOTS','DBA_REGISTRY','DBA_REGISTRY_HIERARCHY','DBA_REGISTRY_HISTORY','DBA_REGISTRY_LOG','DBA_REPAUDIT_ATTRIBUTE','DBA_REPAUDIT_COLUMN','DBA_REPCAT','DBA_REPCAT_EXCEPTIONS','DBA_REPCAT_REFRESH_TEMPLATES','DBA_REPCAT_TEMPLATE_OBJECTS','DBA_REPCAT_TEMPLATE_PARMS','DBA_REPCAT_TEMPLATE_SITES','DBA_REPCAT_USER_AUTHORIZATIONS','DBA_REPCAT_USER_PARM_VALUES','DBA_REPCATLOG','DBA_REPCOLUMN','DBA_REPCOLUMN_GROUP','DBA_REPCONFLICT','DBA_REPDDL','DBA_REPEXTENSIONS','DBA_REPFLAVOR_COLUMNS','DBA_REPFLAVOR_OBJECTS','DBA_REPFLAVORS','DBA_REPGENERATED','DBA_REPGENOBJECTS','DBA_REPGROUP','DBA_REPGROUP_PRIVILEGES','DBA_REPGROUPED_COLUMN','DBA_REPKEY_COLUMNS','DBA_REPOBJECT','DBA_REPPARAMETER_COLUMN','DBA_REPPRIORITY','DBA_REPPRIORITY_GROUP','DBA_REPPROP','DBA_REPRESOL_STATS_CONTROL','DBA_REPRESOLUTION','DBA_REPRESOLUTION_METHOD','DBA_REPRESOLUTION_STATISTICS','DBA_REPSCHEMA','DBA_REPSITES','DBA_REPSITES_NEW','DBA_RESOURCE_INCARNATIONS','DBA_RESUMABLE','DBA_REWRITE_EQUIVALENCES','DBA_RGROUP','DBA_ROLE_PRIVS','DBA_ROLES','DBA_ROLLBACK_SEGS','DBA_RSRC_CONSUMER_GROUP_PRIVS','DBA_RSRC_CONSUMER_GROUPS','DBA_RSRC_GROUP_MAPPINGS','DBA_RSRC_MANAGER_SYSTEM_PRIVS','DBA_RSRC_MAPPING_PRIORITY','DBA_RSRC_PLAN_DIRECTIVES','DBA_RSRC_PLANS','DBA_RULE_SET_RULES','DBA_RULE_SETS','DBA_RULES','DBA_RULESETS','DBA_SCHEDULER_CHAIN_RULES','DBA_SCHEDULER_CHAIN_STEPS','DBA_SCHEDULER_CHAINS','DBA_SCHEDULER_GLOBAL_ATTRIBUTE','DBA_SCHEDULER_JOB_ARGS','DBA_SCHEDULER_JOB_CLASSES','DBA_SCHEDULER_JOB_LOG','DBA_SCHEDULER_JOB_RUN_DETAILS','DBA_SCHEDULER_JOBS','DBA_SCHEDULER_PROGRAM_ARGS','DBA_SCHEDULER_PROGRAMS','DBA_SCHEDULER_RUNNING_CHAINS','DBA_SCHEDULER_RUNNING_JOBS','DBA_SCHEDULER_SCHEDULES','DBA_SCHEDULER_WINDOW_DETAILS','DBA_SCHEDULER_WINDOW_GROUPS','DBA_SCHEDULER_WINDOW_LOG','DBA_SCHEDULER_WINDOWS','DBA_SCHEDULER_WINGROUP_MEMBERS','DBA_SDO_MAPS','DBA_SDO_STYLES','DBA_SDO_THEMES','DBA_SEC_RELEVANT_COLS','DBA_SECONDARY_OBJECTS','DBA_SEGMENTS','DBA_SEGMENTS_OLD','DBA_SEQUENCES','DBA_SERVER_REGISTRY','DBA_SERVICES','DBA_SNAPSHOT_LOGS','DBA_SNAPSHOTS','DBA_SOURCE','DBA_SOURCE_TABLES','DBA_SQL_PROFILES','DBA_SQLJ_TYPE_ATTRS','DBA_SQLJ_TYPE_METHODS','DBA_SQLJ_TYPES','DBA_SQLSET','DBA_SQLSET_BINDS','DBA_SQLSET_PLANS','DBA_SQLSET_REFERENCES','DBA_SQLSET_STATEMENTS','DBA_SQLTUNE_BINDS','DBA_SQLTUNE_PLANS','DBA_SQLTUNE_RATIONALE_PLAN','DBA_SQLTUNE_STATISTICS','DBA_STMT_AUDIT_OPTS','DBA_STORED_SETTINGS','DBA_STREAMS_ADD_COLUMN','DBA_STREAMS_ADMINISTRATOR','DBA_STREAMS_DELETE_COLUMN','DBA_STREAMS_GLOBAL_RULES','DBA_STREAMS_MESSAGE_CONSUMERS','DBA_STREAMS_MESSAGE_RULES','DBA_STREAMS_NEWLY_SUPPORTED','DBA_STREAMS_RENAME_COLUMN','DBA_STREAMS_RENAME_SCHEMA','DBA_STREAMS_RENAME_TABLE','DBA_STREAMS_RULES','DBA_STREAMS_SCHEMA_RULES','DBA_STREAMS_TABLE_RULES','DBA_STREAMS_TRANSFORM_FUNCTION','DBA_STREAMS_TRANSFORMATIONS','DBA_STREAMS_UNSUPPORTED','DBA_SUBPART_COL_STATISTICS','DBA_SUBPART_HISTOGRAMS','DBA_SUBPART_KEY_COLUMNS','DBA_SUBPARTITION_TEMPLATES','DBA_SUBSCRIBED_COLUMNS','DBA_SUBSCRIBED_TABLES','DBA_SUBSCRIPTIONS','DBA_SUMMARIES','DBA_SUMMARY_AGGREGATES','DBA_SUMMARY_DETAIL_TABLES','DBA_SUMMARY_JOINS','DBA_SUMMARY_KEYS','DBA_SYNONYMS','DBA_SYS_PRIVS','DBA_TAB_COL_STATISTICS','DBA_TAB_COLS','DBA_TAB_COLUMNS','DBA_TAB_COMMENTS','DBA_TAB_HISTOGRAMS','DBA_TAB_MODIFICATIONS','DBA_TAB_PARTITIONS','DBA_TAB_PRIVS','DBA_TAB_STATISTICS','DBA_TAB_STATS_HISTORY','DBA_TAB_SUBPARTITIONS','DBA_TABLES','DBA_TABLESPACE_GROUPS','DBA_TABLESPACE_USAGE_METRICS','DBA_TABLESPACES','DBA_TEMP_FILES','DBA_TEMPLATE_REFGROUPS','DBA_TEMPLATE_TARGETS','DBA_THRESHOLDS','DBA_TRANSFORMATIONS','DBA_TRIGGER_COLS','DBA_TRIGGERS','DBA_TS_QUOTAS','DBA_TSM_DESTINATION','DBA_TSM_HISTORY','DBA_TSM_SOURCE','DBA_TUNE_MVIEW','DBA_TYPE_ATTRS','DBA_TYPE_METHODS','DBA_TYPE_VERSIONS','DBA_TYPES','DBA_UNDO_EXTENTS','DBA_UNUSED_COL_TABS','DBA_UPDATABLE_COLUMNS','DBA_USERS','DBA_USTATS','DBA_VARRAYS','DBA_VIEWS','DBA_WAITERS','DBA_WARNING_SETTINGS','DBA_XML_INDEXES','DBA_XML_SCHEMAS','DBA_XML_TAB_COLS','DBA_XML_TABLES','DBA_XML_VIEW_COLS','DBA_XML_VIEWS','DBMS_UPG_CURRENT_STATUS','DBMS_UPG_STATUS','DBMSHSXP_SQL_PROFILE_ATTR','DEFCALL','DEFCALLDEST','DEFDEFAULTDEST','DEFERRCOUNT','DEFERROR','DEFLOB','DEFPROPAGATOR','DEFSCHEDULE','DEFTRAN','DEFTRANDEST','DICT_COLUMNS','DICTIONARY','DISK_AND_FIXED_OBJECTS','DRV$DELETE','DRV$DELETE2','DRV$ONLINE_PENDING','DRV$PENDING','DRV$UNINDEXED','DRV$UNINDEXED2','DRV$WAITING','EMP_DETAILS_VIEW','ERROR_SIZE','EXPCOMPRESSEDPART','EXPCOMPRESSEDSUB','EXPCOMPRESSEDTAB','EXPEXEMPT','EXPGETENCCOLNAM','EXPTABSUBPART','EXPTABSUBPARTDATA_VIEW','EXPTABSUBPARTLOB_VIEW','EXPTABSUBPARTLOBFRAG','EXU102XTYP','EXU102XTYPU','EXU10ADEFPSWITCHES','EXU10AOBJSWITCH','EXU10ASC','EXU10ASCU','EXU10CCL','EXU10CCLO','EXU10CCLU','EXU10COE','EXU10COEU','EXU10DEFPSWITCHES','EXU10DOSO')");
sql.AppendLine(@"AND view_name NOT IN ('EXU10IND_BASE','EXU10LNK','EXU10LNKU','EXU10MVL','EXU10MVLU','EXU10NTA','EXU10NTAROLE','EXU10OBJSWITCH','EXU10R2DEFPSWITCHES','EXU10R2OBJSWITCH','EXU10SNAP','EXU10SNAPI','EXU10SNAPL','EXU10SNAPLC','EXU10SNAPLI','EXU10SNAPLU','EXU10SNAPU','EXU10TAB','EXU10TABS','EXU10TABSU','EXU10TABU','EXU816CTX','EXU816MAXSQV','EXU816SQV','EXU816TCTX','EXU816TGR','EXU816TGRC','EXU816TGRI','EXU816TGRIC','EXU816TGRU','EXU81ACTIONOBJ','EXU81ACTIONPKG','EXU81APPROLE','EXU81ASSOC','EXU81CSC','EXU81CTX','EXU81DOI','EXU81DOIU','EXU81FIL','EXU81IND','EXU81IND_BASE','EXU81INDC','EXU81INDI','EXU81INDIC','EXU81ITY','EXU81ITYC','EXU81ITYI','EXU81ITYU','EXU81IXCP','EXU81IXCPU','EXU81IXSP','EXU81IXSPU','EXU81JAV','EXU81JAVC','EXU81JAVI','EXU81JAVT','EXU81LBCP','EXU81LBCPU','EXU81LBP','EXU81LBPU','EXU81LBSP','EXU81LBSPU','EXU81NOS','EXU81OBJ','EXU81OBJECTPKG','EXU81OPR','EXU81OPRC','EXU81OPRI','EXU81OPRU','EXU81PLB','EXU81PLBU','EXU81PROCOBJ','EXU81PROCOBJINSTANCE','EXU81PSTC','EXU81PSTI','EXU81REFC','EXU81REFI','EXU81RGC','EXU81RGCU','EXU81RGS','EXU81RGSU','EXU81RLS','EXU81SCM','EXU81SCMU','EXU81SLFC','EXU81SLFCU','EXU81SNAP','EXU81SNAPC','EXU81SNAPI','EXU81SNAPL','EXU81SNAPLC','EXU81SNAPLI','EXU81SNAPLU','EXU81SNAPU','EXU81SPOK','EXU81SPOKI','EXU81SPOKIU','EXU81SPOKU','EXU81SRT','EXU81SRTU','EXU81TAB','EXU81TABC','EXU81TABI','EXU81TABS','EXU81TABSU','EXU81TABU','EXU81TBCP','EXU81TBCPU','EXU81TBS','EXU81TBSP','EXU81TBSPU','EXU81TGR','EXU81TGRC','EXU81TGRI','EXU81TGRIC','EXU81TGRU','EXU81TNTC','EXU81TNTI','EXU81TTS','EXU81TYP','EXU81TYPU','EXU81USCI','EXU81USCIU','EXU8ANAL','EXU8ASC','EXU8ASCU','EXU8AUD','EXU8BSZ','EXU8CCL','EXU8CCLO','EXU8CCLU','EXU8CCO','EXU8CCOU','EXU8CGR','EXU8CGRU','EXU8CLU','EXU8CLUC','EXU8CLUI','EXU8CLUU','EXU8CMT','EXU8CMTU','EXU8COE','EXU8COEU','EXU8COL','EXU8COL_TEMP','EXU8COL_TEMP_TTS_UNUSED_COL','EXU8COL_TTS_UNUSED_COL','EXU8COLNN','EXU8COLU','EXU8CON','EXU8CONU','EXU8COO','EXU8COOU','EXU8CPO','EXU8CSET','EXU8CSN','EXU8CSNU','EXU8DEL','EXU8DELSNAP','EXU8DELSNAPL','EXU8DFR','EXU8DIM','EXU8DIMC','EXU8DIMI','EXU8DIMU','EXU8DIR','EXU8ERC','EXU8FIL','EXU8FPT','EXU8FPTU','EXU8FUL','EXU8GLOB','EXU8GRN','EXU8GRNU','EXU8GRS','EXU8HST','EXU8HSTU','EXU8ICO','EXU8ICOU','EXU8ICPLSQL','EXU8IND','EXU8INDC','EXU8INDI','EXU8INDIC','EXU8INDU','EXU8INK','EXU8INKU','EXU8IOV','EXU8IOVU','EXU8IXP','EXU8IXPU','EXU8JBQ','EXU8JBQU','EXU8LIB','EXU8LIBU','EXU8LNK','EXU8LNKU','EXU8LOB','EXU8LOBU','EXU8NTB','EXU8NTBU','EXU8NXP','EXU8NXPU','EXU8OID','EXU8OIDU','EXU8OPT','EXU8ORD','EXU8ORDU','EXU8ORFS','EXU8PDS','EXU8PDSU','EXU8PHS','EXU8PNT','EXU8PNTU','EXU8POK','EXU8POKI','EXU8POKIU','EXU8POKU','EXU8PRF','EXU8PRR','EXU8PST','EXU8PSTC','EXU8PSTI','EXU8PSTIC','EXU8PSTU','EXU8PVF','EXU8REF','EXU8REFC','EXU8REFI','EXU8REFIC','EXU8REFU','EXU8RFS','EXU8RFSU','EXU8RGC','EXU8RGCU','EXU8RGS','EXU8RGSU','EXU8RIF','EXU8RLG','EXU8ROL','EXU8RSG','EXU8SCM','EXU8SCMU','EXU8SEQ','EXU8SEQU','EXU8SLFC','EXU8SLFCU','EXU8SLOG','EXU8SLOGU','EXU8SNAP','EXU8SNAPC','EXU8SNAPI','EXU8SNAPL','EXU8SNAPLC','EXU8SNAPLI','EXU8SNAPLU','EXU8SNAPU','EXU8SPR','EXU8SPRC','EXU8SPRI','EXU8SPS','EXU8SPSU','EXU8SPU','EXU8SPV','EXU8SRT','EXU8SRTU','EXU8STO','EXU8STOU','EXU8SYN','EXU8SYNC','EXU8SYNI','EXU8SYNU','EXU8TAB','EXU8TABC','EXU8TABI','EXU8TABU','EXU8TBP','EXU8TBPU','EXU8TBS','EXU8TGR','EXU8TGRC','EXU8TGRI','EXU8TGRIC','EXU8TGRU','EXU8TNE','EXU8TNEB','EXU8TNTC','EXU8TNTI','EXU8TNTIC','EXU8TSL','EXU8TSN','EXU8TSQ','EXU8TYP','EXU8TYPB','EXU8TYPBU','EXU8TYPT','EXU8TYPTU','EXU8TYPU','EXU8USCU','EXU8USR','EXU8USRU','EXU8VDPT','EXU8VDPTU','EXU8VER','EXU8VEW','EXU8VEWC','EXU8VEWI','EXU8VEWU','EXU8VINF','EXU8VINFC','EXU8VINFI','EXU8VINFU','EXU8VNC','EXU8VNCC','EXU8VNCI','EXU8VNCU','EXU92FPT','EXU92FPTP','EXU92FPTPU','EXU92FPTU','EXU92ITGR','EXU92TGR','EXU92TGRC','EXU92TGRI','EXU92TGRIC','EXU92TGRU','EXU92TSP','EXU92TSPL','EXU9ACTIONOBJ','EXU9BJF','EXU9BJW','EXU9CCL','EXU9CCLO','EXU9CCLU','EXU9COE','EXU9COEU','EXU9COO','EXU9COO_TTS_UNUSED_COL','EXU9COOU','EXU9DEFPSWITCHES','EXU9DOI','EXU9DOIU','EXU9DOSO','EXU9EIP','EXU9FGA','EXU9FIL','EXU9GSAS','EXU9IND','EXU9IND_BASE','EXU9INDC','EXU9INDI','EXU9INDIC','EXU9INHCOLCONS','EXU9IXCP','EXU9IXCPU','EXU9LBCP','EXU9LBCPU','EXU9LBP','EXU9LBPU','EXU9LNK','EXU9LNKU','EXU9LOB','EXU9LOBU','EXU9LTTS','EXU9MVL','EXU9MVLCDCCC','EXU9MVLCDCS','EXU9MVLCDCSC','EXU9MVLCDCST','EXU9MVLU','EXU9NLS','EXU9NOS','EXU9NTA','EXU9NTAROLE','EXU9OBJSWITCH','EXU9OTNNULL','EXU9PCT','EXU9PDS','EXU9PDSU','EXU9PGP','EXU9PLB','EXU9PLBU','EXU9PSTC','EXU9PSTI','EXU9PTS','EXU9REFC','EXU9REFI','EXU9RLS','EXU9SNAP','EXU9SNAPC','EXU9SNAPI','EXU9SNAPL','EXU9SNAPLC','EXU9SNAPLI','EXU9SNAPLU','EXU9SNAPU','EXU9STO','EXU9STOU','EXU9SYN','EXU9SYNU','EXU9TAB','EXU9TAB_UNUSED_COLS','EXU9TABC','EXU9TABI','EXU9TABS','EXU9TABSU','EXU9TABU','EXU9TBCP','EXU9TBCPU','EXU9TBS','EXU9TGRC','EXU9TGRI','EXU9TNE','EXU9TNEB','EXU9TNTC','EXU9TNTI','EXU9TSQ','EXU9TYP','EXU9TYPT','EXU9TYPT2','EXU9TYPTU','EXU9TYPTU2','EXU9TYPU','EXU9UTS','EXU9UTSU','EXU9XDBUID','EXU9XMLST','EXU9XTB','FILEXT$','FLASHBACK_TRANSACTION_QUERY','FLOW_PARAMETERS','FLOW_SESSIONS','FLOW_SGA','FLOW_SQLAREA','GEODETIC_SRIDS','GLOBAL_CONTEXT','GLOBAL_NAME','GV_$_LOCK','GV_$ACCESS','GV_$ACTIVE_INSTANCES','GV_$ACTIVE_SERVICES','GV_$ACTIVE_SESS_POOL_MTH','GV_$ACTIVE_SESSION_HISTORY','GV_$ADVISOR_PROGRESS','GV_$ALERT_TYPES','GV_$AQ','GV_$AQ1','GV_$ARCHIVE','GV_$ARCHIVE_DEST','GV_$ARCHIVE_DEST_STATUS','GV_$ARCHIVE_GAP','GV_$ARCHIVE_PROCESSES','GV_$ARCHIVED_LOG','GV_$ASM_ALIAS','GV_$ASM_CLIENT','GV_$ASM_DISK','GV_$ASM_DISK_STAT','GV_$ASM_DISKGROUP','GV_$ASM_DISKGROUP_STAT','GV_$ASM_FILE','GV_$ASM_OPERATION','GV_$ASM_TEMPLATE','GV_$AW_AGGREGATE_OP','GV_$AW_ALLOCATE_OP','GV_$AW_CALC','GV_$AW_LONGOPS','GV_$AW_OLAP','GV_$AW_SESSION_INFO','GV_$BACKUP','GV_$BACKUP_ASYNC_IO','GV_$BACKUP_CORRUPTION','GV_$BACKUP_DATAFILE','GV_$BACKUP_DEVICE','GV_$BACKUP_PIECE','GV_$BACKUP_REDOLOG','GV_$BACKUP_SET','GV_$BACKUP_SPFILE','GV_$BACKUP_SYNC_IO','GV_$BGPROCESS','GV_$BH','GV_$BLOCKING_QUIESCE','GV_$BSP','GV_$BUFFER_POOL','GV_$BUFFER_POOL_STATISTICS','GV_$BUFFERED_PUBLISHERS','GV_$BUFFERED_QUEUES','GV_$BUFFERED_SUBSCRIBERS','GV_$CIRCUIT','GV_$CLASS_CACHE_TRANSFER','GV_$CLASS_PING','GV_$CLIENT_STATS','GV_$CLUSTER_INTERCONNECTS','GV_$CONFIGURED_INTERCONNECTS','GV_$CONTEXT','GV_$CONTROLFILE','GV_$CONTROLFILE_RECORD_SECTION','GV_$COPY_CORRUPTION','GV_$CR_BLOCK_SERVER','GV_$CURRENT_BLOCK_SERVER','GV_$DATABASE','GV_$DATABASE_BLOCK_CORRUPTION','GV_$DATABASE_INCARNATION','GV_$DATAFILE','GV_$DATAFILE_COPY','GV_$DATAFILE_HEADER','GV_$DATAGUARD_CONFIG','GV_$DATAGUARD_STATUS','GV_$DATAPUMP_JOB','GV_$DATAPUMP_SESSION','GV_$DB_CACHE_ADVICE','GV_$DB_OBJECT_CACHE','GV_$DB_PIPES','GV_$DB_TRANSPORTABLE_PLATFORM','GV_$DBFILE','GV_$DBLINK','GV_$DELETED_OBJECT','GV_$DISPATCHER','GV_$DISPATCHER_CONFIG','GV_$DISPATCHER_RATE','GV_$DLM_ALL_LOCKS','GV_$DLM_CONVERT_LOCAL','GV_$DLM_CONVERT_REMOTE','GV_$DLM_LATCH','GV_$DLM_LOCKS','GV_$DLM_MISC','GV_$DLM_RESS','GV_$DLM_TRAFFIC_CONTROLLER','GV_$ENABLEDPRIVS','GV_$ENQUEUE_LOCK','GV_$ENQUEUE_STAT','GV_$ENQUEUE_STATISTICS','GV_$EVENT_HISTOGRAM','GV_$EVENT_NAME','GV_$EVENTMETRIC','GV_$EXECUTION','GV_$FAST_START_SERVERS','GV_$FAST_START_TRANSACTIONS','GV_$FILE_CACHE_TRANSFER','GV_$FILE_HISTOGRAM','GV_$FILE_PING','GV_$FILEMETRIC','GV_$FILEMETRIC_HISTORY','GV_$FILESPACE_USAGE','GV_$FILESTAT','GV_$FIXED_TABLE','GV_$FIXED_VIEW_DEFINITION','GV_$FLASHBACK_DATABASE_LOG','GV_$FLASHBACK_DATABASE_LOGFILE','GV_$FLASHBACK_DATABASE_STAT','GV_$GC_ELEMENT','GV_$GC_ELEMENTS_W_COLLISIONS','GV_$GCSHVMASTER_INFO','GV_$GCSPFMASTER_INFO','GV_$GES_BLOCKING_ENQUEUE','GV_$GES_ENQUEUE','GV_$GLOBAL_BLOCKED_LOCKS','GV_$GLOBAL_TRANSACTION','GV_$GLOBALCONTEXT','GV_$HS_AGENT','GV_$HS_PARAMETER','GV_$HS_SESSION','GV_$HVMASTER_INFO','GV_$INDEXED_FIXED_COLUMN','GV_$INSTANCE','GV_$INSTANCE_CACHE_TRANSFER','GV_$INSTANCE_LOG_GROUP','GV_$INSTANCE_RECOVERY','GV_$JAVA_LIBRARY_CACHE_MEMORY','GV_$JAVA_POOL_ADVICE','GV_$JAVAPOOL','GV_$LATCH','GV_$LATCH_CHILDREN','GV_$LATCH_MISSES','GV_$LATCH_PARENT','GV_$LATCHHOLDER','GV_$LATCHNAME','GV_$LIBRARY_CACHE_MEMORY','GV_$LIBRARYCACHE','GV_$LICENSE','GV_$LOADISTAT','GV_$LOADPSTAT','GV_$LOCK','GV_$LOCK_ACTIVITY','GV_$LOCK_ELEMENT','GV_$LOCK_TYPE','GV_$LOCKED_OBJECT','GV_$LOCKS_WITH_COLLISIONS','GV_$LOG','GV_$LOG_HISTORY','GV_$LOGFILE','GV_$LOGHIST','GV_$LOGMNR_CALLBACK','GV_$LOGMNR_CONTENTS','GV_$LOGMNR_DICTIONARY','GV_$LOGMNR_DICTIONARY_LOAD','GV_$LOGMNR_LATCH','GV_$LOGMNR_LOGFILE','GV_$LOGMNR_LOGS','GV_$LOGMNR_PARAMETERS','GV_$LOGMNR_PROCESS','GV_$LOGMNR_REGION','GV_$LOGMNR_SESSION','GV_$LOGMNR_STATS','GV_$LOGMNR_TRANSACTION','GV_$LOGSTDBY','GV_$LOGSTDBY_PROCESS','GV_$LOGSTDBY_PROGRESS','GV_$LOGSTDBY_STATE','GV_$LOGSTDBY_STATS','GV_$LOGSTDBY_TRANSACTION','GV_$MANAGED_STANDBY','GV_$MAP_COMP_LIST','GV_$MAP_ELEMENT','GV_$MAP_EXT_ELEMENT','GV_$MAP_FILE','GV_$MAP_FILE_EXTENT','GV_$MAP_FILE_IO_STACK','GV_$MAP_LIBRARY','GV_$MAP_SUBELEMENT','GV_$MAX_ACTIVE_SESS_TARGET_MTH','GV_$METRIC','GV_$METRIC_HISTORY','GV_$METRICGROUP','GV_$METRICNAME','GV_$MTTR_TARGET_ADVICE','GV_$MUTEX_SLEEP','GV_$MUTEX_SLEEP_HISTORY','GV_$MVREFRESH','GV_$MYSTAT','GV_$NLS_PARAMETERS','GV_$NLS_VALID_VALUES','GV_$OBJECT_DEPENDENCY','GV_$OBSOLETE_PARAMETER','GV_$OFFLINE_RANGE','GV_$OPEN_CURSOR','GV_$OPTION','GV_$OSSTAT','GV_$PARALLEL_DEGREE_LIMIT_MTH','GV_$PARAMETER','GV_$PARAMETER_VALID_VALUES','GV_$PARAMETER2','GV_$PGA_TARGET_ADVICE','GV_$PGASTAT','GV_$PGATARGET_ADVICE_HISTOGRAM','GV_$PQ_SESSTAT','GV_$PQ_SLAVE','GV_$PQ_SYSSTAT','GV_$PQ_TQSTAT','GV_$PROCESS','GV_$PROCESS_MEMORY','GV_$PROCESS_MEMORY_DETAIL','GV_$PROCESS_MEMORY_DETAIL_PROG','GV_$PROPAGATION_RECEIVER','GV_$PROPAGATION_SENDER','GV_$PROXY_ARCHIVEDLOG','GV_$PROXY_DATAFILE','GV_$PWFILE_USERS','GV_$PX_BUFFER_ADVICE','GV_$PX_PROCESS','GV_$PX_PROCESS_SYSSTAT','GV_$PX_SESSION','GV_$PX_SESSTAT','GV_$QUEUE','GV_$QUEUEING_MTH','GV_$RECOVER_FILE','GV_$RECOVERY_FILE_STATUS','GV_$RECOVERY_LOG','GV_$RECOVERY_PROGRESS','GV_$RECOVERY_STATUS','GV_$REPLPROP','GV_$REPLQUEUE','GV_$REQDIST','GV_$RESERVED_WORDS','GV_$RESOURCE','GV_$RESOURCE_LIMIT','GV_$RESTORE_POINT','GV_$RESUMABLE','GV_$RFS_THREAD','GV_$RMAN_CONFIGURATION','GV_$RMAN_OUTPUT','GV_$ROLLSTAT','GV_$ROWCACHE','GV_$ROWCACHE_PARENT','GV_$ROWCACHE_SUBORDINATE','GV_$RSRC_CONS_GROUP_HISTORY','GV_$RSRC_CONSUME_GROUP_CPU_MTH','GV_$RSRC_CONSUMER_GROUP','GV_$RSRC_PLAN','GV_$RSRC_PLAN_CPU_MTH','GV_$RSRC_PLAN_HISTORY','GV_$RSRC_SESSION_INFO','GV_$RULE','GV_$RULE_SET','GV_$RULE_SET_AGGREGATE_STATS','GV_$SCHEDULER_RUNNING_JOBS','GV_$SEGMENT_STATISTICS','GV_$SEGSTAT','GV_$SEGSTAT_NAME','GV_$SERV_MOD_ACT_STATS','GV_$SERVICE_EVENT','GV_$SERVICE_STATS','GV_$SERVICE_WAIT_CLASS','GV_$SERVICEMETRIC','GV_$SERVICEMETRIC_HISTORY','GV_$SERVICES','GV_$SES_OPTIMIZER_ENV','GV_$SESS_IO','GV_$SESS_TIME_MODEL','GV_$SESSION','GV_$SESSION_CONNECT_INFO','GV_$SESSION_CURSOR_CACHE','GV_$SESSION_EVENT','GV_$SESSION_LONGOPS','GV_$SESSION_OBJECT_CACHE','GV_$SESSION_WAIT','GV_$SESSION_WAIT_CLASS','GV_$SESSION_WAIT_HISTORY','GV_$SESSMETRIC','GV_$SESSTAT','GV_$SGA','GV_$SGA_CURRENT_RESIZE_OPS','GV_$SGA_DYNAMIC_COMPONENTS','GV_$SGA_DYNAMIC_FREE_MEMORY','GV_$SGA_RESIZE_OPS','GV_$SGA_TARGET_ADVICE','GV_$SGAINFO','GV_$SGASTAT','GV_$SHARED_POOL_ADVICE','GV_$SHARED_POOL_RESERVED','GV_$SHARED_SERVER','GV_$SHARED_SERVER_MONITOR','GV_$SORT_SEGMENT','GV_$SORT_USAGE','GV_$SPPARAMETER','GV_$SQL','GV_$SQL_BIND_CAPTURE','GV_$SQL_BIND_DATA','GV_$SQL_BIND_METADATA','GV_$SQL_CURSOR','GV_$SQL_JOIN_FILTER','GV_$SQL_OPTIMIZER_ENV','GV_$SQL_PLAN','GV_$SQL_PLAN_STATISTICS','GV_$SQL_PLAN_STATISTICS_ALL','GV_$SQL_REDIRECTION','GV_$SQL_SHARED_CURSOR','GV_$SQL_SHARED_MEMORY','GV_$SQL_WORKAREA','GV_$SQL_WORKAREA_ACTIVE','GV_$SQL_WORKAREA_HISTOGRAM','GV_$SQLAREA','GV_$SQLAREA_PLAN_HASH','GV_$SQLSTATS','GV_$SQLTEXT','GV_$SQLTEXT_WITH_NEWLINES','GV_$STANDBY_APPLY_SNAPSHOT','GV_$STANDBY_LOG','GV_$STATISTICS_LEVEL','GV_$STATNAME','GV_$STREAMS_APPLY_COORDINATOR','GV_$STREAMS_APPLY_READER','GV_$STREAMS_APPLY_SERVER','GV_$STREAMS_CAPTURE','GV_$STREAMS_POOL_ADVICE','GV_$STREAMS_TRANSACTION','GV_$SUBCACHE','GV_$SYS_OPTIMIZER_ENV','GV_$SYS_TIME_MODEL','GV_$SYSAUX_OCCUPANTS','GV_$SYSMETRIC','GV_$SYSMETRIC_HISTORY','GV_$SYSMETRIC_SUMMARY','GV_$SYSSTAT','GV_$SYSTEM_CURSOR_CACHE','GV_$SYSTEM_EVENT','GV_$SYSTEM_PARAMETER','GV_$SYSTEM_PARAMETER2','GV_$SYSTEM_WAIT_CLASS','GV_$TABLESPACE','GV_$TEMP_CACHE_TRANSFER','GV_$TEMP_EXTENT_MAP','GV_$TEMP_EXTENT_POOL','GV_$TEMP_HISTOGRAM','GV_$TEMP_PING','GV_$TEMP_SPACE_HEADER','GV_$TEMPFILE','GV_$TEMPORARY_LOBS','GV_$TEMPSTAT','GV_$THREAD','GV_$THRESHOLD_TYPES','GV_$TIMER','GV_$TIMEZONE_FILE','GV_$TIMEZONE_NAMES','GV_$TRANSACTION','GV_$TRANSACTION_ENQUEUE','GV_$TRANSPORTABLE_PLATFORM','GV_$TSM_SESSIONS','GV_$TYPE_SIZE','GV_$UNDOSTAT','GV_$VERSION','GV_$VPD_POLICY','GV_$WAITCLASSMETRIC','GV_$WAITCLASSMETRIC_HISTORY','GV_$WAITSTAT','GV_$WALLET','GV_$XML_AUDIT_TRAIL','HS_ALL_CAPS','HS_ALL_DD','HS_ALL_INITS','HS_BASE_CAPS','HS_BASE_DD','HS_CLASS_CAPS','HS_CLASS_DD','HS_CLASS_INIT','HS_FDS_CLASS','HS_FDS_CLASS_DATE','HS_FDS_INST','HS_INST_CAPS','HS_INST_DD','HS_INST_INIT','IMP_LOB_INFO','IMP_LOB_NOTNULL','IMP_TAB_TRIG','IMP10TYPIDUSED','IMP10TYPUSED','IMP8CDT','IMP8CDTU','IMP8CON','IMP8REPCAT','IMP8TTD','IMP8TTDU','IMP8UEC','IMP9COMPAT','IMP9CON','IMP9SYN4','IMP9TVOID','IMP9USR','INDCOMPARTV$','INDEX_HISTOGRAM','INDEX_STATS','INDPARTV$','INDSUBPARTV$','KU$_10_1_COMMENT_VIEW','KU$_10_1_DBLINK_VIEW','KU$_10_1_FHTABLE_VIEW','KU$_10_1_HISTGRM_MAX_VIEW','KU$_10_1_HISTGRM_MIN_VIEW','KU$_10_1_HTABLE_VIEW','KU$_10_1_IND_STATS_VIEW','KU$_10_1_IOTABLE_VIEW','KU$_10_1_PFHTABLE_VIEW','KU$_10_1_PHTABLE_VIEW','KU$_10_1_PIND_STATS_VIEW','KU$_10_1_PIOTABLE_VIEW','KU$_10_1_PROXY_VIEW','KU$_10_1_PTAB_COL_STATS_VIEW','KU$_10_1_PTAB_STATS_VIEW','KU$_10_1_SPIND_STATS_VIEW','KU$_10_1_SYSGRANT_VIEW','KU$_10_1_TAB_COL_STATS_VIEW','KU$_10_1_TAB_ONLY_STATS_VIEW','KU$_10_1_TAB_STATS_VIEW','KU$_10_1_TABLE_DATA_VIEW','KU$_2NDTAB_INFO_VIEW','KU$_ADD_SNAP_VIEW','KU$_ALTER_FUNC_VIEW','KU$_ALTER_PKGBDY_VIEW','KU$_ALTER_PKGSPC_VIEW','KU$_ALTER_PROC_VIEW','KU$_ASSOC_VIEW','KU$_AUDIT_DEFAULT_VIEW','KU$_AUDIT_OBJ_BASE_VIEW','KU$_AUDIT_OBJ_VIEW','KU$_AUDIT_VIEW','KU$_BASE_PROC_VIEW','KU$_BYTES_ALLOC_VIEW','KU$_CLU_TS_VIEW','KU$_CLUSTER_VIEW','KU$_COL_STATS_VIEW','KU$_COLTYPE_VIEW','KU$_COLUMN_VIEW','KU$_COMMENT_VIEW','KU$_CONSTRAINT_COL_VIEW','KU$_CONSTRAINT_VIEW','KU$_CONSTRAINT0_VIEW','KU$_CONSTRAINT1_VIEW','KU$_CONSTRAINT2_VIEW','KU$_CONTEXT_VIEW','KU$_DBLINK_VIEW','KU$_DEFROLE_LIST_VIEW','KU$_DEFROLE_VIEW','KU$_DEPTYPES_BASE_VIEW','KU$_DEPTYPES_VIEW','KU$_DEPVIEWS_BASE_VIEW','KU$_DEPVIEWS_VIEW','KU$_DIMENSION_VIEW','KU$_DIRECTORY_VIEW','KU$_DOMIDX_2NDTAB_VIEW','KU$_DOMIDX_OBJNUM_VIEW','KU$_DOMIDX_PLSQL_VIEW','KU$_EXP_PKG_BODY_VIEW','KU$_EXP_TYPE_BODY_VIEW','KU$_EXPACT_VIEW','KU$_EXTTAB_VIEW','KU$_FGA_POLICY_VIEW','KU$_FHTABLE_VIEW','KU$_FILE_VIEW','KU$_FIND_HIDDEN_CONS_VIEW','KU$_FIND_SGC_COLS_VIEW','KU$_FIND_SGC_VIEW','KU$_FIND_SGI_COLS_VIEW','KU$_FULL_PKG_VIEW','KU$_FULL_TYPE_VIEW','KU$_FUNC_VIEW','KU$_HISTGRM_VIEW','KU$_HNT_VIEW','KU$_HTABLE_BYTES_ALLOC_VIEW','KU$_HTABLE_DATA_VIEW','KU$_HTABLE_OBJNUM_VIEW','KU$_HTABLE_VIEW','KU$_HTPART_BYTES_ALLOC_VIEW','KU$_HTPART_DATA_VIEW','KU$_HTSPART_BYTES_ALLOC_VIEW','KU$_HTSPART_DATA_VIEW','KU$_INC_TYPE_VIEW','KU$_IND_CACHE_STATS_VIEW','KU$_IND_COL_VIEW','KU$_IND_COMPART_VIEW','KU$_IND_PART_COL_VIEW','KU$_IND_PART_VIEW','KU$_IND_PARTOBJ_VIEW','KU$_IND_STATS_VIEW','KU$_IND_SUBPART_COL_VIEW','KU$_IND_SUBPART_VIEW','KU$_IND_TS_VIEW','KU$_INDARRAYTYPE_VIEW','KU$_INDEX_COL_VIEW','KU$_INDEX_VIEW','KU$_INDEXOP_VIEW','KU$_INDEXTYPE_VIEW','KU$_INSTANCE_CALLOUT_VIEW','KU$_IONT_VIEW','KU$_IOT_PARTOBJ_VIEW','KU$_IOTABLE_BYTES_ALLOC_VIEW','KU$_IOTABLE_DATA_VIEW','KU$_IOTABLE_VIEW','KU$_IOTPART_BYTES_ALLOC_VIEW','KU$_IOTPART_DATA_VIEW','KU$_JAVA_CLASS_VIEW','KU$_JAVA_OBJNUM_VIEW','KU$_JAVA_RESOURCE_VIEW','KU$_JAVA_SOURCE_VIEW','KU$_JIJOIN_TABLE_VIEW','KU$_JIJOIN_VIEW','KU$_JOB_VIEW','KU$_LIBRARY_VIEW','KU$_LOB_VIEW','KU$_LOBCOMPPART_VIEW','KU$_LOBFRAG_VIEW','KU$_LOBFRAGINDEX_VIEW','KU$_LOBINDEX_VIEW','KU$_M_VIEW_FH_VIEW','KU$_M_VIEW_H_VIEW','KU$_M_VIEW_IOT_VIEW','KU$_M_VIEW_LOG_FH_VIEW','KU$_M_VIEW_LOG_H_VIEW','KU$_M_VIEW_LOG_PFH_VIEW','KU$_M_VIEW_LOG_PH_VIEW','KU$_M_VIEW_LOG_VIEW','KU$_M_VIEW_PFH_VIEW','KU$_M_VIEW_PH_VIEW','KU$_M_VIEW_PIOT_VIEW','KU$_M_VIEW_VIEW','KU$_MONITOR_VIEW','KU$_MV_TS_VIEW','KU$_MVL_TS_VIEW','KU$_MVLPROP_VIEW','KU$_MVPROP_VIEW','KU$_NT_PARENT_VIEW','KU$_NTABLE_BYTES_ALLOC_VIEW','KU$_NTABLE_DATA_VIEW','KU$_NTABLE_OBJNUM_VIEW','KU$_OBJGRANT_VIEW','KU$_OBJPKG_VIEW','KU$_OIDINDEX_VIEW','KU$_OPANCILLARY_VIEW','KU$_OPBINDING_VIEW','KU$_OPERATOR_VIEW','KU$_OPQTYPE_VIEW','KU$_OUTLINE_VIEW','KU$_OV_TABLE_VIEW','KU$_OV_TABPART_VIEW','KU$_PARTITION_EST_VIEW','KU$_PARTLOB_VIEW','KU$_PARTOBJ_VIEW','KU$_PCOLUMN_VIEW','KU$_PFHTABLE_VIEW','KU$_PHTABLE_VIEW','KU$_PIND_STATS_VIEW','KU$_PIOT_PART_VIEW')");
sql.AppendLine(@"AND view_name NOT IN ('KU$_PIOTABLE_VIEW','KU$_PIOTLOBFRAG_VIEW','KU$_PKG_VIEW','KU$_PKGBDY_VIEW','KU$_PKREF_CONSTRAINT_VIEW','KU$_PLUGTS_BEGIN_VIEW','KU$_PLUGTS_BLK_VIEW','KU$_PLUGTS_CHECKPL_VIEW','KU$_PLUGTS_TSNAME_VIEW','KU$_POST_TABLE_VIEW','KU$_PRE_TABLE_VIEW','KU$_PRIM_COLUMN_VIEW','KU$_PROC_AUDIT_VIEW','KU$_PROC_GRANT_VIEW','KU$_PROC_VIEW','KU$_PROCACT_INSTANCE_VIEW','KU$_PROCACT_SCHEMA_VIEW','KU$_PROCACT_SYS_VIEW','KU$_PROCDEPOBJ_AUDIT_VIEW','KU$_PROCDEPOBJ_GRANT_VIEW','KU$_PROCDEPOBJ_VIEW','KU$_PROCOBJ_AUDIT_VIEW','KU$_PROCOBJ_GRANT_VIEW','KU$_PROCOBJ_OBJNUM_VIEW','KU$_PROCOBJ_VIEW','KU$_PROFILE_ATTR_VIEW','KU$_PROFILE_VIEW','KU$_PROXY_ROLE_LIST_VIEW','KU$_PROXY_VIEW','KU$_PSW_HIST_LIST_VIEW','KU$_PSW_HIST_VIEW','KU$_PTAB_STATS_VIEW','KU$_PWDVFC_VIEW','KU$_QTAB_STORAGE_VIEW','KU$_QTRANS_VIEW','KU$_QUEUE_TABLE_VIEW','KU$_QUEUES_VIEW','KU$_REF_CONSTRAINT_VIEW','KU$_REFGROUP_VIEW','KU$_RESOCOST_LIST_VIEW','KU$_RESOCOST_VIEW','KU$_RLS_CONTEXT_VIEW','KU$_RLS_GROUP_VIEW','KU$_RLS_POLICY_VIEW','KU$_RMGR_CONSUMER_VIEW','KU$_RMGR_INIT_CONSUMER_VIEW','KU$_RMGR_PLAN_DIRECT_VIEW','KU$_RMGR_PLAN_VIEW','KU$_ROGRANT_VIEW','KU$_ROLE_VIEW','KU$_ROLLBACK_VIEW','KU$_SCHEMA_CALLOUT_VIEW','KU$_SCHEMAOBJ_VIEW','KU$_SEQUENCE_VIEW','KU$_SIMPLE_COL_VIEW','KU$_SIMPLE_PKREF_COL_VIEW','KU$_SIMPLE_SETID_COL_VIEW','KU$_SPIND_STATS_VIEW','KU$_STORAGE_VIEW','KU$_STRMCOL_VIEW','KU$_STRMCOLTYPE_VIEW','KU$_STRMSUBCOLTYPE_VIEW','KU$_STRMTABLE_VIEW','KU$_SUBCOLTYPE_VIEW','KU$_SUBLOBFRAG_VIEW','KU$_SUBLOBFRAGINDEX_VIEW','KU$_SUBPARTITION_EST_VIEW','KU$_SWITCH_COMPILER_VIEW','KU$_SYNONYM_VIEW','KU$_SYSCALLOUT_VIEW','KU$_SYSGRANT_VIEW','KU$_TAB_CACHE_STATS_VIEW','KU$_TAB_COL_VIEW','KU$_TAB_COMPART_VIEW','KU$_TAB_ONLY_STATS_VIEW','KU$_TAB_PART_COL_VIEW','KU$_TAB_PART_VIEW','KU$_TAB_PARTOBJ_VIEW','KU$_TAB_STATS_VIEW','KU$_TAB_SUBPART_COL_VIEW','KU$_TAB_SUBPART_VIEW','KU$_TAB_TS_VIEW','KU$_TAB_TSUBPART_VIEW','KU$_TABCLUSTER_COL_VIEW','KU$_TABCLUSTER_VIEW','KU$_TABLE_DATA_VIEW','KU$_TABLE_EST_VIEW','KU$_TABLE_OBJNUM_VIEW','KU$_TABLE_TYPES_VIEW','KU$_TABLESPACE_VIEW','KU$_TABPROP_VIEW','KU$_TEMP_SUBPART_VIEW','KU$_TEMP_SUBPARTDATA_VIEW','KU$_TEMP_SUBPARTLOB_VIEW','KU$_TEMP_SUBPARTLOBFRG_VIEW','KU$_TLOB_COMPPART_VIEW','KU$_TRIGGER_VIEW','KU$_TRIGGERCOL_VIEW','KU$_TRLINK_VIEW','KU$_TSQUOTA_VIEW','KU$_TTS_IND_VIEW','KU$_TTS_MV_VIEW','KU$_TTS_MVL_VIEW','KU$_TTS_VIEW','KU$_TYPE_BODY_VIEW','KU$_TYPE_VIEW','KU$_UNLOAD_METHOD_VIEW','KU$_USER_VIEW','KU$_VIEW_OBJNUM_VIEW','KU$_VIEW_STATUS_VIEW','KU$_VIEW_VIEW','KU$_XMLSCHEMA_ELMT_VIEW','KU$_XMLSCHEMA_VIEW','KU_NOEXP_VIEW','LOADER_COL_FLAGS','LOADER_COL_INFO','LOADER_COL_TYPE','LOADER_CONSTRAINT_INFO','LOADER_DIR_OBJS','LOADER_FILE_TS','LOADER_FULL_ATTR_NAME','LOADER_INTCOL_INFO','LOADER_LOB_FLAGS','LOADER_NESTED_VARRAYS','LOADER_OID_INFO','LOADER_PARAM_INFO','LOADER_PART_INFO','LOADER_REF_INFO','LOADER_SKIP_UNUSABLE_INDEXES','LOADER_TAB_INFO','LOADER_TRIGGER_INFO','LOBCOMPPARTV$','LOBFRAGV$','LOGSTDBY_LOG','LOGSTDBY_SUPPORT','LOGSTDBY_UNSUPPORTED_TABLES','MGMT_RESPONSE_BASELINE','MVIEW_EVALUATIONS','MVIEW_EXCEPTIONS','MVIEW_FILTER','MVIEW_FILTERINSTANCE','MVIEW_LOG','MVIEW_RECOMMENDATIONS','MVIEW_WORKLOAD','MY_SDO_INDEX_METADATA','NLS_DATABASE_PARAMETERS','NLS_INSTANCE_PARAMETERS','NLS_SESSION_PARAMETERS','ORA_KGLR7_DB_LINKS','ORA_KGLR7_DEPENDENCIES','ORA_KGLR7_IDL_CHAR','ORA_KGLR7_IDL_SB4','ORA_KGLR7_IDL_UB1','ORA_KGLR7_IDL_UB2','ORA_KGLR7_OBJECTS','PARSED_PIECES','PARSED_SIZE','PATH_VIEW','PLUGGABLE_SET_CHECK','PRODUCT_COMPONENT_VERSION','PRODUCT_PRIVS','PROXY_ROLES','PROXY_USERS','PROXY_USERS_AND_ROLES','PS1$','PSS1$','PUBLIC_DEPENDENCY','PUBLICSYN','QT4777_BUFFER','QT5047_BUFFER','QT5135_BUFFER','QT7110_BUFFER','QT8623_BUFFER','QT8735_BUFFER','QT9863_BUFFER','QUEUE_PRIVILEGES','REPCAT$_CDEF','REPCAT_GENERATED','REPCAT_REPCAT','REPCAT_REPCATLOG','REPCAT_REPCOLUMN_BASE','REPCAT_REPFLAVOR_COLUMNS','REPCAT_REPOBJECT','REPCAT_REPOBJECT_BASE','REPCAT_REPPROP','REPCAT_REPSCHEMA','RESOURCE_COST','RESOURCE_VIEW','ROLE_ROLE_PRIVS','ROLE_SYS_PRIVS','ROLE_TAB_PRIVS','SCHEMA_EXPORT_OBJECTS','SDO_ANGLE_UNITS','SDO_AREA_UNITS','SDO_AVAILABLE_ELEM_OPS','SDO_AVAILABLE_NON_ELEM_OPS','SDO_AVAILABLE_OPS','SDO_COORD_REF_SYSTEM','SDO_CRS_COMPOUND','SDO_CRS_ENGINEERING','SDO_CRS_GEOCENTRIC','SDO_CRS_GEOGRAPHIC2D','SDO_CRS_GEOGRAPHIC3D','SDO_CRS_PROJECTED','SDO_CRS_VERTICAL','SDO_DATUM_ENGINEERING','SDO_DATUM_GEODETIC','SDO_DATUM_VERTICAL','SDO_DATUMS_OLD_FORMAT','SDO_DIST_UNITS','SDO_ELLIPSOIDS_OLD_FORMAT','SDO_PROJECTIONS_OLD_FORMAT','SDO_RELATEMASK_TABLE','SDO_TOPO_TRANSACT_DATA$','SESSION_CONTEXT','SESSION_PRIVS','SESSION_ROLES','SM$AUDIT_CONFIG','SM$INTEGRITY_CONS','SM$TS_AVAIL','SM$TS_FREE','SM$TS_USED','SM_$VERSION','SNS$EJB$GEN$','SOURCE_SIZE','STRADDLING_RS_OBJECTS','STRADDLING_TS_OBJECTS','SYNONYMS','SYS_DBA_SEGS','SYS_OBJECTS','SYS_USER_SEGS','SYSCATALOG','SYSCATALOG_','SYSFILES','SYSSEGOBJ','TAB','TABCOMPARTV$','TABLE_EXPORT_OBJECTS','TABLE_PRIVILEGES','TABLESPACE_EXPORT_OBJECTS','TABPARTV$','TABQUOTAS','TABSUBPARTV$','TBS_SPACE_USAGE','TP$','TRANSPORTABLE_EXPORT_OBJECTS','TRUSTED_SERVERS','TS_PITR_CHECK','TS_PITR_INFO','TS_PITR_OBJECTS_TO_BE_DROPPED','TS_PLUG_INFO','TSP$','TTS_OBJ_VIEW','TTS_TAB_VIEW','UNI_PLUGGABLE_SET_CHECK','USER_ADVISOR_ACTIONS','USER_ADVISOR_DIRECTIVES','USER_ADVISOR_FINDINGS','USER_ADVISOR_JOURNAL','USER_ADVISOR_LOG','USER_ADVISOR_OBJECTS','USER_ADVISOR_PARAMETERS','USER_ADVISOR_RATIONALE','USER_ADVISOR_RECOMMENDATIONS','USER_ADVISOR_SQLA_REC_SUM','USER_ADVISOR_SQLA_WK_MAP','USER_ADVISOR_SQLA_WK_STMTS','USER_ADVISOR_SQLW_COLVOL','USER_ADVISOR_SQLW_JOURNAL','USER_ADVISOR_SQLW_PARAMETERS','USER_ADVISOR_SQLW_STMTS','USER_ADVISOR_SQLW_SUM','USER_ADVISOR_SQLW_TABLES','USER_ADVISOR_SQLW_TABVOL','USER_ADVISOR_SQLW_TEMPLATES','USER_ADVISOR_TASKS','USER_ADVISOR_TEMPLATES','USER_ALL_TABLES','USER_APPLICATION_ROLES','USER_AQ_AGENT_PRIVS','USER_ARGUMENTS','USER_ASSOCIATIONS','USER_ATTRIBUTE_TRANSFORMATIONS','USER_AUDIT_OBJECT','USER_AUDIT_POLICIES','USER_AUDIT_POLICY_COLUMNS','USER_AUDIT_SESSION','USER_AUDIT_STATEMENT','USER_AUDIT_TRAIL','USER_AW_PS','USER_AWS','USER_BASE_TABLE_MVIEWS','USER_CATALOG','USER_CHANGE_NOTIFICATION_REGS','USER_CLU_COLUMNS','USER_CLUSTER_HASH_EXPRESSIONS','USER_CLUSTERS','USER_COL_COMMENTS','USER_COL_PRIVS','USER_COL_PRIVS_MADE','USER_COL_PRIVS_RECD','USER_COLL_TYPES','USER_CONS_COLUMNS','USER_CONS_OBJ_COLUMNS','USER_CONSTRAINTS','USER_DATAPUMP_JOBS','USER_DB_LINKS','USER_DEPENDENCIES','USER_DIM_ATTRIBUTES','USER_DIM_CHILD_OF','USER_DIM_HIERARCHIES','USER_DIM_JOIN_KEY','USER_DIM_LEVEL_KEY','USER_DIM_LEVELS','USER_DIMENSIONS','USER_ENCRYPTED_COLUMNS','USER_EPG_DAD_AUTHORIZATION','USER_ERRORS','USER_EVALUATION_CONTEXT_TABLES','USER_EVALUATION_CONTEXT_VARS','USER_EVALUATION_CONTEXTS','USER_EXTENTS','USER_EXTERNAL_LOCATIONS','USER_EXTERNAL_TABLES','USER_FILE_GROUP_EXPORT_INFO','USER_FILE_GROUP_FILES','USER_FILE_GROUP_TABLES','USER_FILE_GROUP_TABLESPACES','USER_FILE_GROUP_VERSIONS','USER_FILE_GROUPS','USER_FREE_SPACE','USER_GEOMETRY_COLUMNS','USER_IND_COLUMNS','USER_IND_EXPRESSIONS','USER_IND_PARTITIONS','USER_IND_STATISTICS','USER_IND_SUBPARTITIONS','USER_INDEXES','USER_INDEXTYPE_ARRAYTYPES','USER_INDEXTYPE_COMMENTS','USER_INDEXTYPE_OPERATORS','USER_INDEXTYPES','USER_INTERNAL_TRIGGERS','USER_JOBS','USER_JOIN_IND_COLUMNS','USER_LIBRARIES','USER_LOB_PARTITIONS','USER_LOB_SUBPARTITIONS','USER_LOB_TEMPLATES','USER_LOBS','USER_LOG_GROUP_COLUMNS','USER_LOG_GROUPS','USER_METHOD_PARAMS','USER_METHOD_RESULTS','USER_MVIEW_AGGREGATES','USER_MVIEW_ANALYSIS','USER_MVIEW_COMMENTS','USER_MVIEW_DETAIL_RELATIONS','USER_MVIEW_JOINS','USER_MVIEW_KEYS','USER_MVIEW_LOGS','USER_MVIEW_REFRESH_TIMES','USER_MVIEWS','USER_NESTED_TABLE_COLS','USER_NESTED_TABLES','USER_OBJ_AUDIT_OPTS','USER_OBJ_COLATTRS','USER_OBJECT_SIZE','USER_OBJECT_TABLES','USER_OBJECTS','USER_OPANCILLARY','USER_OPARGUMENTS','USER_OPBINDINGS','USER_OPERATOR_COMMENTS','USER_OPERATORS','USER_OUTLINE_HINTS','USER_OUTLINES','USER_PART_COL_STATISTICS','USER_PART_HISTOGRAMS','USER_PART_INDEXES','USER_PART_KEY_COLUMNS','USER_PART_LOBS','USER_PART_TABLES','USER_PARTIAL_DROP_TABS','USER_PASSWORD_LIMITS','USER_PENDING_CONV_TABLES','USER_PLSQL_OBJECT_SETTINGS','USER_POLICIES','USER_POLICY_CONTEXTS','USER_POLICY_GROUPS','USER_PROCEDURES','USER_PROXIES','USER_PUBLISHED_COLUMNS','USER_QUEUE_PUBLISHERS','USER_QUEUE_SCHEDULES','USER_QUEUE_SUBSCRIBERS','USER_QUEUE_TABLES','USER_QUEUES','USER_RECYCLEBIN','USER_REFRESH','USER_REFRESH_CHILDREN','USER_REFS','USER_REGISTERED_MVIEWS','USER_REGISTERED_SNAPSHOTS','USER_REGISTRY','USER_REPAUDIT_ATTRIBUTE','USER_REPAUDIT_COLUMN','USER_REPCAT','USER_REPCAT_REFRESH_TEMPLATES','USER_REPCAT_TEMPLATE_OBJECTS','USER_REPCAT_TEMPLATE_PARMS','USER_REPCAT_TEMPLATE_SITES','USER_REPCAT_USER_AUTHORIZATION','USER_REPCAT_USER_PARM_VALUES','USER_REPCATLOG','USER_REPCOLUMN','USER_REPCOLUMN_GROUP','USER_REPCONFLICT','USER_REPDDL','USER_REPFLAVOR_COLUMNS','USER_REPFLAVOR_OBJECTS','USER_REPFLAVORS','USER_REPGENERATED','USER_REPGENOBJECTS','USER_REPGROUP','USER_REPGROUP_PRIVILEGES','USER_REPGROUPED_COLUMN','USER_REPKEY_COLUMNS','USER_REPOBJECT','USER_REPPARAMETER_COLUMN','USER_REPPRIORITY','USER_REPPRIORITY_GROUP','USER_REPPROP','USER_REPRESOL_STATS_CONTROL','USER_REPRESOLUTION','USER_REPRESOLUTION_METHOD','USER_REPRESOLUTION_STATISTICS','USER_REPSCHEMA','USER_REPSITES','USER_RESOURCE_LIMITS','USER_RESUMABLE','USER_REWRITE_EQUIVALENCES','USER_ROLE_PRIVS','USER_RSRC_CONSUMER_GROUP_PRIVS','USER_RSRC_MANAGER_SYSTEM_PRIVS','USER_RULE_SET_RULES','USER_RULE_SETS','USER_RULES','USER_RULESETS','USER_SCHEDULER_CHAIN_RULES','USER_SCHEDULER_CHAIN_STEPS','USER_SCHEDULER_CHAINS','USER_SCHEDULER_JOB_ARGS','USER_SCHEDULER_JOB_LOG','USER_SCHEDULER_JOB_RUN_DETAILS','USER_SCHEDULER_JOBS','USER_SCHEDULER_PROGRAM_ARGS','USER_SCHEDULER_PROGRAMS','USER_SCHEDULER_RUNNING_CHAINS','USER_SCHEDULER_RUNNING_JOBS','USER_SCHEDULER_SCHEDULES','USER_SDO_GEOM_METADATA','USER_SDO_INDEX_INFO','USER_SDO_INDEX_METADATA','USER_SDO_LRS_METADATA','USER_SDO_MAPS','USER_SDO_STYLES','USER_SDO_THEMES','USER_SDO_TOPO_INFO','USER_SDO_TOPO_METADATA','USER_SEC_RELEVANT_COLS','USER_SECONDARY_OBJECTS','USER_SEGMENTS','USER_SEQUENCES','USER_SNAPSHOT_LOGS','USER_SNAPSHOTS','USER_SOURCE','USER_SOURCE_TABLES','USER_SQLJ_TYPE_ATTRS','USER_SQLJ_TYPE_METHODS','USER_SQLJ_TYPES','USER_SQLSET','USER_SQLSET_BINDS','USER_SQLSET_PLANS','USER_SQLSET_REFERENCES','USER_SQLSET_STATEMENTS','USER_SQLTUNE_BINDS','USER_SQLTUNE_PLANS','USER_SQLTUNE_RATIONALE_PLAN','USER_SQLTUNE_STATISTICS','USER_STORED_SETTINGS','USER_SUBPART_COL_STATISTICS','USER_SUBPART_HISTOGRAMS','USER_SUBPART_KEY_COLUMNS','USER_SUBPARTITION_TEMPLATES','USER_SUBSCRIBED_COLUMNS','USER_SUBSCRIBED_TABLES','USER_SUBSCRIPTIONS','USER_SUMMARIES','USER_SUMMARY_AGGREGATES','USER_SUMMARY_DETAIL_TABLES','USER_SUMMARY_JOINS','USER_SUMMARY_KEYS','USER_SYNONYMS','USER_SYS_PRIVS','USER_TAB_COL_STATISTICS','USER_TAB_COLS','USER_TAB_COLUMNS','USER_TAB_COMMENTS','USER_TAB_HISTOGRAMS','USER_TAB_MODIFICATIONS','USER_TAB_PARTITIONS','USER_TAB_PRIVS','USER_TAB_PRIVS_MADE','USER_TAB_PRIVS_RECD','USER_TAB_STATISTICS','USER_TAB_STATS_HISTORY','USER_TAB_SUBPARTITIONS','USER_TABLES','USER_TABLESPACES','USER_TRANSFORMATIONS','USER_TRIGGER_COLS','USER_TRIGGERS','USER_TS','USER_TS_QUOTAS','USER_TUNE_MVIEW','USER_TYPE_ATTRS','USER_TYPE_METHODS','USER_TYPE_VERSIONS','USER_TYPES','USER_UNUSED_COL_TABS','USER_UPDATABLE_COLUMNS','USER_USERS','USER_USTATS','USER_VARRAYS','USER_VIEWS','USER_WARNING_SETTINGS','USER_XML_COLUMN_NAMES','USER_XML_INDEXES','USER_XML_SCHEMAS','USER_XML_TAB_COLS','USER_XML_TABLES','USER_XML_VIEW_COLS','USER_XML_VIEWS','UTL_ALL_IND_COMPS','UTL_RECOMP_ALL_OBJECTS','UTL_RECOMP_INVALID_ALL','UTL_RECOMP_INVALID_JAVA_SYN','UTL_RECOMP_INVALID_PARALLEL','UTL_RECOMP_INVALID_SEQ','V$OBJECT_USAGE','V_$_LOCK','V_$ACCESS','V_$ACTIVE_INSTANCES','V_$ACTIVE_SERVICES','V_$ACTIVE_SESS_POOL_MTH','V_$ACTIVE_SESSION_HISTORY','V_$ADVISOR_PROGRESS','V_$ALERT_TYPES','V_$AQ','V_$AQ1','V_$ARCHIVE','V_$ARCHIVE_DEST','V_$ARCHIVE_DEST_STATUS','V_$ARCHIVE_GAP','V_$ARCHIVE_PROCESSES','V_$ARCHIVED_LOG','V_$ASM_ALIAS','V_$ASM_CLIENT','V_$ASM_DISK','V_$ASM_DISK_STAT','V_$ASM_DISKGROUP','V_$ASM_DISKGROUP_STAT','V_$ASM_FILE','V_$ASM_OPERATION','V_$ASM_TEMPLATE','V_$AW_AGGREGATE_OP','V_$AW_ALLOCATE_OP','V_$AW_CALC','V_$AW_LONGOPS','V_$AW_OLAP','V_$AW_SESSION_INFO','V_$BACKUP','V_$BACKUP_ARCHIVELOG_DETAILS','V_$BACKUP_ARCHIVELOG_SUMMARY','V_$BACKUP_ASYNC_IO','V_$BACKUP_CONTROLFILE_DETAILS','V_$BACKUP_CONTROLFILE_SUMMARY','V_$BACKUP_COPY_DETAILS','V_$BACKUP_COPY_SUMMARY','V_$BACKUP_CORRUPTION','V_$BACKUP_DATAFILE','V_$BACKUP_DATAFILE_DETAILS','V_$BACKUP_DATAFILE_SUMMARY','V_$BACKUP_DEVICE','V_$BACKUP_FILES','V_$BACKUP_PIECE','V_$BACKUP_PIECE_DETAILS','V_$BACKUP_REDOLOG','V_$BACKUP_SET','V_$BACKUP_SET_DETAILS','V_$BACKUP_SET_SUMMARY','V_$BACKUP_SPFILE','V_$BACKUP_SPFILE_DETAILS','V_$BACKUP_SPFILE_SUMMARY','V_$BACKUP_SYNC_IO','V_$BGPROCESS','V_$BH','V_$BLOCK_CHANGE_TRACKING','V_$BLOCKING_QUIESCE','V_$BSP','V_$BUFFER_POOL','V_$BUFFER_POOL_STATISTICS','V_$BUFFERED_PUBLISHERS','V_$BUFFERED_QUEUES','V_$BUFFERED_SUBSCRIBERS','V_$CIRCUIT','V_$CLASS_CACHE_TRANSFER','V_$CLASS_PING','V_$CLIENT_STATS','V_$CLUSTER_INTERCONNECTS','V_$CONFIGURED_INTERCONNECTS','V_$CONTEXT','V_$CONTROLFILE','V_$CONTROLFILE_RECORD_SECTION','V_$COPY_CORRUPTION','V_$CR_BLOCK_SERVER','V_$CURRENT_BLOCK_SERVER','V_$DATABASE','V_$DATABASE_BLOCK_CORRUPTION','V_$DATABASE_INCARNATION','V_$DATAFILE','V_$DATAFILE_COPY','V_$DATAFILE_HEADER','V_$DATAGUARD_CONFIG','V_$DATAGUARD_STATS','V_$DATAGUARD_STATUS','V_$DATAPUMP_JOB','V_$DATAPUMP_SESSION','V_$DB_CACHE_ADVICE','V_$DB_OBJECT_CACHE','V_$DB_PIPES','V_$DB_TRANSPORTABLE_PLATFORM','V_$DBFILE','V_$DBLINK','V_$DELETED_OBJECT','V_$DISPATCHER','V_$DISPATCHER_CONFIG','V_$DISPATCHER_RATE','V_$DLM_ALL_LOCKS','V_$DLM_CONVERT_LOCAL','V_$DLM_CONVERT_REMOTE','V_$DLM_LATCH','V_$DLM_LOCKS','V_$DLM_MISC','V_$DLM_RESS','V_$DLM_TRAFFIC_CONTROLLER','V_$ENABLEDPRIVS','V_$ENQUEUE_LOCK','V_$ENQUEUE_STAT','V_$ENQUEUE_STATISTICS','V_$EVENT_HISTOGRAM','V_$EVENT_NAME','V_$EVENTMETRIC','V_$EXECUTION','V_$FAST_START_SERVERS','V_$FAST_START_TRANSACTIONS','V_$FILE_CACHE_TRANSFER','V_$FILE_HISTOGRAM','V_$FILE_PING','V_$FILEMETRIC','V_$FILEMETRIC_HISTORY','V_$FILESPACE_USAGE','V_$FILESTAT','V_$FIXED_TABLE','V_$FIXED_VIEW_DEFINITION','V_$FLASH_RECOVERY_AREA_USAGE','V_$FLASHBACK_DATABASE_LOG','V_$FLASHBACK_DATABASE_LOGFILE','V_$FLASHBACK_DATABASE_STAT','V_$GC_ELEMENT','V_$GC_ELEMENTS_W_COLLISIONS','V_$GCSHVMASTER_INFO','V_$GCSPFMASTER_INFO','V_$GES_BLOCKING_ENQUEUE','V_$GES_ENQUEUE','V_$GLOBAL_BLOCKED_LOCKS','V_$GLOBAL_TRANSACTION','V_$GLOBALCONTEXT','V_$HS_AGENT','V_$HS_PARAMETER','V_$HS_SESSION','V_$HVMASTER_INFO','V_$INDEXED_FIXED_COLUMN','V_$INSTANCE','V_$INSTANCE_CACHE_TRANSFER','V_$INSTANCE_LOG_GROUP','V_$INSTANCE_RECOVERY','V_$JAVA_LIBRARY_CACHE_MEMORY','V_$JAVA_POOL_ADVICE','V_$JAVAPOOL','V_$KCCDI','V_$KCCFE','V_$LATCH','V_$LATCH_CHILDREN','V_$LATCH_MISSES','V_$LATCH_PARENT','V_$LATCHHOLDER','V_$LATCHNAME','V_$LIBRARY_CACHE_MEMORY','V_$LIBRARYCACHE','V_$LICENSE','V_$LOADISTAT','V_$LOADPSTAT','V_$LOCK','V_$LOCK_ACTIVITY','V_$LOCK_ELEMENT','V_$LOCK_TYPE','V_$LOCKED_OBJECT','V_$LOCKS_WITH_COLLISIONS','V_$LOG','V_$LOG_HISTORY','V_$LOGFILE','V_$LOGHIST','V_$LOGMNR_CALLBACK','V_$LOGMNR_CONTENTS','V_$LOGMNR_DICTIONARY','V_$LOGMNR_DICTIONARY_LOAD','V_$LOGMNR_LATCH','V_$LOGMNR_LOGFILE','V_$LOGMNR_LOGS','V_$LOGMNR_PARAMETERS','V_$LOGMNR_PROCESS','V_$LOGMNR_REGION','V_$LOGMNR_SESSION','V_$LOGMNR_STATS','V_$LOGMNR_TRANSACTION','V_$LOGSTDBY','V_$LOGSTDBY_PROCESS','V_$LOGSTDBY_PROGRESS','V_$LOGSTDBY_STATE','V_$LOGSTDBY_STATS','V_$LOGSTDBY_TRANSACTION','V_$MANAGED_STANDBY','V_$MAP_COMP_LIST','V_$MAP_ELEMENT','V_$MAP_EXT_ELEMENT','V_$MAP_FILE','V_$MAP_FILE_EXTENT','V_$MAP_FILE_IO_STACK','V_$MAP_LIBRARY','V_$MAP_SUBELEMENT','V_$MAX_ACTIVE_SESS_TARGET_MTH','V_$METRIC','V_$METRIC_HISTORY','V_$METRICGROUP','V_$METRICNAME','V_$MTTR_TARGET_ADVICE','V_$MUTEX_SLEEP','V_$MUTEX_SLEEP_HISTORY','V_$MVREFRESH','V_$MYSTAT','V_$NLS_PARAMETERS','V_$NLS_VALID_VALUES','V_$OBJECT_DEPENDENCY','V_$OBSOLETE_PARAMETER','V_$OFFLINE_RANGE','V_$OPEN_CURSOR','V_$OPTION','V_$OSSTAT','V_$PARALLEL_DEGREE_LIMIT_MTH','V_$PARAMETER','V_$PARAMETER_VALID_VALUES','V_$PARAMETER2','V_$PGA_TARGET_ADVICE','V_$PGA_TARGET_ADVICE_HISTOGRAM','V_$PGASTAT','V_$PQ_SESSTAT','V_$PQ_SLAVE','V_$PQ_SYSSTAT','V_$PQ_TQSTAT','V_$PROCESS','V_$PROCESS_MEMORY','V_$PROCESS_MEMORY_DETAIL','V_$PROCESS_MEMORY_DETAIL_PROG','V_$PROPAGATION_RECEIVER','V_$PROPAGATION_SENDER','V_$PROXY_ARCHIVEDLOG','V_$PROXY_ARCHIVELOG_DETAILS','V_$PROXY_ARCHIVELOG_SUMMARY','V_$PROXY_COPY_DETAILS','V_$PROXY_COPY_SUMMARY','V_$PROXY_DATAFILE','V_$PWFILE_USERS','V_$PX_BUFFER_ADVICE','V_$PX_PROCESS','V_$PX_PROCESS_SYSSTAT','V_$PX_SESSION','V_$PX_SESSTAT','V_$QUEUE','V_$QUEUEING_MTH','V_$RECOVER_FILE','V_$RECOVERY_FILE_DEST','V_$RECOVERY_FILE_STATUS','V_$RECOVERY_LOG','V_$RECOVERY_PROGRESS','V_$RECOVERY_STATUS','V_$REPLPROP','V_$REPLQUEUE','V_$REQDIST','V_$RESERVED_WORDS','V_$RESOURCE','V_$RESOURCE_LIMIT','V_$RESTORE_POINT','V_$RESUMABLE','V_$RFS_THREAD','V_$RMAN_BACKUP_JOB_DETAILS','V_$RMAN_BACKUP_SUBJOB_DETAILS','V_$RMAN_BACKUP_TYPE','V_$RMAN_CONFIGURATION','V_$RMAN_OUTPUT','V_$RMAN_STATUS','V_$ROLLNAME','V_$ROLLSTAT','V_$ROWCACHE','V_$ROWCACHE_PARENT','V_$ROWCACHE_SUBORDINATE','V_$RSRC_CONS_GROUP_HISTORY','V_$RSRC_CONSUMER_GROUP','V_$RSRC_CONSUMER_GROUP_CPU_MTH','V_$RSRC_PLAN','V_$RSRC_PLAN_CPU_MTH','V_$RSRC_PLAN_HISTORY','V_$RSRC_SESSION_INFO','V_$RULE','V_$RULE_SET','V_$RULE_SET_AGGREGATE_STATS','V_$SCHEDULER_RUNNING_JOBS','V_$SEGMENT_STATISTICS','V_$SEGSTAT','V_$SEGSTAT_NAME','V_$SERV_MOD_ACT_STATS','V_$SERVICE_EVENT','V_$SERVICE_STATS','V_$SERVICE_WAIT_CLASS','V_$SERVICEMETRIC','V_$SERVICEMETRIC_HISTORY','V_$SERVICES','V_$SES_OPTIMIZER_ENV','V_$SESS_IO','V_$SESS_TIME_MODEL','V_$SESSION','V_$SESSION_CONNECT_INFO','V_$SESSION_CURSOR_CACHE','V_$SESSION_EVENT','V_$SESSION_LONGOPS','V_$SESSION_OBJECT_CACHE','V_$SESSION_WAIT','V_$SESSION_WAIT_CLASS','V_$SESSION_WAIT_HISTORY','V_$SESSMETRIC','V_$SESSTAT','V_$SGA','V_$SGA_CURRENT_RESIZE_OPS','V_$SGA_DYNAMIC_COMPONENTS','V_$SGA_DYNAMIC_FREE_MEMORY','V_$SGA_RESIZE_OPS','V_$SGA_TARGET_ADVICE','V_$SGAINFO','V_$SGASTAT','V_$SHARED_POOL_ADVICE','V_$SHARED_POOL_RESERVED','V_$SHARED_SERVER','V_$SHARED_SERVER_MONITOR','V_$SORT_SEGMENT','V_$SORT_USAGE','V_$SPPARAMETER','V_$SQL','V_$SQL_BIND_CAPTURE','V_$SQL_BIND_DATA','V_$SQL_BIND_METADATA','V_$SQL_CURSOR','V_$SQL_JOIN_FILTER','V_$SQL_OPTIMIZER_ENV','V_$SQL_PLAN','V_$SQL_PLAN_STATISTICS','V_$SQL_PLAN_STATISTICS_ALL','V_$SQL_REDIRECTION','V_$SQL_SHARED_CURSOR','V_$SQL_SHARED_MEMORY','V_$SQL_WORKAREA','V_$SQL_WORKAREA_ACTIVE','V_$SQL_WORKAREA_HISTOGRAM','V_$SQLAREA','V_$SQLAREA_PLAN_HASH','V_$SQLSTATS','V_$SQLTEXT','V_$SQLTEXT_WITH_NEWLINES','V_$STANDBY_APPLY_SNAPSHOT','V_$STANDBY_LOG','V_$STATISTICS_LEVEL','V_$STATNAME','V_$STREAMS_APPLY_COORDINATOR','V_$STREAMS_APPLY_READER','V_$STREAMS_APPLY_SERVER','V_$STREAMS_CAPTURE','V_$STREAMS_POOL_ADVICE','V_$STREAMS_TRANSACTION','V_$SUBCACHE','V_$SYS_OPTIMIZER_ENV','V_$SYS_TIME_MODEL','V_$SYSAUX_OCCUPANTS','V_$SYSMETRIC','V_$SYSMETRIC_HISTORY','V_$SYSMETRIC_SUMMARY','V_$SYSSTAT','V_$SYSTEM_CURSOR_CACHE','V_$SYSTEM_EVENT','V_$SYSTEM_PARAMETER','V_$SYSTEM_PARAMETER2','V_$SYSTEM_WAIT_CLASS','V_$TABLESPACE','V_$TEMP_CACHE_TRANSFER','V_$TEMP_EXTENT_MAP','V_$TEMP_EXTENT_POOL','V_$TEMP_HISTOGRAM','V_$TEMP_PING','V_$TEMP_SPACE_HEADER','V_$TEMPFILE','V_$TEMPORARY_LOBS','V_$TEMPSTAT','V_$THREAD','V_$THRESHOLD_TYPES','V_$TIMER','V_$TIMEZONE_FILE','V_$TIMEZONE_NAMES','V_$TRANSACTION','V_$TRANSACTION_ENQUEUE','V_$TRANSPORTABLE_PLATFORM','V_$TSM_SESSIONS','V_$TYPE_SIZE','V_$UNDOSTAT','V_$UNUSABLE_BACKUPFILE_DETAILS','V_$VERSION','V_$VPD_POLICY','V_$WAITCLASSMETRIC','V_$WAITCLASSMETRIC_HISTORY','V_$WAITSTAT','V_$WALLET','V_$XML_AUDIT_TRAIL','WWV_FLOW_ACTIVITY_LOG','WWV_FLOW_BUILD_OPTIONS','WWV_FLOW_CLICKTHRU_LOG','WWV_FLOW_CLICKTHRU_LOG_V','WWV_FLOW_COLLECTIONS','WWV_FLOW_FILES','WWV_FLOW_FORMAT_MASKS','WWV_FLOW_GROUP_USERS','WWV_FLOW_HOURS_12','WWV_FLOW_HOURS_24','WWV_FLOW_MINUTES','WWV_FLOW_MINUTES_5','WWV_FLOW_MONTHS_MON','WWV_FLOW_MONTHS_MON_TEMP','WWV_FLOW_MONTHS_MONTH','WWV_FLOW_MONTHS_MONTH_TEMP','WWV_FLOW_PLSQL_JOBS','WWV_FLOW_TABSET_VIEW','WWV_FLOW_TABSET_VIEW2','WWV_FLOW_TEMPLATES_ALL','WWV_FLOW_TEMPLATES_USED','WWV_FLOW_USER_ACTIVITY_LOG','WWV_FLOW_USER_MAIL_LOG','WWV_FLOW_USER_MAIL_QUEUE','WWV_FLOW_USERS','WWV_FLOW_VERSION','WWV_FLOW_YEARS')");
if (nSchemaFilter != null && nSchemaFilter.Count > 0)
{
string CadenaFiltro = "";
foreach (var Filtro in nSchemaFilter)
{
if (CadenaFiltro != "")
CadenaFiltro += ", ";
CadenaFiltro += "'" + Filtro + "'";
}
sql.AppendLine(@"AND owner IN(" + CadenaFiltro + ")");
}
sql.AppendLine(@"ORDER BY 1 , 2 , 3");
DataTable table = ExecuteQueryGet(sql.ToString());
for (int i = 0; i < table.Rows.Count; i++)
{
DataRow row = table.Rows[i];
var newObjectRow = nObjectTable.NewTBL_ObjectRow();
newObjectRow.fk_Connection = nConnection.id_Connection;
newObjectRow.Catalog_Name = row["table_catalog"].ToString();
newObjectRow.Schema_Name = row["table_schema"].ToString();
newObjectRow.Object_Type = row["table_type"].ToString();
newObjectRow.Generic_Type = "View";
newObjectRow.Object_Name = row["table_name"].ToString();
newObjectRow.Selected = false;
nObjectTable.AddTBL_ObjectRow(newObjectRow);
}
}
catch (Exception ex)
{
throw new Exception("No fue posible obtener el listado de vistas " + base.Connection.DataSource + " , " + ex.Message, ex);
}
}
public override void FillDataBaseStoredProcedures(XsdDataBase.TBL_ObjectDataTable nObjectTable, XsdDataBase.TBL_ConnectionRow nConnection, List<string> nSchemaFilter)
{
try
{
var sql = new StringBuilder();
sql.AppendLine(@"SELECT sys_context('userenv', 'DB_NAME') AS routine_catalog ,u.name AS routine_schema, o.name AS routine_name,");
sql.AppendLine(@"'PROCEDURE' routine_type, DECODE(o.status, 1, 'V', 'I') status , 'StoredProcedure' AS generic_type");
sql.AppendLine(@"FROM sys.obj$ o, sys.USER$ u");
sql.AppendLine(@"WHERE(o.TYPE# = 7)");
sql.AppendLine(@"AND o.owner# = u.USER#");
sql.AppendLine(@"AND o.linkname IS NULL");
sql.AppendLine(@"AND o.name NOT IN ('ADD_JOB_HISTORY','APEX','AW_DROP_PROC','DBMS_FEATURE_PARTITION_SYSTEM','DBMS_FEATURE_PARTITION_USER','DBMS_FEATURE_PLSQL_NATIVE','DBMS_FEATURE_RAC','DBMS_FEATURE_REGISTER_ALLFEAT','DBMS_FEATURE_REGISTER_ALLHWM','DBMS_FEATURE_TEST_PROC_1','DBMS_FEATURE_TEST_PROC_2','DBMS_FEATURE_TEST_PROC_3','DBMS_FEATURE_TEST_PROC_4','DBMS_FEATURE_TEST_PROC_5','DBMS_LOGMNR_FFVTOLOGMNRT','DBMS_LOGMNR_OCTOLOGMNRT','DEVELOPMENT_SERVICE_HOME','DRI_MOVE_CTXSYS','F','HTMLDB','HTMLDB_ADMIN','HTMLDB_LOGIN','LOAD_UNDO_STAT','LOGMNR_GTLO3','LOGMNR_KRVRDA_TEST_APPLY','LOGMNR_KRVRDLUID3','LOGMNR_KRVRDREPDICT3','ODCICOLINFODUMP','ODCIENVDUMP','ODCIINDEXALTEROPTIONDUMP','ODCIINDEXCALLPROPERTYDUMP','ODCIINDEXINFODUMP','ODCIINDEXINFOFLAGSDUMP','ODCIPREDINFODUMP','ODCIQUERYINFODUMP','ODCISTATSOPTIONSDUMP','ODCITABFUNCINFODUMP','ORA$GRANT_SYS_SELECT','ORA$_SYS_REP_AUTH','P','PSTUB','PSTUBT','RESET_UNDO_STAT','SECURE_DML','SETMODFLG','SET_TABLESPACE','SUBPTXT','SUBPTXT2','SYNCRN','VALIDATE_CONTEXT','WWV_CREATE_FORUM_DEMO_SCRIPT','WWV_FLOW_COPY','WWV_FLOW_COPY_BUTTON','WWV_FLOW_COPY_LOV','WWV_FLOW_COPY_PAGE_ITEM','WWV_FLOW_INIT_HTP_BUFFER','WWV_FLOW_SEED_TRANSLATIONS','WWV_FLOW_SYNC_TRANSLATIONS','XDB_DATASTORE_PROC','XDB$INITXDBSCHEMA','XDB$PATCHUPDELETESCHEMA','XDB$PATCHUPSCHEMA','Z')");
sql.AppendLine(@"UNION SELECT sys_context('userenv', 'DB_NAME') AS routine_catalog , U.NAME AS routine_schema, o.name || '.' || pi.procedurename AS routine_name,");
sql.AppendLine(@"'PACKAGE' routine_type, DECODE(o.status, 1, 'V', 'I') status, 'StoredProcedure' AS generic_type");
sql.AppendLine(@"FROM sys.obj$ o, sys.USER$ u , sys.procedureinfo$ pi ");
sql.AppendLine(@"WHERE(o.TYPE# = 9 And o.owner# = u.USER# And o.obj# = pi.obj# And o.linkname IS NULL)");
sql.AppendLine(@"AND o.name NOT IN ('CTX_ADM','CTX_CATSEARCH','CTX_CLS','CTX_CONTAINS','CTX_DDL','CTX_DOC','CTX_MATCHES','CTX_OUTPUT','CTX_QUERY','CTX_REPORT','CTX_THES','CTX_ULEXER','CTX_XPCONTAINS','DBMS_ADVANCED_REWRITE','DBMS_ADVISOR','DBMS_ALERT','DBMS_APPCTX','DBMS_APPLICATION_INFO','DBMS_APPLY_ADM','DBMS_APPLY_ADM_INTERNAL','DBMS_APPLY_ERROR','DBMS_APPLY_PROCESS','DBMS_APPLY_USER_AGENT','DBMS_AQ','DBMS_AQADM','DBMS_AQADM_SYS','DBMS_AQADM_SYSCALLS','DBMS_AQ_BQVIEW','DBMS_AQELM','DBMS_AQ_EXP_CMT_TIME_TABLES','DBMS_AQ_EXP_HISTORY_TABLES','DBMS_AQ_EXP_INDEX_TABLES','DBMS_AQ_EXP_QUEUES','DBMS_AQ_EXP_QUEUE_TABLES','DBMS_AQ_EXP_SIGNATURE_TABLES','DBMS_AQ_EXP_SUBSCRIBER_TABLES','DBMS_AQ_EXP_TIMEMGR_TABLES','DBMS_AQ_EXP_ZECURITY','DBMS_AQ_IMP_INTERNAL','DBMS_AQ_IMPORT_INTERNAL','DBMS_AQ_IMP_ZECURITY','DBMS_AQIN','DBMS_AQ_INV','DBMS_AQJMS','DBMS_AQJMS_INTERNAL','DBMS_AQ_SYS_EXP_ACTIONS','DBMS_AQ_SYS_EXP_INTERNAL','DBMS_AQ_SYS_IMP_INTERNAL','DBMS_ASH_INTERNAL','DBMS_ASSERT','DBMS_ASYNCRPC_PUSH','DBMS_AW','DBMS_AW_EXP','DBMS_BACKUP_RESTORE','DBMS_CAPTURE_ADM','DBMS_CAPTURE_ADM_INTERNAL','DBMS_CAPTURE_PROCESS','DBMS_CHANGE_NOTIFICATION','DBMS_CLR','DBMS_CRYPTO','DBMS_CRYPTO_FFI','DBMS_CRYPTO_TOOLKIT','DBMS_CRYPTO_TOOLKIT_FFI','DBMS_CRYPTO_TOOLKIT_TYPES','DBMS_DATA_MINING_DUMMY','DBMS_DATAPUMP','DBMS_DATAPUMP_UTL','DBMS_DBLINK','DBMS_DBVERIFY','DBMS_DB_VERSION','DBMS_DDL','DBMS_DDL_INTERNAL','DBMS_DEBUG','DBMS_DEBUG_JDWP','DBMS_DEBUG_JDWP_CUSTOM','DBMS_DEFER','DBMS_DEFER_ENQ_UTL','DBMS_DEFERGEN','DBMS_DEFERGEN_AUDIT','DBMS_DEFERGEN_INTERNAL','DBMS_DEFERGEN_LOB','DBMS_DEFERGEN_PRIORITY','DBMS_DEFERGEN_RESOLUTION','DBMS_DEFERGEN_UTIL','DBMS_DEFERGEN_WRAP','DBMS_DEFER_IMPORT_INTERNAL','DBMS_DEFER_INTERNAL_QUERY','DBMS_DEFER_INTERNAL_SYS','DBMS_DEFER_QUERY','DBMS_DEFER_QUERY_UTL','DBMS_DEFER_REPCAT','DBMS_DEFER_SYS','DBMS_DEFER_SYS_PART1','DBMS_DESCRIBE','DBMS_DIMENSION','DBMS_DISTRIBUTED_TRUST_ADMIN','DBMS_DRS','DBMS_EPG','DBMS_ERRLOG','DBMS_EXPORT_EXTENSION','DBMS_EXTENDED_TTS_CHECKS','DBMS_FBT','DBMS_FEATURE_USAGE','DBMS_FEATURE_USAGE_INTERNAL','DBMS_FEATURE_USAGE_REPORT','DBMS_FGA','DBMS_FILE_GROUP','DBMS_FILE_GROUP_DECL','DBMS_FILE_GROUP_EXP','DBMS_FILE_GROUP_EXP_INTERNAL','DBMS_FILE_GROUP_IMP','DBMS_FILE_GROUP_IMP_INTERNAL','DBMS_FILE_GROUP_INTERNAL_INVOK','DBMS_FILE_GROUP_UTL','DBMS_FILE_GROUP_UTL_INVOK','DBMS_FILE_TRANSFER','DBMS_FLASHBACK','DBMS_FREQUENT_ITEMSET','DBMS_HA_ALERTS','DBMS_HA_ALERTS_PRVT','DBMS_HS','DBMS_HS_ALT','DBMS_HS_CHK','DBMS_HS_UTL','DBMSHSXP','DBMS_IAS_CONFIGURE','DBMS_IAS_INST','DBMS_IAS_INST_UTL','DBMS_IAS_INST_UTL_EXP','DBMS_IAS_MT_INST','DBMS_IAS_MT_INST_INTERNAL','DBMS_IAS_QUERY','DBMS_IAS_SESSION','DBMS_IAS_TEMPLATE','DBMS_IAS_TEMPLATE_INTERNAL','DBMS_IAS_TEMPLATE_UTL','DBMS_I_INDEX_UTL','DBMS_IJOB','DBMS_INDEX_UTL','DBMS_INTERNAL_LOGSTDBY','DBMS_INTERNAL_REPCAT','DBMS_INTERNAL_SAFE_SCN','DBMS_INTERNAL_TRIGGER','DBMS_IREFRESH','DBMS_ISCHED','DBMS_ISCHED_CHAIN_CONDITION','DBMS_ISNAPSHOT','DBMS_ITRIGGER_UTL','DBMS_JAVA_DUMP','DBMS_JAVA_TEST','DBMS_JOB','DBMS_LCR','DBMS_LDAP','DBMS_LDAP_API_FFI','DBMS_LDAP_UTL','DBMS_LOB','DBMS_LOCK','DBMS_LOGMNR','DBMS_LOGMNR_D','DBMS_LOGMNR_INTERNAL','DBMS_LOGMNR_LOGREP_DICT','DBMS_LOGMNR_SESSION','DBMS_LOGREP_DEF_PROC_UTL','DBMS_LOGREP_EXP','DBMS_LOGREP_IMP','DBMS_LOGREP_IMP_INTERNAL','DBMS_LOGREP_UTIL','DBMS_LOGREP_UTIL_INVOK','DBMS_LOGSTDBY','DBMS_MAINT_GEN','DBMS_METADATA','DBMS_METADATA_BUILD','DBMS_METADATA_DPBUILD','DBMS_METADATA_INT','DBMS_METADATA_UTIL','DBMS_MONITOR','DBMS_OBFUSCATION_TOOLKIT','DBMS_OBFUSCATION_TOOLKIT_FFI','DBMSOBJG','DBMSOBJG_DP','DBMSOBJGWRAPPER','DBMSOBJG2','DBMS_ODCI','DBMS_OFFLINE_INTERNAL','DBMS_OFFLINE_OG','DBMS_OFFLINE_RGT','DBMS_OFFLINE_SNAPSHOT','DBMS_OFFLINE_UTL','DBMS_OUTPUT','DBMS_PCLXUTIL','DBMS_PICKLER','DBMS_PIPE','DBMS_PITR','DBMS_PLUGTS','DBMS_PLUGTSP','DBMS_PREPROCESSOR','DBMS_PROFILER','DBMS_PROPAGATION_ADM','DBMS_PROPAGATION_INTERNAL','DBMS_PRVTAQIM','DBMS_PRVTAQIP','DBMS_PRVTAQIS','DBMS_PRVTRMIE','DBMS_PRVT_TRACE','DBMS_PSP','DBMS_PSWMG_IMPORT','DBMS_RANDOM','DBMS_RCVMAN','DBMS_RECO_SCRIPT_INT','DBMS_RECO_SCRIPT_INVOK','DBMS_RECOVERABLE_SCRIPT','DBMS_RECTIFIER_DIFF','DBMS_RECTIFIER_FRIENDS','DBMS_REDEFINITION','DBMS_REFRESH','DBMS_REFRESH_EXP_LWM','DBMS_REFRESH_EXP_SITES','DBMS_REGISTRY','DBMS_REGISTRY_SERVER','DBMS_REGISTRY_SYS','DBMS_REGXDB','DBMS_REPAIR','DBMS_REPCAT','DBMS_REPCAT_ADD_MASTER','DBMS_REPCAT_ADMIN','DBMS_REPCAT_AUTH','DBMS_REPCAT_AUTH','DBMS_REPCAT_CACHE','DBMS_REPCAT_COMMON_UTL','DBMS_REPCAT_CONF','DBMS_REPCAT_DECL','DBMS_REPCAT_EXP','DBMS_REPCAT_FLA','DBMS_REPCAT_FLA_MAS','DBMS_REPCAT_FLA_UTL','DBMS_REPCAT_INSTANTIATE','DBMS_REPCAT_INTERNAL','DBMS_REPCAT_INTERNAL_PACKAGE','DBMS_REPCAT_MAS','DBMS_REPCAT_MIG','DBMS_REPCAT_MIG_INTERNAL','DBMS_REPCAT_MIGRATION','DBMS_REPCAT_OBJ_UTL','DBMS_REPCAT_OUTPUT','DBMS_REPCAT_RGT','DBMS_REPCAT_RGT_ALT','DBMS_REPCAT_RGT_CHK','DBMS_REPCAT_RGT_CUST','DBMS_REPCAT_RGT_CUST2','DBMS_REPCAT_RGT_EXP','DBMS_REPCAT_RGT_UTL','DBMS_REPCAT_RPC','DBMS_REPCAT_RPC_UTL','DBMS_REPCAT_RQ','DBMS_REPCAT_SNA','DBMS_REPCAT_SNA_UTL','DBMS_REPCAT_SQL_UTL','DBMS_REPCAT_UNTRUSTED','DBMS_REPCAT_UTL','DBMS_REPCAT_UTL2','DBMS_REPCAT_UTL3','DBMS_REPCAT_UTL4','DBMS_REPCAT_VALIDATE','DBMS_REPUTIL','DBMS_REPUTIL2','DBMS_RESOURCE_MANAGER','DBMS_RESOURCE_MANAGER_PRIVS','DBMS_RESUMABLE','DBMS_RLS','DBMS_RMGR_GROUP_EXPORT','DBMS_RMGR_PACT_EXPORT','DBMS_RMGR_PLAN_EXPORT','DBMS_RMIN','DBMS_ROWID','DBMS_RULE','DBMS_RULE_ADM','DBMS_RULEADM_INTERNAL','DBMS_RULE_COMPATIBLE_90','DBMS_RULE_EXIMP','DBMS_RULE_EXP_EC_INTERNAL','DBMS_RULE_EXP_EV_CTXS','DBMS_RULE_EXP_RL_INTERNAL','DBMS_RULE_EXP_RS_INTERNAL','DBMS_RULE_EXP_RULES','DBMS_RULE_EXP_RULE_SETS','DBMS_RULE_EXP_UTL','DBMS_RULE_EXP_UTLI','DBMS_RULE_IMP_OBJ','DBMS_SCHED_CHAIN_EXPORT','DBMS_SCHED_CLASS_EXPORT','DBMS_SCHED_EXPORT_CALLOUTS','DBMS_SCHED_JOB_EXPORT','DBMS_SCHED_MAIN_EXPORT','DBMS_SCHED_PROGRAM_EXPORT','DBMS_SCHED_SCHEDULE_EXPORT','DBMS_SCHEDULER','DBMS_SCHED_WINDOW_EXPORT','DBMS_SCHED_WINGRP_EXPORT','DBMS_SCHEMA_COPY','DBMS_SERVER_ALERT','DBMS_SERVER_ALERT_EXPORT','DBMS_SERVER_ALERT_PRVT','DBMS_SERVER_TRACE','DBMS_SERVICE','DBMS_SESSION','DBMS_SNAP_INTERNAL','DBMS_SNAP_REPAPI','DBMS_SNAPSHOT','DBMS_SNAPSHOT_UTL','DBMS_SPACE','DBMS_SPACE_ADMIN','DBMS_SQL','DBMS_SQLHASH','DBMS_SQLPLUS_SCRIPT','DBMS_SQLTUNE','DBMS_SQLTUNE_INTERNAL','DBMS_STANDARD','DBMS_STAT_FUNCS','DBMS_STAT_FUNCS_AUX','DBMS_STATS','DBMS_STATS_INTERNAL','DBMS_STORAGE_MAP','DBMS_STREAMS','DBMS_STREAMS_ADM','DBMS_STREAMS_ADM_UTL','DBMS_STREAMS_ADM_UTL_INT','DBMS_STREAMS_ADM_UTL_INVOK','DBMS_STREAMS_AUTH','DBMS_STREAMS_CDC_ADM','DBMS_STREAMS_DATAPUMP','DBMS_STREAMS_DATAPUMP_UTIL','DBMS_STREAMS_DECL','DBMS_STREAMS_LCR_INT','DBMS_STREAMS_MESSAGING','DBMS_STREAMS_MT','DBMS_STREAMS_PUB_RPC','DBMS_STREAMS_RPC','DBMS_STREAMS_RPC_INTERNAL','DBMS_STREAMS_TABLESPACE_ADM','DBMS_STREAMS_TBS_INT','DBMS_STREAMS_TBS_INT_INVOK','DBMS_SUMADV','DBMS_SUMADVISOR','DBMS_SUMMARY','DBMS_SUMREF_UTIL','DBMS_SUM_RWEQ_EXPORT','DBMS_SUM_RWEQ_EXPORT_INTERNAL','DBMS_SUMVDM','DBMS_SWRF_INTERNAL','DBMS_SWRF_REPORT_INTERNAL','DBMS_SYS_ERROR','DBMS_SYS_SQL','DBMS_SYSTEM','DBMS_TDB','DBMS_TDE_TOOLKIT','DBMS_TDE_TOOLKIT_FFI','DBMS_TRACE','DBMS_TRANSACTION','DBMS_TRANSACTION_INTERNAL_SYS','DBMS_TRANSFORM','DBMS_TRANSFORM_EXIMP','DBMS_TRANSFORM_EXIMP_INTERNAL','DBMS_TRANSFORM_INTERNAL','DBMS_TSM','DBMS_TSM_PRVT','DBMS_TTS','DBMS_TYPES','DBMS_TYPE_UTILITY','DBMS_UNDO_ADV','DBMS_UPGRADE_INTERNAL','DBMS_UTILITY','DBMS_WARNING','DBMS_WARNING_INTERNAL','DBMS_WORKLOAD_REPOSITORY','DBMS_XDB','DBMS_XDBT','DBMS_XDBUTIL_INT','DBMS_XDB_VERSION','DBMS_XDBZ','DBMS_XDBZ0','DBMS_XMLDOM','DBMS_XMLGEN','DBMS_XMLINDEX','DBMS_XMLPARSER','DBMS_XMLSCHEMA','DBMS_XMLSCHEMA_INT','DBMS_XMLSTORE','DBMS_XPLAN','DBMS_XRWMV','DBMS_XSLPROCESSOR','DBMSZEXP_SYSPKGGRNT','DBMS_ZHELP','DBMS_ZHELP_IR','DIANA','DIUTIL','DM_CL_CUR','DM_SVM_CUR','DR_DEF','DRIACC','DRICON','DRIDISP','DRIDML','DRIDOC','DRIERR','DRIEXP','DRIG','DRIIMP','DRIIXS','DRILIST','DRILOAD','DRIMLX','DRIOBJ','DRIOPT','DRIPARSE','DRIPARX','DRIPREF','DRIREC','DRIREP','DRIREPM','DRIREPZ','DRISCORE','DRISCORR','DRISGP','DRISPL','DRITHS','DRITHSC','DRITHSD','DRITHSL','DRITHSX','DRIUTL','DRIVAL','DRIXMD','DRUE','DRVDDL','DRVDDLC','DRVDDLR','DRVDDLX','DRVDISP','DRVDML','DRVDOC','DRVIMR','DRVODM','DRVPARX','DRVTMT','DRVUTL','DRVXMD','DRVXTAB','DRVXTABC','DRVXTABR','DRVXTABX','DRV0DDL','HTF','HTMLDB_CUSTOM_AUTH','HTMLDB_ITEM','HTMLDB_LANG','HTMLDB_SITE_ADMIN_PRIVS','HTMLDB_SYSTEM','HTMLDB_UTIL','HTP','KUPCC','KUPC$QUE_INT','KUPC$QUEUE','KUPC$QUEUE_INT','KUPD$DATA','KUPD$DATA_INT','KUPF$FILE','KUPF$FILE_INT','KUPM$MCP','KUPP$PROC','KUPV$FT','KUPV$FT_INT','KUPW$WORKER','LCR$_XML_SCHEMA','LOGMNR_DICT_CACHE','MD','MDERR','MD_LRS','MDPRVT_IDX','MD1','MD2','MGMT_BSLN','MGMT_BSLN_INTERNAL','MGMT_RESPONSE','ODCICONST','ODM_UTIL_DUMMY','OUTLN_EDIT_PKG','OUTLN_PKG','OWA','OWA_CACHE','OWA_COOKIE','OWA_CUSTOM','OWA_CX','OWA_IMAGE','OWA_MATCH','OWA_OPT_LOCK','OWA_PATTERN','OWA_SEC','OWA_TEXT','OWA_UTIL','PBREAK','PBRPH','PBSDE','PBUTL','PIDL','PLITBLM','PRVT_ACCESS_ADVISOR','PRVT_ADVISOR','PRVT_DIMENSION_SYS_UTIL','PRVT_HDM','PRVT_IDX','PRVT_SYS_TUNE_MVIEW','PRVT_TUNE_MVIEW','PRVT_UADV','PRVT_WORKLOAD','PRVT_WORKLOAD_NOPRIV','RTREE_IDX','SDO','SDO_ADMIN','SDO_CATALOG','SDO_CS','SDO_GEOM','SDO_IDX','SDO_LRS','SDO_META','SDO_MIGRATE','SDO_PRIDX','SDO_RELATE_MASK','SDO_RTREE_ADMIN','SDO_TOPO_METADATA','SDO_TPIDX','SDO_TUNE','SDO_UTIL','SDO_3GL','STANDARD','SYS_STUB_FOR_PURITY_ANALYSIS','TRANSFORM_MAP','URIFACTORY','UTL_COLL','UTL_COMPRESS','UTL_ENCODE','UTL_FILE','UTL_GDK','UTL_HTTP','UTL_INADDR','UTL_I18N','UTL_LMS','UTL_MATCH','UTL_RAW','UTL_RECOMP','UTL_REF','UTL_SMTP','UTL_SYS_COMPRESS','UTL_TCP','UTL_URL','UTL_XML','WPG_DOCLOAD','WPIUTL','WWV_CALCULATOR','WWV_CRYPT','WWV_EXECUTE_IMMEDIATE','WWV_FLOW','WWV_FLOW_ADMIN_API','WWV_FLOW_API','WWV_FLOW_ASFCOOKIE','WWV_FLOW_AUDIT','WWV_FLOW_BUILDER','WWV_FLOW_CACHE','WWV_FLOW_CALENDAR3','WWV_FLOW_CHANGE_PASSWORD','WWV_FLOW_CHECK','WWV_FLOW_COLLECTION','WWV_FLOW_COLLECTIONS_SHOWCASE','WWV_FLOW_CONDITIONS','WWV_FLOW_COPY_METADATA','WWV_FLOW_COPY_PAGE','WWV_FLOW_COPY_UTIL','WWV_FLOW_CREATE_FLOW_API','WWV_FLOW_CREATE_MODEL_APP','WWV_FLOW_CSS_API','WWV_FLOW_CUSTOM_AUTH','WWV_FLOW_CUSTOM_AUTH_LDAP','WWV_FLOW_CUSTOM_AUTH_STD','WWV_FLOW_CUSTOMIZE','WWV_FLOW_DATALOAD_XML','WWV_FLOW_DATA_QUICK_FLOW','WWV_FLOW_DEVELOPER_TOOLBAR','WWV_FLOW_DISP_PAGE_PLUGS','WWV_FLOW_DML','WWV_FLOW_DOWNLOAD','WWV_FLOW_DYNSQL_UTIL','WWV_FLOW_EDIT_REPORT','WWV_FLOW_ELEMENT','WWV_FLOW_EPG_INCLUDE_MODULES','WWV_FLOW_FILE_API','WWV_FLOW_FILE_MGR','WWV_FLOW_FILE_OBJECT_ID','WWV_FLOW_FND_DEVELOPER_API','WWV_FLOW_FND_FUNCTION','WWV_FLOW_FND_GLOBAL','WWV_FLOW_FND_USER_API','WWV_FLOW_FND_USER_PW_PREF','WWV_FLOW_FORM_CONTROL','WWV_FLOW_FORMS','WWV_FLOW_GEN_API2','WWV_FLOW_GENERATE_DDL','WWV_FLOW_GENERATE_TABLE_API','WWV_FLOW_GENERIC','WWV_FLOW_GENERIC_ATTR','WWV_FLOW_GEN_GLOBAL_API','WWV_FLOW_GEN_HINT','WWV_FLOW_GLOBAL','WWV_FLOW_HELP','WWV_FLOW_HINT','WWV_FLOW_HTML_API','WWV_FLOW_ID','WWV_FLOW_IMAGE_API','WWV_FLOW_IMP_PARSER','WWV_FLOW_ISC','WWV_FLOW_ITEM','WWV_FLOW_ITEM_HELP','WWV_FLOW_JOB','WWV_FLOW_LANG','WWV_FLOW_LDAP','WWV_FLOW_LIST','WWV_FLOW_LOAD_DATA','WWV_FLOW_LOAD_EXCEL_DATA','WWV_FLOW_LOG','WWV_FLOW_LOGIN','WWV_FLOW_LOOKUP_TABLES','WWV_FLOW_MAIL','WWV_FLOW_META_DATA','WWV_FLOW_MIGRATE_METADATA','WWV_FLOW_MODEL_API','WWV_FLOW_PLATFORM','WWV_FLOW_PLSQL_EDITOR','WWV_FLOW_PLSQL_JOB','WWV_FLOW_POPUP_LOV','WWV_FLOW_PPR_UTIL','WWV_FLOW_PREFERENCES','WWV_FLOW_PRESIDENTS_EXAMPLE','WWV_FLOW_PROCESS_UTILITY','WWV_FLOW_PROVISION','WWV_FLOW_PROVISIONING','WWV_FLOW_QUERY','WWV_FLOW_QUERY_API','WWV_FLOW_QUERY_BUILDER','WWV_FLOW_RANDOM','WWV_FLOW_REGEXP','WWV_FLOW_REGION_LAYOUT','WWV_FLOW_REGION_TREE','WWV_FLOW_RENDER_QUERY','WWV_FLOW_RENDER_SHORTCUT','WWV_FLOW_REWRITE_QUERY','WWV_FLOW_SAMPLE_APP','WWV_FLOW_SCRIPT_EXPORT','WWV_FLOW_SC_TRANSACTIONS','WWV_FLOW_SECURITY','WWV_FLOW_SERIES_ATTR','WWV_FLOW_SESSION_MON','WWV_FLOW_SVG','WWV_FLOW_SW_API','WWV_FLOW_SW_OBJECT_FEED','WWV_FLOW_SW_PAGE_CALLS','WWV_FLOW_SW_PARSER','WWV_FLOW_SW_SCRIPT','WWV_FLOW_SW_UPGRADE','WWV_FLOW_SW_UTIL','WWV_FLOW_TABLE_DRILL','WWV_FLOW_TAB_MGR','WWV_FLOW_TEMP','WWV_FLOW_TEMPLATE_API','WWV_FLOW_TEMPLATES_UTIL','WWV_FLOW_THEME_FILES','WWV_FLOW_THEME_GLOBALS','WWV_FLOW_THEME_MANAGER','WWV_FLOW_THEME_1','WWV_FLOW_THEME_10','WWV_FLOW_THEME_11','WWV_FLOW_THEME_12','WWV_FLOW_THEME_2','WWV_FLOW_THEME_3','WWV_FLOW_THEME_4','WWV_FLOW_THEME_5','WWV_FLOW_THEME_6','WWV_FLOW_THEME_7','WWV_FLOW_THEME_8','WWV_FLOW_THEME_9','WWV_FLOW_TRANSLATION_UTILITIES','WWV_FLOW_TREE','WWV_FLOW_TREE_GLOBAL_VARS','WWV_FLOW_UPGRADE','WWV_FLOW_UPGRADE_REPORT','WWV_FLOW_USER_API','WWV_FLOW_UTILITIES','WWV_FLOW_VAL','WWV_FLOW_WEB_SERVICES','WWV_FLOW_WEBSERVICES_EXAMPLE','WWV_FLOW_WIZARD_API','WWV_FLOW_WIZARD_UTILITIES','WWV_FLOW_XE_CONFIG','WWV_FLOW_XE_PROVISION','WWV_FLOW_XLIFF','WWV_HTF','WWV_HTP','WWV_META_CLEANUP','WWV_RENDER_CALENDAR2','WWV_RENDER_CHART2','WWV_RENDER_REPORT3','WWV_SPELING','XDB_ANCOP','XDB_FUNCIMPL','XDBPI_FUNCIMPL','XDB_PITRIG_PKG','XDB_PVTRIG_PKG','XDB_RVTRIG_PKG','XMLINDEX_FUNCIMPL','XML_SCHEMA_NAME_PRESENT','XMLTM_FUNCIMPL')");
if (nSchemaFilter != null && nSchemaFilter.Count > 0)
{
string CadenaFiltro = "";
foreach (var Filtro in nSchemaFilter)
{
if (CadenaFiltro != "")
CadenaFiltro += ", ";
CadenaFiltro += "'" + Filtro + "'";
}
sql.AppendLine(@"AND u.name IN(" + CadenaFiltro + ")");
}
sql.AppendLine(@"ORDER BY 1 , 2 , 3");
DataTable table = ExecuteQueryGet(sql.ToString());
for (int i = 0; i < table.Rows.Count; i++)
{
DataRow row = table.Rows[i];
var newObjectRow = nObjectTable.NewTBL_ObjectRow();
newObjectRow.fk_Connection = nConnection.id_Connection;
newObjectRow.Catalog_Name = row["routine_catalog"].ToString();
newObjectRow.Schema_Name = row["routine_schema"].ToString();
newObjectRow.Object_Type = row["routine_type"].ToString();
newObjectRow.Generic_Type = "StoredProcedure";
newObjectRow.Object_Name = row["routine_name"].ToString();
newObjectRow.Selected = false;
nObjectTable.AddTBL_ObjectRow(newObjectRow);
}
}
catch (Exception ex)
{
throw new Exception("No fue posible obtener el listado de procedimientos almacenados " + base.Connection.DataSource + " , " + ex.Message, ex);
}
}