Skip Headers

Oracle9i Database Reference
Release 2 (9.2)

Part Number A96536-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page Go to next page
View PDF

DBA_PUBLISHED_COLUMNS

DBA_PUBLISHED_COLUMNS describes all existing source column tables. You must have the SELECT_CATALOG_ROLE privilege to access this view.

Column Datatype Description

CHANGE_SET_NAME

VARCHAR2(30)

Name of the change set

CHANGE_TABLE_SCHEMA

VARCHAR2(30)

Associated change table owner

CHANGE_TABLE_NAME

VARCHAR2(31)

Associated change table name

PUB_ID

NUMBER

Publication identifier (change table object number)

SOURCE_SCHEMA_NAME

VARCHAR2(30)

Table owner in the source system

SOURCE_TABLE_NAME

VARCHAR2(31)

Table name in the source system

COLUMN_NAME

VARCHAR2(30)

Column name

DATA_TYPE

VARCHAR2(30)

Column datatype

DATA_LENGTH

NUMBER

Column length in bytes

DATA_PRECISION

NUMBER

Decimal precision for NUMBER datatype; binary precision for FLOAT datatype; NULL for all other datatypes

DATA_SCALE

NUMBER

Digits to the right of a decimal point in a number

NULLABLE

CHAR(1)

Nulls allowed (Y |N)?