PDA

View Full Version : What rights/role or SQL used for 'Explore'



stu_purvis
04-10-2006, 08:06 AM
When I hit the Explore button on the Connection Information screen it just locks up on 'Getting Schema Information' - I can connect OK - I am connecting to an Oracle 9i database - release 9.2.0.6.0 64 bit in HP-UX. I am suspecting a role or privelege problem as I have used a table in the database as an input with no problems, but I'd like to use one as an output - specifically an update, now but I can't retrieve the columns and I suspect both problems are related. Thanks.

MattCasters
04-10-2006, 11:01 AM
Hi Stu,

It should never "lock up" at all. I would consider that a bug.
The thing that's probably happening is that the database explorer gets all the tables, views etc. from the complete database. In case you have something big in one of the schema's (let's say SAP) you might have problem in getting the info over to Kettle fast enough.
I intend to solve this in the future by building intelligent Tree views that will query the database when you open a sub-tree. In the new SWT "Tree" widget you can embed graphics that can show progress-bars etc ;-)

As for the rest: to minimize the user-rights problems this is the query that gets executed (for Oracle) to retrieve the fields that are in a certain table:

SELECT /*+FIRST_ROWS*/ * FROM tableName WHERE ROWNUM < 1

The data dictionary lookups to populate the DB explorer are done through the standard JDBC meta-data. I guess that you would need at least read access to views user_tables, user_tab_columns etc.

Hope this helps,

Matt

stu_purvis
04-10-2006, 11:33 AM
It's been stuck on the 'Getting schema information' with the bars a little less than half-way up for about 20 minutes, now - if I hit cancel - nothing happens - I end up having to give her the old 3 finger salute and knock Spoon out via the task manager. This Oracle database is small which led me to suspect a role issue - I've been using this feature against DB2 databases with no problems - plus the fact that I can use the SQL Editor against this Oracle database and query tables to my hearts desire. Hmmmm....

stu_purvis
04-10-2006, 11:56 AM
Here's the views I have SELECT on


