16 System Catalog Tables

Table of Contents Previous Next


16 System Catalog Tables

16.1.1 dual
dual is a single-row, single-column table that is provided for compatibility with Oracle databases only.
16.1.2 edb_dir
The edb_dir table contains one row for each alias that points to a directory created with the create directory command. A directory is an alias for a pathname that allows a user limited access to the host file system.
You can use a directory to fence a user into a specific directory tree within the file system. For example, the UTL_FILE package offers functions that permit a user to read and write files and directories in the host file system, but only allows access to paths that the database administrator has granted access to via a create directory command.
The edb_partdef table contains one row for each
The edb_partition table contains one row for each partition or subpartition.
The edb_password_history table contains one row for each password change. The table is shared across all databases within a cluster.
16.1.6 edb_policy
The edb_policy table contains one row for each policy.
The edb_profile table stores information about the available profiles. edb_profiles is shared across all databases within a cluster.
The password lock time associated with the profile (in seconds). -1 indicates that the value from the default profile should be used. -2 indicates that the account should be locked permanently.
The password life time associated with the profile (in seconds). -1 indicates that the value from the default profile should be used. -2 indicates that the password never expires.
The password grace time associated with the profile (in seconds). -1 indicates that the value from the default profile should be used. -2 indicates that the password never expires.
The number of password changes that have to occur before a password can be reused. -1 indicates that the value from the default profile should be used. -2 indicates that the old passwords can never be reused.
The edb_variable table contains one row for each package level variable (each variable declared within a package).
16.1.9 pg_synonym
The pg_synonym table contains one row for each synonym created with the CREATE SYNONYM command or CREATE PUBLIC SYNONYM command.
Replaces synowner. Contains the OID of the pg_namespace row where the synonym is stored
The product_component_version table contains information about feature compatibility; an application can query this table at installation or run time to verify that features used by the application are available with this deployment.

16 System Catalog Tables

Table of Contents Previous Next