Help Foreign Server
The following examples use different HELP commands on the Teradata system to show or describe queries for schema discovery requests that are supported by the Oracle target connector.
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 or 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 ?