2.09 - Show或Describe - Teradata QueryGrid

Teradata® QueryGrid™ 安装和用户指南

prodname
Teradata QueryGrid
vrm_release
2.09
created_date
2019 年 5 月
category
安装
用户指南
管理
配置
featnum
B035-5991-059K-CHS

Help Foreign Server

以下示例在 Teradata 系统上使用不同的 HELP 命令,以显示或描述 Oracle 目标连接器支持的模式发现请求查询。
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 ?