Table of Contents

Search

  1. Version 6.4.3
  2. Version 6.4 HotFix 2
  3. Version 6.4 HotFix 1
  4. Version 6.4
  5. Version 6.3
  6. Version 6.2 Hot Fix 2
  7. Version 6.2 Hot Fix 1
  8. Version 6.2
  9. Version 6.1.1
  10. Version 6.1

Release Guide

Release Guide

Metadata

Metadata

You can use the SELECT statement to access virtual tables that contain metadata information. These virtual tables reside in a virtual schema named ADMIN_SCHEMA. The ADMIN_SCHEMA schema resides in the metadata database in the Data Vault.
Use the following syntax to access a virtual table:
SELECT * from ADMIN_SCHEMA.<table name>
Example:
SELECT * from ADMIN_SCHEMA.TABLES
You can access the following virtual tables:
  • ADMIN_SCHEMA.TABLES
  • ADMIN_SCHEMA.PARTITIONS
  • ADMIN_SCHEMA.COLUMNS
  • ADMIN_SCHEMA.DOMAINS
  • ADMIN_SCHEMA.PART_LIMITS
  • ADMIN_SCHEMA.TAB_LIMITS
  • ADMIN_SCHEMA.HOSTS
  • ADMIN_SCHEMA.AGENTS
  • ADMIN_SCHEMA.TASKS
  • ADMIN_SCHEMA.CLIENTS
  • ADMIN_SCHEMA.SESSIONS
  • ADMIN_SCHEMA.USERS
  • ADMIN_SCHEMA.DATABASES
  • ADMIN_SCHEMA.ADMINS
  • ADMIN_SCHEMA.VERSIONS
For more information, see the
Informatica Data Archive 6.2 HotFix 2 Data Vault Administrator Guide
.

0 COMMENTS

We’d like to hear from you!