次の例では、Teradataシステムで異なるHELPコマンドを使用して、Oracleターゲット コネクタでサポートされるスキーマ検出要求のクエリーを表示または説明します。
Help Foreign Server
help foreign server oraclefs_active; *** Query completed. 37 rows found. 5 columns returned. *** Total elapsed time was 4 seconds. USERNAME PRAMA_USR USER_ID 597 CREATED 2018-04-05 07:54:50.000000 COMMON NO ORACLE_MAINTAINED N
Help Foreign DatabaseまたはSchema
help foreign schema SIMBATERADATA@oraclefs_active;
*** Query completed. 31 rows found. 65 columns returned.
*** Total elapsed time was 2 seconds.
OWNER SIMBATERADATA
TABLE_NAME ORACLETYPET
TABLESPACE_NAME USERS
CLUSTER_NAME ?
IOT_NAME ?
STATUS VALID
PCT_FREE 10
PCT_USED ?
INI_TRANS 1
MAX_TRANS 255
INITIAL_EXTENT 65536
NEXT_EXTENT 1048576
MIN_EXTENTS 1
MAX_EXTENTS 2147483645
PCT_INCREASE ?
FREELISTS ?
FREELIST_GROUPS ?
LOGGING YES
BACKED_UP N
NUM_ROWS 1
BLOCKS 5
EMPTY_BLOCKS 0
AVG_SPACE 0
CHAIN_CNT 0
AVG_ROW_LEN 89
AVG_SPACE_FREELIST_BLOCKS 0
NUM_FREELIST_BLOCKS 0
DEGREE 1
INSTANCES 1
CACHE N
TABLE_LOCK ENABLED
SAMPLE_SIZE 1
LAST_ANALYZED 2018-02-01 03:00:22.000000
PARTITIONED NO
IOT_TYPE ?
TEMPORARY N
SECONDARY N
NESTED NO
BUFFER_POOL DEFAULT
FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT
ROW_MOVEMENT DISABLED
GLOBAL_STATS YES
USER_STATS NO
DURATION ?
SKIP_CORRUPT DISABLED
MONITORING YES
CLUSTER_OWNER ?
DEPENDENCIES DISABLED
COMPRESSION DISABLED
COMPRESS_FOR ?
DROPPED NO
READ_ONLY NO
SEGMENT_CREATED YES
RESULT_CACHE DEFAULT
CLUSTERING NO
ACTIVITY_TRACKING ?
DML_TIMESTAMP ?
HAS_IDENTITY NO
CONTAINER_DATA NO
INMEMORY DISABLED
INMEMORY_PRIORITY ?
INMEMORY_DISTRIBUTE ?
INMEMORY_COMPRESSION ?
INMEMORY_DUPLICATE ?
Help Foreign Table
help foreign table SIMBATERADATA.t1@oraclefs_active;
*** Query completed. One row found. 36 columns returned.
*** Total elapsed time was 1 second.
OWNER SIMBATERADATA
TABLE_NAME t1
COLUMN_NAME A
DATA_TYPE DATE
DATA_TYPE_MOD ?
DATA_TYPE_OWNER ?
DATA_LENGTH 7
DATA_PRECISION ?
DATA_SCALE ?
NULLABLE Y
COLUMN_ID 1
DEFAULT_LENGTH ?
DATA_DEFAULT ?
NUM_DISTINCT ?
LOW_VALUE ?
HIGH_VALUE ?
DENSITY ?
NUM_NULLS ?
NUM_BUCKETS ?
LAST_ANALYZED ?
SAMPLE_SIZE ?
CHARACTER_SET_NAME ?
CHAR_COL_DECL_LENGTH ?
GLOBAL_STATS NO
USER_STATS NO
AVG_COL_LEN ?
CHAR_LENGTH 0
CHAR_USED ?
V80_FMT_IMAGE NO
DATA_UPGRADED YES
HISTOGRAM NONE
DEFAULT_ON_NULL NO
IDENTITY_COLUMN NO
EVALUATION_EDITION ?
UNUSABLE_BEFORE ?
UNUSABLE_BEGINNING ?