Skip to main content

Sign Out

Sign In

  • Table of Contents
  • Search
  • Print
  • Download
  1. Database
  2. Oracle
  3. Oracle Database
  4. Release 19

Database Heterogeneous Connectivity User's Guide

  • Table of Contents
  • Search
  • Print
  • Download

Table of Contents

Expand AllCollapse All
  • List of Figures
  • List of Tables
  • Title and Copyright Information
  • Preface
    • Audience
    • Documentation Accessibility
    • Related Documents
    • Conventions
  • 1 Introduction to Heterogeneous Connectivity
    • The Information Integration Challenge
    • How Oracle Addresses Synchronous Information Integration
    • Benefits of Oracle's Solution for Synchronous Information Integration
      • Remote Data Can Be Accessed Transparently
      • No Unnecessary Data Duplication
      • SQL Statements Can Query Several Different Databases
      • Oracle's Application Development and End User Tools Can Be Used
      • Users Can Communicate With a Remote Database in its Own Language
  • 2 The Role of the Heterogeneous Services Component
    • Heterogeneous Connectivity Process Architecture
    • Heterogeneous Services Agents
    • Types of Heterogeneous Services Agents
      • Oracle Database Gateways
      • Oracle Database Gateway for ODBC Agent
    • Heterogeneous Services Components
      • Transaction Service
      • SQL Service
    • Heterogeneous Services Configuration Information
      • Data Dictionary Translation Views
      • Heterogeneous Services Initialization Parameters
      • Capabilities
    • Heterogeneous Services Data Dictionary
      • Classes and Instances
      • Data Dictionary Views
    • Process Flow for non-Oracle Database Queries
  • 3 Features of Oracle Database Gateways
    • SQL and PL/SQL Support
    • Heterogeneous Replication
      • Example: Creating Materialized Views for Heterogeneous Replication
      • Example: Setting Up a Refresh Group for Heterogeneous Replication
      • Example: Forcing Refresh of All Three Materialized Views
    • Passthrough SQL
      • DBMS_HS_PASSTHROUGH Package
      • Implications of Using Passthrough SQL
      • Executing Passthrough SQL Statements
        • Executing Nonqueries
          • Overview of Bind Variables
          • IN Bind Variables
          • OUT Bind Variables
          • IN OUT Bind Variables
        • Executing Queries
    • Result Set Support
      • Result Set Support for Non-Oracle Systems
      • Heterogeneous Services Support for Result Sets
        • Results Sets: Cursor Mode
        • Result Sets: Sequential Mode
    • Data Dictionary Translations
    • Date-Time Data Types
    • Two-Phase Commit Protocol
    • Piecewise LONG Data Type
    • SQL*Plus DESCRIBE Command
    • Constraints on SQL in a Distributed Environment
      • Remote and Heterogeneous References
      • Rules and Restrictions When Using SQL for Remote Mapping in a Distributed Environment
    • Oracle's Optimizer and Heterogeneous Services
      • Example: Using Index and Table Statistics
      • Example: Remote Join Optimization
      • Optimizer Restrictions for Non-Oracle Access
      • Explain Plan Consideration
  • 4 Using Heterogeneous Services Agents
    • Initialization Parameters
      • Encrypting Initialization Parameters
        • Using the dg4pwd Utility
      • Gateway Initialization Parameters
    • Optimizing Data Transfers Using Bulk Fetch
      • Using OCI, an Oracle Precompiler, or Another Tool for Array Fetches
      • Controlling the Array Fetch Between Oracle Database and the Agent
      • Controlling the Array Fetch Between the Agent and the Non-Oracle System
      • Controlling the Reblocking of Array Fetches
    • Optimizing Data Loads Using Parallel Load
    • Registering Agents
      • Enabling Agent Self-Registration
        • Using Agent Self-Registration to Avoid Configuration Mismatches
        • Understanding Agent Self-Registration
          • FDS_CLASS and FDS_CLASS_VERSION
          • FDS_INST_NAME
        • Specifying HS_AUTOREGISTER
      • Disabling Agent Self-Registration
    • Oracle Database Server SQL Construct Processing
      • Data Type Checking Support for a Remote-Mapped Statement
    • Executing User-Defined Functions on a Non-Oracle Database
    • Using Synonyms to Provide Data Location and Network Transparency
      • Example: A Distributed Query
    • Copying Data from the Oracle Database Server to the Non-Oracle Database System
    • Copying Data from the Non-Oracle Database System to the Oracle Database Server
    • Heterogeneous Services Data Dictionary Views
      • Types of Views
      • Sources of Data Dictionary Information
      • General Views
      • Transaction Service Views
      • SQL Service Views
        • Views for Capabilities and Translations
        • Views for Data Dictionary Translations
    • Heterogeneous Services Dynamic Performance Views
      • Determining Which Agents Are Running on a Host: V$HS_AGENT View
      • Determining the Open Heterogeneous Services Sessions: V$HS_SESSION View
      • Determining the Heterogeneous Services Parameters: V$HS_PARAMETER View
  • 5 Performance Recommendations
    • Optimizing Heterogeneous Distributed SQL Statements
    • Optimizing Performance of Distributed Queries
  • Index

Search

Print

Download

PDF for offline and print

  • Previous
  • Next
  1. Database Heterogeneous Connectivity User's Guide
  2. Features of Oracle Database Gateways
  3. SQL*Plus DESCRIBE Command

SQL*Plus DESCRIBE Command

You can describe non-Oracle system objects using the SQL*Plus DESCRIBE command.

However, there are some limitations. For example, using heterogeneous links, you cannot describe packages, sequences, synonyms, or types.

Parent topic: Features of Oracle Database Gateways

  • Previous
  • Next
Back to main content
  • About Oracle
  • Contact Us
  • Terms of Use and Privacy
Copyright © 2001, 2019, Oracle and/or its affiliates.
  • Previous
  • Next
Video