Table of Contents

Search

  1. Preface
  2. Understanding the Repository
  3. Using the Repository Manager
  4. Folders
  5. Managing Object Permissions
  6. Local and Global Shortcuts
  7. Team-Based Development with Versioned Objects
  8. Labels
  9. Object Queries
  10. Team-Based Development with Deployment Groups
  11. Copying Folders and Deployment Groups
  12. Exporting and Importing Objects
  13. Exchanging Metadata
  14. Copying Objects
  15. Metadata Extensions
  16. Appendix A: MX Views Reference

Repository Guide

Repository Guide

REP_ALL_SOURCES

REP_ALL_SOURCES

This view provides a list of the latest version of sources defined in each folder of a repository. Sources include both relational sources and non-relational sources such as XML files and flat files.
The following table lists source information in the REP_ALL_SOURCES view:
Column Name
Datatype
Description
PARENT_SUBJECT_AREA
VARCHAR2 (240)
Folder name.
PARENT_SUBJECT_ID*
NUMBER
Folder ID.
PARENT_SOURCE_NAME
VARCHAR2 (240)
Name of the parent source.
PARENT_SOURCE_BUSINESS_NAME
VARCHAR2 (240)
Business name of the parent source.
PARENT_SOURCE_ID*
NUMBER
ID of the parent source.
PARENT_SOURCE_DESCRIPTION
VARCHAR2 (2000)
Description of the parent source.
PARENT_SOURCE_VERSION_NUMBER*
NUMBER
Source version number.
PARENT_SOURCE_VERSION_STATUS
NUMBER
Parent source version status.
PARENT_SOURCE_UTC_CHECKIN
NUMBER
UTC time (Coordinated Universal Time) when the parent source was checked in.
PARENT_SOURCE_UTC_LAST_SAVED
NUMBER
UTC time when the parent source was last modified.
PARENT_SOURCE_LAST_SAVED
VARCHAR2 (30)
Time when the parent source was last saved.
PARENT_SOURCE_SCHEMA_NAME
VARCHAR2 (240)
Name of the source schema.
PARENT_SOURCE_FIRST_FIELD_ID*
NUMBER
ID of the first field in the source.
PARENT_SOURCE_SELECT_INFO_ID*
NUMBER
File organization information.
PARENT_SOURCE_DISPLAY_SIZE
NUMBER
Parent source display size (uncompressed binary).
PARENT_SOURCE_PHYSICAL_SIZE
NUMBER
Parent source physical size (compressed binary).
PARENT_SRC_MIN_PHYSICAL_SIZE
NUMBER
Physical size (compressed binary).
PARENT_SOURCE_DATABASE_NAME
VARCHAR2 (240)
Database name of the parent source.
PARENT_SOURCE_TYPE
NUMBER
Specifies whether the source is a relational or a non-relational source.
PARENT_SOURCE_DATABASE_TYPE
VARCHAR2 (50)
Name of the database type of the parent source.
SUBJECT_AREA
VARCHAR2 (240)
Folder name.
SUBJECT_ID*
NUMBER
Folder ID.
SOURCE_NAME
VARCHAR2 (240)
Source name.
SOURCE_ID*
NUMBER
Source ID.
SOURCE_DESCRIPTION
VARCHAR2 (2000)
Source description.
SOURCE_VERSION_NUMBER*
NUMBER
Source version number.
SOURCE_VERSION_STATUS
NUMBER
Specifies whether the source version is active or has been deleted.
SOURCE_UTC_CHECKIN
NUMBER
UTC time for source checkin.
SOURCE_UTC_LAST_SAVED
NUMBER
UTC time when the source display was last saved.
SOURCE_LAST_SAVED
VARCHAR2 (30)
Time when the source was last saved.
SOURCE_DATABASE_NAME
VARCHAR2 (240)
Source database name.
REPOSITORY_NAME
VARCHAR2 (240)
The repository name.
IS_SHORTCUT
NUMBER
Specifies whether the source is a shortcut.
1 = shortcut; 0 = not a shortcut.
IS_GLOBAL_SHORTCUT
NUMBER
Specifies whether the source is a global shortcut.
1 = shortcut; 0 = not a shortcut.
*Indicates that the column is a key column.

0 COMMENTS

We’d like to hear from you!