You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for Teradata


1 to 20 of 184 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Database Gateway for Teradata User's Guide, 11g Release 1 (11.1)

Database Gateway for Teradata User's Guide - Contents

ContentsDatabase Gateways 2 Teradata Gateway Features and Restrictions 2.1 Using the Pass-Through Feature … 2.2 Database Compatibility Issues for Teradata 2.2.1 Schema Considerations 2.2.2 Naming Rules 2.2.2.1 … Links 2.3.9 Stored Procedures 2.4 Known Problems 2.4.1 Encrypted Format Login 2.4.2 Teradata LONG … Teradata

Database Gateway Installation and Configuration Guide for Microsoft Windows, 11g Release 1 (11.1)

Configuring Oracle Database Gateway for Teradata

Multiple Teradata Databases Example: Accessing Teradata Datacreated, you can verify the connection to the new Teradata databases, as in the following: SQL

Database Gateway Installation and Configuration Guide for AIX 5L Based Systems (64-Bit), HP-UX PA-RISC (64-Bit), HP-UX Itanium, Solaris Operating System (SPARC 64-Bit), Linux x86, and Linux x86-64, 11g Release 1 (11.1)

Configuring Oracle Database Gateway for Teradata

7.7.5 Multiple Teradata Databases Example: Accessing Teradata Datacreated you can verify the connection to the new Teradata databases, as in the following: SQL

Database Gateway for Teradata User's Guide, 11g Release 1 (11.1)

Supported SQL Syntax and Functions

B.2.1 Functions Not Supported by TeradataOracle SQL functions with no equivalent function in Teradata are not supported in DELETE, INSERT

Database Gateway for Teradata User's Guide, 11g Release 1 (11.1)

Data Dictionary

C.1.3 Direct Queries to Teradata TablesQueries issued directly to individual Teradata system catalog tables are allowed but they return … different results because the Teradata system catalog table column names differ from those of the data … dictionary view. Also, certain columns in an Teradata system catalog table cannot be used in data dictionary processing.

Database Gateway Installation and Configuration Guide for Microsoft Windows, 11g Release 1 (11.1)

Configuring Oracle Database Gateway for Teradata

Multiple Teradata Databases Example: Configuring the GatewayChoose One System ID for Each Teradata Database A separate instance of the gateway is needed for … each Teradata database. Each instance needs its own gateway System ID (SID). For this example, the … gateway SIDs are chosen for the instances that access the Teradata databases: dg4tera2 for the gateway … : HS_FDS_CONNECT_INFO=204.179.79.15:1025/db3

Database Gateway Installation and Configuration Guide for Microsoft Windows, 11g Release 1 (11.1)

Installing Oracle Database Gateway for Teradata

6 Installing Oracle Database Gateway for Teradataprocedure for Oracle Database Gateway for Teradata. To install the gateway, follow these steps … Requirements for Oracle Database Gateway for Teradata\" section. Run the Oracle Universal Installer See … which they appear depend on your platform. See Table 6-2 for a description of the installation procedure of Oracle Database Gateway for Teradata.

Database Gateway for Teradata User's Guide, 11g Release 1 (11.1)

Supported SQL Syntax and Functions

B.2.2 Functions Supported by Teradataequivalent Teradata functions: Arithmetic Operators Comparison Operators Group Functions String Functions … Other Functions B.2.2.1 Arithmetic Operators Oracle Teradata + + - - * * / / B.2.2.2 Comparison … Operators Oracle Teradata = = > > = >=, !=, ^= <>, != IS NOT NULL IS NOT NULL IS NULL IS NULL B.2.2.3 Group … Functions Oracle

Database Gateway Installation and Configuration Guide for Microsoft Windows, 11g Release 1 (11.1)

Configuring Oracle Database Gateway for Teradata

7 Configuring Oracle Database Gateway for TeradataTeradata: Configure the Gateway Initialization Parameter File Configure Oracle Net for the Gateway … Encrypt Gateway Initialization Parameter Values Configure the Gateway to Access Multiple Teradata Databases

