SQL> select table_name from all_tables; TABLE_NAME ------------------------------ TAB$ USER$ BOOTSTRAP$ UNDO$ PROXY_ROLE_DATA$ TS$ FILE$ CCOL$ CON$ CDEF$ UET$ TABLE_NAME ------------------------------ IND$ SEG$ COL$ FET$ OBJ$ PROXY_DATA$ ICOL$ CLU$ UGROUP$ TSQ$ SYN$ TABLE_NAME ------------------------------ VIEW$ TYPED_VIEW$ SUPEROBJ$ SEQ$ PROCEDURE$ PROCEDUREINFO$ ARGUMENT$ SOURCE$ IDL_UB1$ IDL_CHAR$ IDL_UB2$ TABLE_NAME ------------------------------ IDL_SB4$ DIR$ ERROR$ SETTINGS$ RESOURCE_PLAN$ RESOURCE_CONSUMER_GROUP$ RESOURCE_PLAN_DIRECTIVE$ TRIGGER$ TRIGGERCOL$ REG$ LOC$ TABLE_NAME ------------------------------ TRIGGERJAVAF$ TRIGGERJAVAS$ TRIGGERJAVAC$ TRIGGERJAVAM$ OBJAUTH$ SYSAUTH$ OBJPRIV$ DEFROLE$ PROFILE$ PROFNAME$ DEPENDENCY$ TABLE_NAME ------------------------------ ACCESS$ AUD$ LINK$ TRUSTED_LIST$ PROPS$ COM$ RESOURCE_COST$ INCEXP INCVID INCFIL _default_auditing_options_ TABLE_NAME ------------------------------ AUDIT$ PENDING_TRANS$ PENDING_SESSIONS$ PENDING_SUB_SESSIONS$ LOB$ SUMPARTLOG$ SUMDELTA$ SNAP_LOGDEP$ SNAP_LOADERTIME$ MLOG$ SLOG$ TABLE_NAME ------------------------------ VIEWCON$ SNAP$ SNAP_REFTIME$ MLOG_REFCOL$ SNAP_REFOP$ SNAP_COLMAP$ SNAP_OBJCOL$ REG_SNAP$ SNAP_SITE$ JOB$ RGROUP$ TABLE_NAME ------------------------------ RGCHILD$ DUC$ HISTGRM$ HIST_HEAD$ DUAL PARTOBJ$ PARTCOL$ TABPART$ INDPART$ SUBPARTCOL$ TABSUBPART$ TABLE_NAME ------------------------------ INDSUBPART$ TABCOMPART$ INDCOMPART$ PARTLOB$ LOBFRAG$ LOBCOMPPART$ DEFSUBPART$ DEFSUBPARTLOB$ SYSTEM_PRIVILEGE_MAP TABLE_PRIVILEGE_MAP STMT_AUDIT_OPTION_MAP TABLE_NAME ------------------------------ RESOURCE_MAP USER_ASTATUS_MAP EXPACT$ NOEXP$ COLTYPE$ SUBCOLTYPE$ ATTRCOL$ VIEWTRCOL$ ID_GENS$ OID$ TYPE_MISC$ TABLE_NAME ------------------------------ TYPE$ TYPEHIERARCHY$ COLLECTION$ ATTRIBUTE$ METHOD$ PARAMETER$ PROCEDUREJAVA$ PROCEDUREC$ RESULT$ KOPM$ NTAB$ TABLE_NAME ------------------------------ VTABLE$ ATEMPTAB$ LIBRARY$ USER_HISTORY$ MIGRATE$ REFCON$ OPQTYPE$ ICOLDEP$ OPERATOR$ OPBINDING$ OPANCILLARY$ TABLE_NAME ------------------------------ OPARG$ INDTYPES$ INDOP$ SECOBJ$ ASSOCIATION$ USTATS$ JAVASNM$ SUM$ SUMDETAIL$ SUMINLINE$ SUMKEY$ TABLE_NAME ------------------------------ SUMAGG$ SUMJOIN$ SUMDEP$ SUMPRED$ DIM$ DIMLEVEL$ DIMLEVELKEY$ DIMJOINKEY$ DIMATTR$ HIER$ HIERLEVEL$ TABLE_NAME ------------------------------ RLS$ RLS_GRP$ RLS_CTX$ CONTEXT$ RULESET$ INDPART_PARAM$ OL$ OL$HINTS OL$NODES EXPPKGOBJ$ EXPPKGACT$ TABLE_NAME ------------------------------ EXPDEPOBJ$ EXPDEPACT$ MON_MODS$ METAVIEW$ METAFILTER$ METAXSL$ METAXSLPARAM$ METASTYLESHEET EXTERNAL_TAB$ EXTERNAL_LOCATION$ SQL_VERSION$ TABLE_NAME ------------------------------ COL_USAGE$ CDC_SYSTEM$ CDC_CHANGE_SOURCES$ CDC_CHANGE_SETS$ CDC_CHANGE_TABLES$ CDC_SUBSCRIBERS$ CDC_SUBSCRIBED_TABLES$ CDC_SUBSCRIBED_COLUMNS$ CDC_CHANGE_COLUMNS$ JIJOIN$ JIREFRESHSQL$ TABLE_NAME ------------------------------ LOG$ APPROLE$ FGA$ FGA_LOG$ OBJECT_USAGE AUX_STATS$ SMON_SCN_TIME AW$ PS$ MAP_FILE$ MAP_FILE_EXTENT$ TABLE_NAME ------------------------------ MAP_SUBELEMENT$ MAP_ELEMENT$ MAP_EXTELEMENT$ MAP_COMPLIST$ MAP_OBJECT STREAMS$_CAPTURE_PROCESS STREAMS$_APPLY_PROCESS STREAMS$_PROPAGATION_PROCESS STREAMS$_PROCESS_PARAMS STREAMS$_PREPARE_OBJECT STREAMS$_PREPARE_DDL TABLE_NAME ------------------------------ STREAMS$_APPLY_MILESTONE STREAMS$_APPLY_PROGRESS STREAMS$_KEY_COLUMNS STREAMS$_DEF_PROC STREAMS$_RULES APPLY$_SOURCE_OBJ APPLY$_SOURCE_SCHEMA APPLY$_DEST_OBJ APPLY$_DEST_OBJ_CMAP APPLY$_DEST_OBJ_OPS APPLY$_ERROR TABLE_NAME ------------------------------ APPLY$_ERROR_HANDLER APPLY$_CONF_HDLR_COLUMNS REGISTRY$ AUDIT_ACTIONS MVIEW$_ADV_WORKLOAD MVIEW$_ADV_BASETABLE MVIEW$_ADV_SQLDEPEND MVIEW$_ADV_PRETTY MVIEW$_ADV_TEMP MVIEW$_ADV_FILTER MVIEW$_ADV_LOG TABLE_NAME ------------------------------ MVIEW$_ADV_FILTERINSTANCE MVIEW$_ADV_LEVEL MVIEW$_ADV_ROLLUP MVIEW$_ADV_AJG MVIEW$_ADV_FJG MVIEW$_ADV_GC MVIEW$_ADV_CLIQUE MVIEW$_ADV_ELIGIBLE MVIEW$_ADV_OUTPUT MVIEW$_ADV_EXCEPTIONS MVIEW$_ADV_PARAMETERS TABLE_NAME ------------------------------ MVIEW$_ADV_INFO MVIEW$_ADV_JOURNAL MVIEW$_ADV_PLAN LOGSTDBY$PARAMETERS LOGSTDBY$EVENTS LOGSTDBY$APPLY_PROGRESS LOGSTDBY$APPLY_MILESTONE LOGSTDBY$SCN LOGSTDBY$PLSQL LOGSTDBY$SKIP_TRANSACTION LOGSTDBY$SKIP TABLE_NAME ------------------------------ LOGSTDBY$SKIP_SUPPORT LOGMNR_SESSION$ LOGMNR_LOG$ PSTUBTBL ODCI_SECOBJ$ ODCI_WARNINGS$ DBMS_LOCK_ALLOCATED DBMS_ALERT_INFO TRANSFORMATIONS$ ATTRIBUTE_TRANSFORMATIONS$ RULE_SET$ TABLE_NAME ------------------------------ RULE$ RULE_MAP$ RULE_EC$ REC_TAB$ REC_VAR$ AQ$_QUEUE_TABLES AQ$_QUEUES AQ$_REPLAY_INFO AQ$_QUEUE_TABLE_AFFINITIES AQ$_SCHEDULES AQ$_SCHEDULES TABLE_NAME ------------------------------ AQ$_MESSAGE_TYPES AQ$_PROPAGATION_STATUS AQ$_PENDING_MESSAGES AQ$_QUEUE_STATISTICS AQ$_PUBLISHER AQ$_INTERNET_AGENTS AQ$_INTERNET_AGENT_PRIVS AQ_EVENT_TABLE AQ_SRVNTFN_TABLE DEF$_AQCALL DEF$_AQERROR TABLE_NAME ------------------------------ DEF$_ERROR DEF$_DESTINATION DEF$_CALLDEST DEF$_DEFAULTDEST DEF$_LOB DEF$_TEMP$LOB DEF$_PROPAGATOR DEF$_ORIGIN DEF$_PUSHED_TRANSACTIONS LOGMNR_HEADER1$ LOGMNR_HEADER2$ TABLE_NAME ------------------------------ LOGMNRG_SEED$ LOGMNRG_DICTIONARY$ LOGMNRG_OBJ$ LOGMNRG_TAB$ LOGMNRG_COL$ LOGMNRG_ATTRCOL$ LOGMNRG_TS$ LOGMNRG_IND$ LOGMNRG_USER$ LOGMNRG_TABPART$ LOGMNRG_TABSUBPART$ TABLE_NAME ------------------------------ LOGMNRG_TABCOMPART$ LOGMNRG_TYPE$ LOGMNRG_COLTYPE$ LOGMNRG_ATTRIBUTE$ LOGMNRG_LOB$ LOGMNRG_CDEF$ LOGMNRG_CCOL$ LOGMNRG_ICOL$ LOGMNRG_LOBFRAG$ LOGMNRG_INDPART$ LOGMNRG_INDSUBPART$ TABLE_NAME ------------------------------ LOGMNRG_INDCOMPART$ LOGMNR_UID$ LOGMNR_BUILDLOG LOGMNRC_DBNAME_UID_MAP LOGMNR_DICTSTATE$ LOGMNR_DICTIONARY$ LOGMNR_OBJ$ LOGMNR_USER$ LOGMNRC_GTLO LOGMNRC_GTCS LOGMNRC_GSII TABLE_NAME ------------------------------ LOGMNR_TAB$ LOGMNR_COL$ LOGMNR_ATTRCOL$ LOGMNR_TS$ LOGMNR_IND$ LOGMNR_TABPART$ LOGMNR_TABSUBPART$ LOGMNR_TABCOMPART$ LOGMNR_TYPE$ LOGMNR_COLTYPE$ LOGMNR_ATTRIBUTE$ TABLE_NAME ------------------------------ LOGMNR_LOB$ LOGMNR_CDEF$ LOGMNR_CCOL$ LOGMNR_ICOL$ LOGMNR_LOBFRAG$ LOGMNR_INDPART$ LOGMNR_INDSUBPART$ LOGMNR_INDCOMPART$ LOGMNRT_SEED$ LOGMNRT_DICTIONARY$ LOGMNRT_OBJ$ TABLE_NAME ------------------------------ LOGMNRT_TAB$ LOGMNRT_COL$ LOGMNRT_ATTRCOL$ LOGMNRT_TS$ LOGMNRT_IND$ LOGMNRT_USER$ LOGMNRT_TABPART$ LOGMNRT_TABSUBPART$ LOGMNRT_TABCOMPART$ LOGMNRT_TYPE$ LOGMNRT_COLTYPE$ TABLE_NAME ------------------------------ LOGMNRT_ATTRIBUTE$ LOGMNRT_LOB$ LOGMNRT_CDEF$ LOGMNRT_CCOL$ LOGMNRT_ICOL$ LOGMNRT_LOBFRAG$ LOGMNRT_INDPART$ LOGMNRT_INDSUBPART$ LOGMNRT_INDCOMPART$ LOGMNR_PROCESSED_LOG$ LOGMNR_SPILL$ TABLE_NAME ------------------------------ LOGMNR_AGE_SPILL$ LOGMNR_RESTART_CKPT$ LOGMNR_RESTART_CKPT_TXINFO$ LOGMNR_INTERESTING_COLS PRVT_EPGCTAB_PORTS PRVT_EPGCTAB_ADMIN PRVT_EPGCTAB_GLOBALS PRVT_EPGCTAB_DAD PRVT_EPGCTAB_DAD_ATTRS REPCAT$_REPCAT REPCAT$_FLAVORS TABLE_NAME ------------------------------ REPCAT$_REPSCHEMA REPCAT$_SNAPGROUP REPCAT$_REPOBJECT REPCAT$_REPCOLUMN REPCAT$_KEY_COLUMNS REPCAT$_GENERATED REPCAT$_REPPROP REPCAT$_REPCATLOG REPCAT$_DDL REPCAT$_REPGROUP_PRIVS REPCAT$_PRIORITY_GROUP TABLE_NAME ------------------------------ REPCAT$_PRIORITY REPCAT$_COLUMN_GROUP REPCAT$_GROUPED_COLUMN REPCAT$_CONFLICT REPCAT$_RESOLUTION_METHOD REPCAT$_RESOLUTION REPCAT$_RESOLUTION_STATISTICS REPCAT$_RESOL_STATS_CONTROL REPCAT$_PARAMETER_COLUMN REPCAT$_AUDIT_ATTRIBUTE REPCAT$_AUDIT_COLUMN TABLE_NAME ------------------------------ REPCAT$_FLAVOR_OBJECTS REPCAT$_TEMPLATE_STATUS REPCAT$_TEMPLATE_TYPES REPCAT$_REFRESH_TEMPLATES REPCAT$_USER_AUTHORIZATIONS REPCAT$_OBJECT_TYPES REPCAT$_TEMPLATE_REFGROUPS REPCAT$_TEMPLATE_OBJECTS REPCAT$_TEMPLATE_PARMS REPCAT$_OBJECT_PARMS REPCAT$_USER_PARM_VALUES TABLE_NAME ------------------------------ REPCAT$_TEMPLATE_SITES REPCAT$_SITE_OBJECTS REPCAT$_RUNTIME_PARMS REPCAT$_TEMPLATE_TARGETS REPCAT$_EXCEPTIONS REPCAT$_INSTANTIATION_DDL REPCAT$_EXTENSION REPCAT$_SITES_NEW HS$_FDS_CLASS HS$_FDS_INST HS$_BASE_CAPS TABLE_NAME ------------------------------ HS$_CLASS_CAPS HS$_INST_CAPS HS$_BASE_DD HS$_CLASS_DD HS$_INST_DD HS$_CLASS_INIT HS$_INST_INIT HS$_FDS_CLASS_DATE SQLPLUS_PRODUCT_PROFILE SQLPLUS_PRODUCT_PROFILE ACCESS_TABLE TABLE_NAME ------------------------------ ACCOUNT_ADDITIONAL_INFO_T ACCOUNT_BALANCES_T ACCOUNT_NAMEINFO_T ACCOUNT_PRODUCTS_T ACCOUNT_T AFF_BOOTSTRAP_T BILL_AGED_RECEIVABLES_T BILL_BALANCES_T BILL_SUBORDS_T BILL_T DATA_T TABLE_NAME ------------------------------ EVENT_ACTIVITY_VSLOG_VS_LOG_T EVENT_BAL_IMPACTS_T EVENT_BILLING_ACCOUNTING_T EVENT_BILLING_CHARGE_T EVENT_BILLING_LIMIT_T EVENT_BILLING_PRODUCT_T EVENT_CUSTOMER_BILLINFO_T EVENT_CUSTOMER_NAMEINFO_T EVENT_CUSTOMER_STATUSES_T EVENT_RATES_USED_T EVENT_T TABLE_NAME ------------------------------ EVENT_TOTAL_T ISP_ENROLLMENT_INFO_T LDAP_SERVICE_CERTIFICATE_T OPERATOR_TEAM_INFO PRODUCT_PERMITTEDS_T PRODUCT_T QAUTHTICATE_AUTOASSIGN_T QVERIFY_AUTOASSIGN_T QWEBVERIFY_AUTOASSIGN_T RATE_BAL_IMPACTS_T RATE_T TABLE_NAME ------------------------------ SEARCH_T SERVICE_ADDITIONAL_INFO_T SERVICE_CERTIFICATE_T SERVICE_DNBQ_T SERVICE_INTERNICQ_T SERVICE_PRODUCTS_T SERVICE_REQUEST_T SERVICE_T VS_ACCOUNT_COMMENT_T VS_ACCOUNT_LRA_FEATURE_T VS_ACCOUNT_LRA_TOKEN_INFO_T TABLE_NAME ------------------------------ VS_ACCOUNT_RESELL_FEATURE_T VS_ACCOUNT_SURVEY_ANSWER_T VS_ACCOUNT_SURVEY_QUESTION_T VS_ACCT_APPL_PARA_T VS_ADMIN_PRIVILEGE_T VS_AFFILIATE_INFO_T VS_ATTRIBUTE_BUF VS_BUNDLE_INFO_T VS_CARD_BILL_T VS_CERT_REQUEST_BUF VS_CERT_SIGNED_BUF TABLE_NAME ------------------------------ VS_CONFIG_ACTIONTYPES_T VS_CONFIG_OBJECTTYPES_T VS_CONFIG_REVOKEREASON_T VS_CRL_BUF VS_CRL_T VS_CROSS_JURISDICTION_T VS_DN_T VS_EXCHANGE_T VS_EXTENSION_T VS_FAX_URL_T VS_GROUP_JURISDICTION_T TABLE_NAME ------------------------------ VS_GROUP_T VS_ISSUER_SIGNED_BUF VS_ISSUER_T VS_LDAP_CERT_SIGNED_BUF VS_LDAP_CRL_BUF VS_LDAP_CRL_T VS_LDAP_ISSUER_T VS_LDAP_LOG_T VS_LICENSE_EVENT_T VS_MESSAGE_T VS_NOTARIZATION_ID_T TABLE_NAME ------------------------------ VS_OCSP_LOG_T VS_ONSITE_CA_IDENTIFIER_T VS_ONSITE_DOMAIN_T VS_ONSITE_END_USER_CONFIG_T VS_ONSITE_HISTORY_T VS_ONSITE_OCSP_SIGNER_T VS_PCA_T VS_PIN_EVENT_T VS_PIN_MATCH_VALUE_T VS_PIN_ORDER_T VS_PIN_PRE_APPROVED_LIST_T TABLE_NAME ------------------------------ VS_PIN_REDEEMED_INFO_T VS_PIN_REDEMPTION_ERR_INFO_T VS_PRODUCT_GROUP_PRICE_T VS_REFERENCE_INFO_T VS_SERVICE_BUNDLE_T VS_SERVICE_CONFIG_ADDITIONAL_T VS_SERVICE_CONFIG_T VS_SERVICE_ORDER_T VS_SLWTLS_CERT_T VS_T VS_TIMESTAMP_LOG_T TABLE_NAME ------------------------------ VS_TOKEN_PURCHASE_T VS_USC_EXTENSION_TEMPLATE_T VS_USC_POLICY_TEMPLATE_T VS_USC_TOKEN_INFO_TEMPLATE_T VS_VERIFY_T VS_WTLSCERT_BUF_T VS_XAUTH_PAYMENT_T DEVICE_BATCH_NAMES_T VS_ACCT_APPLICATION_T VS_ACCT_APPL_PARA_LIST VS_CERT_LICENSE_T TABLE_NAME ------------------------------ VS_DCS_PENDING_Q_T VS_OCSP_KEYMAP_T VS_ONSITE_OCSP_SERVICE_T VS_ONSITE_OCSP_T VS_TIMESTAMP_ACCT_T VS_USC_APPL_PARA_TEMPLATE_T VS_USC_APPL_TEMPLATE_T VS_USC_DN_TEMPLATE_T VS_USC_ENROLL_CONFIG_T ZIP_CODES_T VS_SECURITY_BXALIST TABLE_NAME ------------------------------ VS_SECURITY_FREEEMAIL VS_FRAUD_CHECK TPMS_USER_T TPMS_ACCT_ATTR_NAME_LIST_T TPMS_ATTR_VALUE_T VS_AUTH_CONTAINER_DATA_T VS_AUTH_CONTAINER_INFO_T VS_AUTH_DATA_MAP_T VS_AUTH_ELEMENT_INFO_T VS_AUTH_DATA_PROVIDER_INFO_T VS_AUTH_CONTAINER_USE_PACKET_T TABLE_NAME ------------------------------ VS_PTS_LOG_T VS_AUTH_REQUEST_LOG_T VS_AUTH_RESPONSE_LOG_T VS_ENROLL_TRACK_T TPMS_XML_QUEUE_T VS_CERT_PUBLIC_KEY EMS_AUDIT_VALUE_T EMS_AUDIT_MASTER_T EMS_AUDIT_ATTRIBUTE_T ACCOUNT_SERVICE_RENEWAL_T VS_AAS_BILLING_INFO_T TABLE_NAME ------------------------------ VS_TIMESTAMP_RETRACT_T VS_TIMESTAMP_CODE_T VS_SUBACCOUNT_INFO_T VS_WORKFLOW_REQUEST_T VS_WORKFLOW_STEP_T VS_PROF_BASIC_T VS_CUSTOMER_PROVIDER_INFO_T VS_CAS_USER_DATA_T VS_CAS_TRANS_FLOW_INFO_T VS_CAS_ID_MAP_T VS_CAS_XSLT_DATA_INFO_T TABLE_NAME ------------------------------ VS_LANG_SUPPORT_TABLE VS_SERVICE_SUBJECT_ALT_NAME_T VS_ACS_DEV_ID_T VS_ACS_SERVICE_T VS_ACS_REQUEST_CFG_T VS_ACS_AUTH_T VS_ACS_AUTH_BLOB_T VS_ACS_AUTH_PURCHASE_T VS_ACS_SERVICE_CFG_T VS_VERIFY_REQUEST_STATE_T VS_VERIFY_LOG_T TABLE_NAME ------------------------------ VS_VERIFY_STATUS_INFO_T VS_VERIFY_SERVICE_CONFIG_T VS_VERIFY_COUNTRY_GROUP_T VS_VERIFY_TRANX_T VS_VERIFY_REQUEST_T VS_VERIFY_COUNTRY_CODES_T SERVICE_CROSSCERTIFICATEPAIR_T VS_DANUBE_COMPSTORE_T VS_DANUBE_LOCATOR_T VS_AFF_SUBSCRIBER_AGRMT_T TPMS_RELATIONSHIP_T TABLE_NAME ------------------------------ COUNTRYCODE STATS$DATABASE_INSTANCE STATS$LEVEL_DESCRIPTION STATS$SNAPSHOT STATS$DB_CACHE_ADVICE STATS$FILESTATXS STATS$TEMPSTATXS STATS$LATCH STATS$LATCH_CHILDREN STATS$LATCH_PARENT STATS$LATCH_MISSES_SUMMARY TABLE_NAME ------------------------------ STATS$LIBRARYCACHE STATS$BUFFER_POOL_STATISTICS STATS$ROLLSTAT STATS$ROWCACHE_SUMMARY STATS$SGA STATS$SGASTAT STATS$SYSSTAT STATS$SESSTAT STATS$SYSTEM_EVENT STATS$SESSION_EVENT STATS$BG_EVENT_SUMMARY TABLE_NAME ------------------------------ STATS$WAITSTAT STATS$ENQUEUE_STAT STATS$SQL_SUMMARY STATS$SQLTEXT STATS$SQL_STATISTICS STATS$RESOURCE_LIMIT STATS$DLM_MISC STATS$UNDOSTAT STATS$SQL_PLAN_USAGE STATS$SQL_PLAN STATS$SEG_STAT TABLE_NAME ------------------------------ STATS$SEG_STAT_OBJ STATS$PGASTAT STATS$IDLE_EVENT STATS$PARAMETER STATS$INSTANCE_RECOVERY STATS$STATSPACK_PARAMETER STATS$SHARED_POOL_ADVICE STATS$SQL_WORKAREA_HISTOGRAM STATS$PGA_TARGET_ADVICE 669 rows selected. SQL> desc service_certificate_t; Name Null? Type ----------------------------------------- -------- ---------------------------- OBJ_ID1 NUMBER OBJ_ID0 NOT NULL NUMBER VS_CERT_FLAGS NUMBER VS_CERT_SERIAL VARCHAR2(255) VS_CERT_CLASS NUMBER VS_REQUEST_TYPE NUMBER VS_SUBJECT_READABLE VARCHAR2(2000) VS_SUBJECT_DIGEST VARCHAR2(255) VS_ISSUER_READABLE VARCHAR2(2000) VS_ISSUER_DIGEST VARCHAR2(255) VS_VALID_START NUMBER VS_VALID_END NUMBER VS_CERT_REQUEST_SIZE NUMBER VS_CERT_SIGNED_SIZE NUMBER VS_COMMON_NAME VARCHAR2(749) VS_ORGANIZATION VARCHAR2(195) VS_ORG_UNIT VARCHAR2(195) VS_ISSUE_USERNAME VARCHAR2(240) VS_ISSUE_DATE NUMBER VS_REVOKE_USERNAME VARCHAR2(240) VS_REVOKE_DATE NUMBER VS_REVOKE_REASON_ID NUMBER VS_VERSION VARCHAR2(2) VS_EMAIL VARCHAR2(240) VS_UNLISTED VARCHAR2(20) VS_STATUS VARCHAR2(1) VS_AUTO_RENEWAL VARCHAR2(1) VS_NONVERIFIED_SUB_A VARCHAR2(255) VS_NONVERIFIED_SUB_B VARCHAR2(255) VS_CHARACTER_SET VARCHAR2(16) VS_CHARACTER_ENCODING VARCHAR2(16) VS_ATTRIBUTE_SIZE NUMBER VS_UNSTRUCTURED_ADDR VARCHAR2(749) VS_CHALLENGE_PASSWORD VARCHAR2(32) VS_PRODUCT_NAME VARCHAR2(80) VS_FEATURE_FLAGS NUMBER VS_ISSUER_SIGNATURE VARCHAR2(255) VS_CHALLENGE_QUESTION VARCHAR2(749) VS_CURRENT_USER VARCHAR2(30) VS_TRANSACTION_ID VARCHAR2(60) VS_ORIGINAL_SERIAL VARCHAR2(255) VS_APPLICATION NUMBER VS_FIELD1 VARCHAR2(749) VS_FIELD2 VARCHAR2(749) VS_FIELD3 VARCHAR2(749) VS_FIELD4 VARCHAR2(749) VS_FIELD5 VARCHAR2(749) VS_FIELD6 VARCHAR2(749) VS_FIELD7 VARCHAR2(749) VS_FIELD8 VARCHAR2(749) VS_FIELD9 VARCHAR2(749) VS_FIELD10 VARCHAR2(749) VS_PUBLIC_KEY VARCHAR2(2000) VS_PUBLIC_KEY_FORMAT VARCHAR2(255) VS_JURISDICTION_HASH VARCHAR2(255) VS_EMPLOYEE_ID VARCHAR2(255) VS_EMPLOYEE_TITLE VARCHAR2(749) VS_MAIL_STOP VARCHAR2(255) VS_ENROLL_STATUS VARCHAR2(255) VS_APPROVAL_TIME NUMBER(38) VS_KR_REFNUM NUMBER(38) VS_KEY_USAGE VARCHAR2(255) VS_SUSPENDED_DATE NUMBER(38) VS_EMAIL_MIXEDCASE VARCHAR2(240) LAST_UPDATE_DATE DATE SQL> desc service_additional_info_t; Name Null? Type ----------------------------------------- -------- ---------------------------- OBJ_ID1 NUMBER OBJ_ID0 NOT NULL NUMBER REC_ID NUMBER VS_FINAL_PRICE NUMBER VS_DISCOUNT_AMT1 NUMBER VS_DISCOUNT_AMT2 NUMBER VS_DISCOUNT_REASON_CODE1 VARCHAR2(255) VS_DISCOUNT_REASON_CODE2 VARCHAR2(255) VS_ASSIGNED_TO VARCHAR2(255) VS_LAST_TOUCHED_DATE NUMBER VS_PRODUCT_CFG_FILE VARCHAR2(255) VS_CERT_TYPE VARCHAR2(30) VS_AUTH_JURISDICTION_HASH VARCHAR2(255) VS_COUNTRY VARCHAR2(2) VS_STATE VARCHAR2(255) VS_LOCALITY VARCHAR2(255) ASSIGNED_TO_TEAM VARCHAR2(255) VS_IS_JURISDICTION_REQUEST NOT NULL VARCHAR2(1) VS_DEFAULT_GROUP_ID VARCHAR2(30) VS_CORP_PHONE VARCHAR2(25) VS_CORP_PHONE_RESOURCE VARCHAR2(255) VS_PRIVACY_OPTION VARCHAR2(255) VS_KR_SESSION_KEY VARCHAR2(64) VS_ORIGINAL_JURISDICTION_HASH VARCHAR2(255) VS_ISP_ACCT_OBJ_ID0 NUMBER(38) VS_FIELD11 VARCHAR2(749) VS_FIELD12 VARCHAR2(749) VS_FIELD13 VARCHAR2(749) VS_FIELD14 VARCHAR2(749) VS_FIELD15 VARCHAR2(749) VS_FIELD16 VARCHAR2(749) VS_FIELD17 VARCHAR2(749) SQL> desc vs_crl_t; Name Null? Type ----------------------------------------- -------- ---------------------------- POID_DB NUMBER POID_ID1 NUMBER POID_ID0 NOT NULL NUMBER POID_TYPE VARCHAR2(255) POID_REV NUMBER NAME VARCHAR2(255) OWNER_DB NUMBER OWNER_ID1 NUMBER OWNER_ID0 NUMBER OWNER_TYPE VARCHAR2(255) CREATED_T NUMBER MOD_T NUMBER AOBJ_DB NUMBER AOBJ_ID1 NUMBER AOBJ_ID0 NUMBER AOBJ_TYPE VARCHAR2(255) VS_ISSUER_READABLE VARCHAR2(2000) VS_ISSUER_DIGEST VARCHAR2(255) VS_LAST_UPDATE NUMBER VS_NEXT_UPDATE NUMBER VS_CRL_SIZE NUMBER VS_REVOKE_USERNAME VARCHAR2(240) VS_REVOKE_REASON_ID NUMBER SQL> spool off