Thursday, September 18, 2008

PUBLICSYN

PUBLICSYN contains information on public synonyms.

Column

Datatype

NULL

Description

SNAME

VARCHAR2(30)

Name of the synonym

CREATOR

VARCHAR2(30)

Owner of the synonym

TNAME

VARCHAR2(30)

Table of which this is a synonym

DATABASE

VARCHAR2(128)

Database in which the table resides

TABTYPE

VARCHAR2(9)

Type of table

Oracle data dictionary views

Oracle dynamic performance views

No comments:

Post a Comment