Database Gateway for Teradata User's Guide, 11g Release 1 (11.1)

Data Dictionary

C.1.1 Teradata System Catalog TablesTeradata data dictionary information is stored in the Teradata database as Teradata system catalog … tables. The Teradata system catalog tables define the structure of a database. When you change data … definitions, Teradata reads and modifies the Teradata system catalog tables to add

Database Gateway Installation and Configuration Guide for AIX 5L Based Systems (64-Bit), HP-UX PA-RISC (64-Bit), HP-UX Itanium, Solaris Operating System (SPARC 64-Bit), Linux x86, and Linux x86-64, 11g Release 1 (11.1)

Configuring Oracle Database Gateway for Teradata

7 Configuring Oracle Database Gateway for TeradataTeradata: Configure the Gateway Initialization Parameter File Configure Oracle Net for the Gateway … Encrypt Gateway Initialization Parameter Values Configure the Gateway to Access Multiple Teradata Databases

Database Gateway for Teradata User's Guide, 11g Release 1 (11.1)

Teradata Gateway Features and Restrictions

2.2 Database Compatibility Issues for TeradataTeradata and Oracle databases function differently in some areas, causing compatibility problems

Database Gateway Installation and Configuration Guide for Microsoft Windows, 11g Release 1 (11.1)

Initialization Parameters

Oracle Database Gateway for Teradata Initialization ParametersGateway for Teradata. They are as follows: HS_DB_DOMAIN HS_DB_INTERNAL_NAME HS_DB_NAME

Database Gateway for Teradata User's Guide, 11g Release 1 (11.1)

Teradata Gateway Features and Restrictions

2.4.2 Teradata LONG VARCHAR Data Typecannot be used in a SQL statement that accesses a column defined as Teradata data type LONG VARCHAR … . You cannot use SQL*Plus to select data from a column defined as Teradata data type LONG VARCHAR when … Interface to access such data in a Teradata database. LONG VARCHAR data types must be NULLABLE for INSERT

Database Gateway Installation and Configuration Guide for AIX 5L Based Systems (64-Bit), HP-UX PA-RISC (64-Bit), HP-UX Itanium, Solaris Operating System (SPARC 64-Bit), Linux x86, and Linux x86-64, 11g Release 1 (11.1)

Installing Oracle Database Gateway for Teradata

6 Installing Oracle Database Gateway for Teradataprocedure for Oracle Database Gateway for Teradata. To install the gateway, follow these steps … Requirements for Oracle Database Gateway for Teradata\". Run the Oracle Universal Installer. See \"Step … appear depend on your platform. See Table 6-3 for a description of the installation procedure of Oracle Database Gateway for Teradata

Database Gateway for Teradata User's Guide, 11g Release 1 (11.1)

Teradata Gateway Features and Restrictions

2 Teradata Gateway Features and RestrictionsAfter the gateway is installed and configured, you can use the gateway to access Teradata data … , pass Teradata commands from applications to the Teradata database, perform distributed queries, and … Compatibility Issues for Teradata Known Restrictions Known Problems

Database Gateway for Teradata User's Guide, 11g Release 1 (11.1)

Case Studies

3.8 Case 3: Joining Teradata TablesCase 3 demonstrates the following: Joins between Teradata tables. Subselects. The query retrieves … information from three Teradata tables and relates the employees to their department name and salary

Database Gateway for Teradata User's Guide, 11g Release 1 (11.1)

Teradata Gateway Features and Restrictions

2.3.2 Transaction CapabilityCOMMIT_CONFIRM and it is always the commit point site when the Teradata database is updated by the transaction.

Database Gateway for Teradata User's Guide, 11g Release 1 (11.1)

Teradata Gateway Features and Restrictions

2.3.9 Stored ProceduresThe gateway does not support the procedure feature that allows the execution of stored procedures in a non-Oracle database.

Database Gateway for Teradata User's Guide, 11g Release 1 (11.1)

Teradata Gateway Features and Restrictions

2.4.3 Schema Names and PL/SQLIf you do not prefix a Teradata database object with its schema name in a SQL statement within a PL