ALL_ALL_TABLES
ALL_APPLY
ALL_APPLY_CONFLICT_COLUMNS
ALL_APPLY_DML_HANDLERS
ALL_APPLY_ERROR
ALL_APPLY_KEY_COLUMNS
ALL_APPLY_PARAMETERS
ALL_APPLY_PROGRESS
ALL_ARGUMENTS
ALL_ASSOCIATIONS
ALL_BASE_TABLE_MVIEWS
ALL_CAPTURE
ALL_CAPTURE_PARAMETERS
ALL_CAPTURE_PREPARED_DATABASE
ALL_CAPTURE_PREPARED_SCHEMAS
ALL_CAPTURE_PREPARED_TABLES
ALL_CATALOG
ALL_CLUSTERS
ALL_CLUSTER_HASH_EXPRESSIONS
ALL_COLL_TYPES
ALL_COL_COMMENTS
ALL_COL_PRIVS
ALL_COL_PRIVS_MADE
ALL_COL_PRIVS_RECD
ALL_CONSTRAINTS
ALL_CONS_COLUMNS
ALL_CONS_OBJ_COLUMNS
ALL_CONTEXT
ALL_DB_LINKS
ALL_DEF_AUDIT_OPTS
ALL_DEPENDENCIES
ALL_DIMENSIONS
ALL_DIM_ATTRIBUTES
ALL_DIM_CHILD_OF
ALL_DIM_HIERARCHIES
ALL_DIM_JOIN_KEY
ALL_DIM_LEVELS
ALL_DIM_LEVEL_KEY
ALL_DIRECTORIES
ALL_ERRORS
ALL_EVALUATION_CONTEXTS
ALL_EVALUATION_CONTEXT_TABLES
ALL_EVALUATION_CONTEXT_VARS
ALL_EXTERNAL_LOCATIONS
ALL_EXTERNAL_TABLES
ALL_GEOMETRY_COLUMNS
ALL_INDEXES
ALL_INDEXTYPES
ALL_INDEXTYPE_OPERATORS
ALL_IND_COLUMNS
ALL_IND_EXPRESSIONS
ALL_IND_PARTITIONS
ALL_IND_SUBPARTITIONS
ALL_INTERNAL_TRIGGERS
ALL_JAVA_ARGUMENTS
ALL_JAVA_CLASSES
ALL_JAVA_DERIVATIONS
ALL_JAVA_FIELDS
ALL_JAVA_IMPLEMENTS
ALL_JAVA_INNERS
ALL_JAVA_LAYOUTS
ALL_JAVA_METHODS
ALL_JAVA_NCOMPS
ALL_JAVA_RESOLVERS
ALL_JAVA_THROWS
ALL_JOIN_IND_COLUMNS
ALL_LIBRARIES
ALL_LOBS
ALL_LOB_PARTITIONS
ALL_LOB_SUBPARTITIONS
ALL_LOB_TEMPLATES
ALL_LOG_GROUPS
ALL_LOG_GROUP_COLUMNS
ALL_METHOD_PARAMS
ALL_METHOD_RESULTS
ALL_MVIEWS
ALL_MVIEW_AGGREGATES
ALL_MVIEW_ANALYSIS
ALL_MVIEW_DETAIL_RELATIONS
ALL_MVIEW_JOINS
ALL_MVIEW_KEYS
ALL_MVIEW_LOGS
ALL_MVIEW_REFRESH_TIMES
ALL_NESTED_TABLES
ALL_OBJECTS
ALL_OBJECT_TABLES
ALL_OBJ_COLATTRS
ALL_OPANCILLARY
ALL_OPARGUMENTS
ALL_OPBINDINGS
ALL_OPERATORS
ALL_PARTIAL_DROP_TABS
ALL_PART_COL_STATISTICS
ALL_PART_HISTOGRAMS
ALL_PART_INDEXES
ALL_PART_KEY_COLUMNS
ALL_PART_LOBS
ALL_PART_TABLES
ALL_PENDING_CONV_TABLES
ALL_POLICIES
ALL_POLICY_CONTEXTS
ALL_POLICY_GROUPS
ALL_PROBE_OBJECTS
ALL_PROCEDURES
ALL_PROPAGATION
ALL_PUBLISHED_COLUMNS
ALL_QUEUES
ALL_QUEUE_PUBLISHERS
ALL_QUEUE_TABLES
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_REPCATLOG
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_REPCOLUMN
ALL_REPCOLUMN_GROUP
ALL_REPCONFLICT
ALL_REPDDL
ALL_REPFLAVORS
ALL_REPFLAVOR_COLUMNS
ALL_REPFLAVOR_OBJECTS
ALL_REPGENERATED
ALL_REPGENOBJECTS
ALL_REPGROUP
ALL_REPGROUPED_COLUMN
ALL_REPGROUP_PRIVILEGES
ALL_REPKEY_COLUMNS
ALL_REPOBJECT
ALL_REPPARAMETER_COLUMN
ALL_REPPRIORITY
ALL_REPPRIORITY_GROUP
ALL_REPPROP
ALL_REPRESOLUTION
ALL_REPRESOLUTION_METHOD
ALL_REPRESOLUTION_STATISTICS
ALL_REPRESOL_STATS_CONTROL
ALL_REPSCHEMA
ALL_REPSITES
ALL_RULES
ALL_RULESETS
ALL_RULE_SETS
ALL_RULE_SET_RULES
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_SEQUENCES
ALL_SNAPSHOTS
ALL_SNAPSHOT_LOGS
ALL_SOURCE
ALL_SOURCE_TABLES
ALL_SOURCE_TAB_COLUMNS
ALL_SQLJ_TYPES
ALL_SQLJ_TYPE_ATTRS
ALL_SQLJ_TYPE_METHODS
ALL_STORED_SETTINGS
ALL_STREAMS_GLOBAL_RULES
ALL_STREAMS_SCHEMA_RULES
ALL_STREAMS_TABLE_RULES
ALL_SUBPARTITION_TEMPLATES
ALL_SUBPART_COL_STATISTICS
ALL_SUBPART_HISTOGRAMS
ALL_SUBPART_KEY_COLUMNS
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_TABLES
ALL_TAB_COLS
ALL_TAB_COLUMNS
ALL_TAB_COL_STATISTICS
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_SUBPARTITIONS
ALL_TRIGGERS
ALL_TRIGGER_COLS
ALL_TYPES
ALL_TYPE_ATTRS
ALL_TYPE_METHODS
ALL_TYPE_VERSIONS
ALL_UNUSED_COL_TABS
ALL_UPDATABLE_COLUMNS
ALL_USERS
ALL_USTATS
ALL_VARRAYS
ALL_VERSION_HVIEW
ALL_VIEWS
ALL_WM_LOCKED_TABLES
ALL_WM_MODIFIED_TABLES
ALL_WM_RIC_INFO
ALL_WM_TAB_TRIGGERS
ALL_WM_VERSIONED_TABLES
ALL_WM_VT_ERRORS
ALL_WORKSPACES
ALL_WORKSPACES_INTERNAL
ALL_WORKSPACE_PRIVS
ALL_WORKSPACE_SAVEPOINTS
ALL_XML_SCHEMAS
ALL_XML_TABLES
ALL_XML_TAB_COLS
ALL_XML_VIEWS
ALL_XML_VIEW_COLS
CATALOG
CMISPB_ACTING_V
CMISPB_AIS_CONTROL_NUMBERS_V
CMISPB_AIS_RELEASE_V
CMISPB_AIS_V
CMISPB_ALL_CCO_V
CMISPB_ALL_USER_UNAVAIL_V
CMISPB_AM_RELATIONSHIPS_V
CMISPB_CCO_VX
CMISPB_CI_DELIVERY_V
CMISPB_CI_DELIV_AND_TEST_V
CMISPB_CI_DEPENDENCY_V
CMISPB_CI_FUNCTION_POINT_DAT_V
CMISPB_CI_ROLL_UP_V
CMISPB_CI_TDR_V
CMISPB_CI_TEST_V
CMISPB_CI_TYPE_V
CMISPB_CI_TYPE_VX
CMISPB_CI_V
CMISPB_CI_VX
CMISPB_CMIS_USER_V
CMISPB_CMIS_USER_VX
CMISPB_FUNC_ACTING_V
CMISPB_FUNC_AM_RELATION_V
CMISPB_FUNC_CCO_V
CMISPB_FUNC_CMIS_USER_V
CMISPB_FUNC_MAIL_GROUP_V
CMISPB_FUNC_USER_ACCESS_V
CMISPB_FUNC_USER_UNAVAIL_V
CMISPB_MAIL_GROUP_V
CMISPB_MAIL_V
CMISPB_PTR_DEF_V
CMISPB_PTR_DEF_VX
CMISPB_PTR_XREF_V
CMISPB_RELEASE_AUDIT_V
CMISPB_RELEASE_TDR_ROUTING_V
CMISPB_RELEASE_TDR_SCR_CI_V
CMISPB_RELEASE_TDR_V
CMISPB_RELEASE_TEST_EVENT_V
CMISPB_RELEASE_TEST_V
CMISPB_REL_TESTS_AND_EVENTS_V
CMISPB_SCR_APP_V
CMISPB_SCR_ATTACHMENTS_V
CMISPB_SCR_NOTES_V
CMISPB_SCR_PTR_XREF_V
CMISPB_SCR_TDR_CI_V
CMISPB_SCR_TDR_ROUTING_V
CMISPB_SCR_TDR_V
CMISPB_SCR_TEST_AND_EVENTS_V
CMISPB_SCR_TEST_EVENTS_V
CMISPB_SCR_TEST_V
CMISPB_SCR_TEXT_V
CMISPB_SCR_V
CMISPB_SCR_VX
CMISPB_SCR_XREF_V
CMISPB_TECH_ACTING_V
CMISPB_TECH_AM_RELATION_V
CMISPB_TECH_CCO_V
CMISPB_TECH_CMIS_USER_V
CMISPB_TECH_MAIL_GROUP_V
CMISPB_TECH_USER_ACCESS_V
CMISPB_TECH_USER_UNAVAIL_V
CMISPB_USER_ACCESS_V
CMISPB_USER_SEC_VX
COL
COLUMN_PRIVILEGES
CTX_CLASSES
CTX_INDEX_SETS
CTX_INDEX_SET_INDEXES
CTX_OBJECTS
CTX_OBJECT_ATTRIBUTES
CTX_OBJECT_ATTRIBUTE_LOV
CTX_PARAMETERS
CTX_PREFERENCES
CTX_PREFERENCE_VALUES
CTX_SECTIONS
CTX_SECTION_GROUPS
CTX_SQES
CTX_STOPLISTS
CTX_STOPWORDS
CTX_SUB_LEXERS
CTX_THESAURI
CTX_THES_PHRASES
CTX_USER_INDEXES
CTX_USER_INDEX_ERRORS
CTX_USER_INDEX_OBJECTS
CTX_USER_INDEX_PARTITIONS
CTX_USER_INDEX_SETS
CTX_USER_INDEX_SET_INDEXES
CTX_USER_INDEX_SUB_LEXERS
CTX_USER_INDEX_SUB_LEXER_VALS
CTX_USER_INDEX_VALUES
CTX_USER_PENDING
CTX_USER_PREFERENCES
CTX_USER_PREFERENCE_VALUES
CTX_USER_SECTIONS
CTX_USER_SECTION_GROUPS
CTX_USER_SQES
CTX_USER_STOPLISTS
CTX_USER_STOPWORDS
CTX_USER_SUB_LEXERS
CTX_USER_THESAURI
CTX_USER_THES_PHRASES
DATABASE_COMPATIBLE_LEVEL
DATABASE_PROPERTIES
DBA_PROCEDURES
DBA_PUBLISHED_COLUMNS
DBA_SDO_INDEX_INFO
DBA_SDO_INDEX_METADATA
DBA_SDO_LRS_METADATA
DBA_SDO_MAPS
DBA_SDO_STYLES
DBA_SDO_THEMES
DBA_SOURCE_TABLES
DEFERRCOUNT
DICTIONARY
DICT_COLUMNS
EXPCOMPRESSEDPART
EXPCOMPRESSEDSUB
EXPCOMPRESSEDTAB
EXPTABSUBPART
EXPTABSUBPARTDATA_VIEW
EXPTABSUBPARTLOBFRAG
EXPTABSUBPARTLOB_VIEW
EXU7ANAL
EXU7BSZ
EXU7CCLO
EXU7CCLU
EXU7CCOU
EXU7CGRU
EXU7CLUU
EXU7COLU
EXU7CONU
EXU7CPO
EXU7CSET
EXU7FUL
EXU7GRNU
EXU7ICOU
EXU7INDU
EXU7JBQU
EXU7LNKU
EXU7ORD
EXU7ORDU
EXU7PSTU
EXU7REFU
EXU7RGCU
EXU7RGSU
EXU7SEQU
EXU7SNAPLU
EXU7SNAPU
EXU7SPSU
EXU7SPU
EXU7STOU
EXU7SYNU
EXU7TABU
EXU7TGRU
EXU7TNE
EXU7USCU
EXU7USRU
EXU7VER
EXU7VEWU
EXU816MAXSQV
EXU816TGRU
EXU81ACTIONOBJ
EXU81ACTIONPKG
EXU81ASSOC
EXU81CSC
EXU81DOIU
EXU81IND
EXU81ITYU
EXU81IXCPU
EXU81IXSPU
EXU81JAV
EXU81JAVT
EXU81LBCPU
EXU81LBPU
EXU81LBSPU
EXU81NOS
EXU81OBJECTPKG
EXU81OPRU
EXU81PLBU
EXU81PROCOBJ
EXU81PROCOBJINSTANCE
EXU81RGCU
EXU81RGSU
EXU81RLS
EXU81SCMU
EXU81SLFCU
EXU81SNAPLU
EXU81SNAPU
EXU81SPOKIU
EXU81SPOKU
EXU81SRTU
EXU81TABSU
EXU81TABU
EXU81TBCPU
EXU81TBSPU
EXU81TGRU
EXU81TYPU
EXU81USCIU
EXU8ANAL
EXU8ASCU
EXU8BSZ
EXU8CCLO
EXU8CCLU
EXU8CCOU
EXU8CGRU
EXU8CLUU
EXU8CMTU
EXU8COEU
EXU8COLU
EXU8CONU
EXU8COOU
EXU8CPO
EXU8CSET
EXU8CSNU
EXU8DIM
EXU8DIMU
EXU8FPTU
EXU8FUL
EXU8GLOB
EXU8GRNU
EXU8HSTU
EXU8ICO
EXU8ICOU
EXU8ICPLSQL
EXU8INDU
EXU8INKU
EXU8IOVU
EXU8IXPU
EXU8JBQU
EXU8LIBU
EXU8LNKU
EXU8LOBU
EXU8NTBU
EXU8NXPU
EXU8OIDU
EXU8OPT
EXU8ORD
EXU8ORDU
EXU8ORFS
EXU8PDSU
EXU8PNTU
EXU8POKIU
EXU8POKU
EXU8PSTU
EXU8REFU
EXU8RFSU
EXU8RGCU
EXU8RGSU
EXU8SCMU
EXU8SEQU
EXU8SLFCU
EXU8SLOGU
EXU8SNAPLU
EXU8SNAPU
EXU8SPSU
EXU8SPU
EXU8SRTU
EXU8STOU
EXU8SYNU
EXU8TABU
EXU8TBPU
EXU8TGRU
EXU8TNE
EXU8TNEB
EXU8TYPBU
EXU8TYPTU
EXU8TYPU
EXU8USCU
EXU8USRU
EXU8VDPTU
EXU8VER
EXU8VEWU
EXU8VINFU
EXU8VNCU
EXU92FPTPU
EXU92FPTU
EXU92TGRU
EXU92TSP
EXU92TSPL
EXU9ACTIONOBJ
EXU9BJF
EXU9BJW
EXU9CCLO
EXU9CCLU
EXU9COEU
EXU9COOU
EXU9DEFPSWITCHES
EXU9DOIU
EXU9DOSO
EXU9EIP
EXU9FGA
EXU9GSAS
EXU9IND
EXU9IND_BASE
EXU9INHCOLCONS
EXU9IXCPU
EXU9LBCPU
EXU9LBPU
EXU9LNKU
EXU9LOBU
EXU9MVL
EXU9MVLCDCCC
EXU9MVLCDCS
EXU9MVLCDCSC
EXU9MVLCDCST
EXU9NLS
EXU9NOS
EXU9OBJSWITCH
EXU9OTNNULL
EXU9PCT
EXU9PDSU
EXU9PGP
EXU9PLBU
EXU9PTS
EXU9RLS
EXU9SNAPLU
EXU9SNAPU
EXU9STOU
EXU9SYNU
EXU9TABSU
EXU9TABU
EXU9TAB_UNUSED_COLS
EXU9TBCPU
EXU9TNE
EXU9TNEB
EXU9TYPTU
EXU9TYPTU2
EXU9TYPU
EXU9UTSU
EXU9XDBUID
EXU9XMLST
EXU9XTB
GEODETIC_SRIDS
GLOBAL_CONTEXT
GLOBAL_NAME
GV_$ACTIVE_INSTANCES
GV_$ACTIVE_SESS_POOL_MTH
GV_$AW_CALC
GV_$AW_OLAP
GV_$AW_SESSION_INFO
GV_$BH
GV_$LOADISTAT
GV_$LOADPSTAT
GV_$LOCK_ACTIVITY
GV_$MAX_ACTIVE_SESS_TARGET_MTH
GV_$MLS_PARAMETERS
GV_$NLS_PARAMETERS
GV_$NLS_VALID_VALUES
GV_$OPTION
GV_$PARALLEL_DEGREE_LIMIT_MTH
GV_$PQ_SESSTAT
GV_$PQ_TQSTAT
GV_$QUEUEING_MTH
GV_$RSRC_CONSUMER_GROUP
GV_$RSRC_CONSUME_GROUP_CPU_MTH
GV_$RSRC_PLAN
GV_$RSRC_PLAN_CPU_MTH
GV_$SESSION_LONGOPS
GV_$TEMPORARY_LOBS
GV_$TIMEZONE_NAMES
GV_$VERSION
IMP7UEC
IMP8CDTU
IMP8REPCAT
IMP8TTDU
IMP8UEC
IMP9COMPAT
IMP9SYN4
IMP9TVOID
IMP9USR
INDEX_HISTOGRAM
INDEX_STATS
JAVASNM
KU$_ASSOC_VIEW
KU$_AUDIT_OBJ_VIEW
KU$_AUDIT_VIEW
KU$_CLUSTER_VIEW
KU$_COMMENT_VIEW
KU$_CONSTRAINT_VIEW
KU$_CONTEXT_VIEW
KU$_DBLINK_VIEW
KU$_DEFROLE_VIEW
KU$_DIMENSION_VIEW
KU$_DIRECTORY_VIEW
KU$_DOMIDX_PLSQL_VIEW
KU$_EXTTAB_VIEW
KU$_FGA_POLICY_VIEW
KU$_FHTABLE_VIEW
KU$_FULL_PKG_VIEW
KU$_FULL_TYPE_VIEW
KU$_FUNC_VIEW
KU$_HTABLE_VIEW
KU$_INDEXTYPE_VIEW
KU$_INDEX_VIEW
KU$_IOTABLE_VIEW
KU$_JAVA_SOURCE_VIEW
KU$_JOB_VIEW
KU$_LIBRARY_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_PFH_VIEW
KU$_M_VIEW_PH_VIEW
KU$_M_VIEW_PIOT_VIEW
KU$_M_VIEW_VIEW
KU$_OBJGRANT_VIEW
KU$_OPERATOR_VIEW
KU$_OUTLINE_VIEW
KU$_PFHTABLE_VIEW
KU$_PHTABLE_VIEW
KU$_PIOTABLE_VIEW
KU$_PKGBDY_VIEW
KU$_PKG_VIEW
KU$_PROC_VIEW
KU$_PROFILE_VIEW
KU$_PROXY_VIEW
KU$_QTRANS_VIEW
KU$_QUEUES_VIEW
KU$_QUEUE_TABLE_VIEW
KU$_REF_CONSTRAINT_VIEW
KU$_RLS_CONTEXT_VIEW
KU$_RLS_GROUP_VIEW
KU$_RLS_POLICY_VIEW
KU$_ROGRANT_VIEW
KU$_ROLE_VIEW
KU$_ROLLBACK_VIEW
KU$_SEQUENCE_VIEW
KU$_SYNONYM_VIEW
KU$_SYSGRANT_VIEW
KU$_TABLESPACE_VIEW
KU$_TAB_TS_VIEW
KU$_TRIGGER_VIEW
KU$_TRLINK_VIEW
KU$_TSQUOTA_VIEW
KU$_TYPE_BODY_VIEW
KU$_TYPE_VIEW
KU$_USER_VIEW
KU$_VIEW_VIEW
KU$_XMLSCHEMA_VIEW
LOADER_COL_INFO
LOADER_CONSTRAINT_INFO
LOADER_DIR_OBJS
LOADER_FILE_TS
LOADER_OID_INFO
LOADER_PARAM_INFO
LOADER_PART_INFO
LOADER_REF_INFO
LOADER_TAB_INFO
LOADER_TRIGGER_INFO
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
PATH_VIEW
PRODUCT_COMPONENT_VERSION
PRODUCT_PRIVS
PUBLICSYN
PUBLIC_DEPENDENCY
QUEUE_PRIVILEGES
RESOURCE_COST
RESOURCE_VIEW
ROLE_ROLE_PRIVS
ROLE_SYS_PRIVS
ROLE_TAB_PRIVS
ROLE_WM_PRIVS
SDO_RELATEMASK_TABLE
SESSION_CONTEXT
SESSION_PRIVS
SESSION_ROLES
SM_$VERSION
SYNONYMS
SYSCATALOG
SYSFILES
SYSSEGOBJ
TAB
TABLE_PRIVILEGES
TABQUOTAS
USER_ALL_TABLES
USER_APPLICATION_ROLES
USER_AQ_AGENT_PRIVS
USER_ARGUMENTS
USER_ASSOCIATIONS
USER_ATTRIBUTE_TRANSFORMATIONS
USER_AUDIT_OBJECT
USER_AUDIT_SESSION
USER_AUDIT_STATEMENT
USER_AUDIT_TRAIL
USER_AWS
USER_AW_PS
USER_BASE_TABLE_MVIEWS
USER_CATALOG
USER_CLUSTERS
USER_CLUSTER_HASH_EXPRESSIONS
USER_CLU_COLUMNS
USER_COLL_TYPES
USER_COL_COMMENTS
USER_COL_PRIVS
USER_COL_PRIVS_MADE
USER_COL_PRIVS_RECD
USER_CONSTRAINTS
USER_CONS_COLUMNS
USER_CONS_OBJ_COLUMNS
USER_DB_LINKS
USER_DEPENDENCIES
USER_DIMENSIONS
USER_DIM_ATTRIBUTES
USER_DIM_CHILD_OF
USER_DIM_HIERARCHIES
USER_DIM_JOIN_KEY
USER_DIM_LEVELS
USER_DIM_LEVEL_KEY
USER_ERRORS
USER_EVALUATION_CONTEXTS
USER_EVALUATION_CONTEXT_TABLES
USER_EVALUATION_CONTEXT_VARS
USER_EXTENTS
USER_EXTERNAL_LOCATIONS
USER_EXTERNAL_TABLES
USER_FREE_SPACE
USER_GEOMETRY_COLUMNS
USER_INDEXES
USER_INDEXTYPES
USER_INDEXTYPE_OPERATORS
USER_IND_COLUMNS
USER_IND_EXPRESSIONS
USER_IND_PARTITIONS
USER_IND_SUBPARTITIONS
USER_INTERNAL_TRIGGERS
USER_JAVA_ARGUMENTS
USER_JAVA_CLASSES
USER_JAVA_DERIVATIONS
USER_JAVA_FIELDS
USER_JAVA_IMPLEMENTS
USER_JAVA_INNERS
USER_JAVA_LAYOUTS
USER_JAVA_METHODS
USER_JAVA_NCOMPS
USER_JAVA_POLICY
USER_JAVA_RESOLVERS
USER_JAVA_THROWS
USER_JOBS
USER_JOIN_IND_COLUMNS
USER_LIBRARIES
USER_LOBS
USER_LOB_PARTITIONS
USER_LOB_SUBPARTITIONS
USER_LOB_TEMPLATES
USER_LOG_GROUPS
USER_LOG_GROUP_COLUMNS
USER_METHOD_PARAMS
USER_METHOD_RESULTS
USER_MVIEWS
USER_MVIEW_AGGREGATES
USER_MVIEW_ANALYSIS
USER_MVIEW_DETAIL_RELATIONS
USER_MVIEW_JOINS
USER_MVIEW_KEYS
USER_MVIEW_LOGS
USER_MVIEW_REFRESH_TIMES
USER_NESTED_TABLES
USER_OBJECTS
USER_OBJECT_SIZE
USER_OBJECT_TABLES
USER_OBJ_AUDIT_OPTS
USER_OBJ_COLATTRS
USER_OPANCILLARY
USER_OPARGUMENTS
USER_OPBINDINGS
USER_OPERATORS
USER_OUTLINES
USER_OUTLINE_HINTS
USER_PARTIAL_DROP_TABS
USER_PART_COL_STATISTICS
USER_PART_HISTOGRAMS
USER_PART_INDEXES
USER_PART_KEY_COLUMNS
USER_PART_LOBS
USER_PART_TABLES
USER_PASSWORD_LIMITS
USER_PENDING_CONV_TABLES
USER_POLICIES
USER_POLICY_CONTEXTS
USER_POLICY_GROUPS
USER_PROCEDURES
USER_PROXIES
USER_PUBLISHED_COLUMNS
USER_QUEUES
USER_QUEUE_PUBLISHERS
USER_QUEUE_SCHEDULES
USER_QUEUE_TABLES
USER_REFRESH
USER_REFRESH_CHILDREN
USER_REFS
USER_REGISTERED_MVIEWS
USER_REGISTERED_SNAPSHOTS
USER_REGISTRY
USER_REPAUDIT_ATTRIBUTE
USER_REPAUDIT_COLUMN
USER_REPCAT
USER_REPCATLOG
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_REPCOLUMN
USER_REPCOLUMN_GROUP
USER_REPCONFLICT
USER_REPDDL
USER_REPFLAVORS
USER_REPFLAVOR_COLUMNS
USER_REPFLAVOR_OBJECTS
USER_REPGENERATED
USER_REPGENOBJECTS
USER_REPGROUP
USER_REPGROUPED_COLUMN
USER_REPGROUP_PRIVILEGES
USER_REPKEY_COLUMNS
USER_REPOBJECT
USER_REPPARAMETER_COLUMN
USER_REPPRIORITY
USER_REPPRIORITY_GROUP
USER_REPPROP
USER_REPRESOLUTION
USER_REPRESOLUTION_METHOD
USER_REPRESOLUTION_STATISTICS
USER_REPRESOL_STATS_CONTROL
USER_REPSCHEMA
USER_REPSITES
USER_RESOURCE_LIMITS
USER_RESUMABLE
USER_ROLE_PRIVS
USER_RSRC_CONSUMER_GROUP_PRIVS
USER_RSRC_MANAGER_SYSTEM_PRIVS
USER_RULES
USER_RULESETS
USER_RULE_SETS
USER_RULE_SET_RULES
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_SEGMENTS
USER_SEQUENCES
USER_SNAPSHOTS
USER_SNAPSHOT_LOGS
USER_SOURCE
USER_SOURCE_TABLES
USER_SOURCE_TAB_COLUMNS
USER_SQLJ_TYPES
USER_SQLJ_TYPE_ATTRS
USER_SQLJ_TYPE_METHODS
USER_STORED_SETTINGS
USER_SUBPARTITION_TEMPLATES
USER_SUBPART_COL_STATISTICS
USER_SUBPART_HISTOGRAMS
USER_SUBPART_KEY_COLUMNS
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_TABLES
USER_TABLESPACES
USER_TAB_COLS
USER_TAB_COLUMNS
USER_TAB_COL_STATISTICS
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_SUBPARTITIONS
USER_TRANSFORMATIONS
USER_TRIGGERS
USER_TRIGGER_COLS
USER_TS_QUOTAS
USER_TYPES
USER_TYPE_ATTRS
USER_TYPE_METHODS
USER_TYPE_VERSIONS
USER_UNUSED_COL_TABS
USER_UPDATABLE_COLUMNS
USER_USERS
USER_USTATS
USER_VARRAYS
USER_VIEWS
USER_WM_LOCKED_TABLES
USER_WM_MODIFIED_TABLES
USER_WM_PRIVS
USER_WM_RIC_INFO
USER_WM_TAB_TRIGGERS
USER_WM_VERSIONED_TABLES
USER_WM_VT_ERRORS
USER_WORKSPACES
USER_WORKSPACE_PRIVS
USER_WORKSPACE_SAVEPOINTS
USER_XML_SCHEMAS
USER_XML_TABLES
USER_XML_TAB_COLS
USER_XML_VIEWS
USER_XML_VIEW_COLS
V$OBJECT_USAGE
V$OLAP_ALTER_SESSION
V_$ACTIVE_INSTANCES
V_$ACTIVE_SESS_POOL_MTH
V_$AW_CALC
V_$AW_OLAP
V_$AW_SESSION_INFO
V_$BH
V_$DATABASE
V_$LOADISTAT
V_$LOADPSTAT
V_$LOCK_ACTIVITY
V_$MAX_ACTIVE_SESS_TARGET_MTH
V_$MLS_PARAMETERS
V_$NLS_PARAMETERS
V_$NLS_VALID_VALUES
V_$OPTION
V_$PARALLEL_DEGREE_LIMIT_MTH
V_$PQ_SESSTAT
V_$PQ_TQSTAT
V_$QUEUEING_MTH
V_$RSRC_CONSUMER_GROUP
V_$RSRC_CONSUMER_GROUP_CPU_MTH
V_$RSRC_PLAN
V_$RSRC_PLAN_CPU_MTH
V_$SESSION_CONNECT_INFO
V_$SESSION_LONGOPS
V_$TEMPORARY_LOBS
V_$TIMEZONE_NAMES
V_$VERSION
WK$$ATTR_MAPPING
WK$$ATTR_USAGE
WK$$AUTHBASIC
WK$$CRAWLER_CONFIG
WK$$CRAWLER_SCHED
WK$$DATA_SOURCE
WK$$DATA_SOURCE_PARAM
WK$$DATA_SOURCE_PARAM_VAL
WK$$DATA_SOURCE_TYPE
WK$$DOC_ATTR
WK$$GROUP_DS_MAPPING
WK$$MAILLIST
WK$$PORTAL
WK$$PORTAL_DS_MAP
WK$$SCHED_MAPPING
WK$$SEARCH_ATTR
WK$$SEARCH_ATTR_TL
WK$$SOURCE_GROUP

jbleuel
04-10-2006, 12:15 PM
> with the bars a little less than half-way up


Could be a problem with a special table or field: Set the log level in the "log view" / "log settings" to "row level". Now start the "explore" and see what happens....



Cheers,
Jens

stu_purvis
04-11-2006, 11:26 AM
Looks like you need a role that allows the id you are using to connect to the database to execute on catalog tables.