Documentation | EnterpriseDB

Postgres Plus Cloud Database
Scales out PostgreSQL and Postgres Plus Advanced Server databases, providing highly available DBaaS in public and private cloud environments.

Postgres Plus Advanced Server
Provides all the compatibility features and tools favored by Oracle users, enabling customers to run their Oracle applications virtually unchanged.

Postgres Plus Solution Pack
Provides high value tools along with PostgreSQL to make DBAs, developers and system administrators work easier for improving performance, enterprise monitoring, software maintenance, heterogeneous data integration / migrations, availability and security.

PostgreSQL
Is one of the largest and most mature open source project today, having produced an outstanding database recognized for its transaction processing capabilities and performance across a wide array of query intensive and mixed load applications.

Postgres Enterprise Manager
Gives DBAs the visual tools to remotely monitor, manage and tune large-scale PostgreSQL and Postgres Plus database servers.

Postgres Plus xDB Replication Server
Offers Multi-Master configuration for continuous master data synchronization with multiple conflict resolutions strategies.

Oracle Migration Assessment
Create a clear strategy to reducing your Oracle costs and decrease implementation risks with an in-depth analysis of your Oracle database, its architecture and configuration.

Packaged Services
Take advantage of our well-defined, affordably priced services to establish an architecture that is maintainable, high performing, highly available, and safeguards your data.

Professional Consulting
Unique service and support needs are met through our Professional Consulting group, that delivers high-impact services covering every aspect of your database.

Technical Support
World-class support by highly-experienced engineers provides dependable and timely resolution to all of our customers' technical inquiries.

Remote DBA Services
Apply qualified manpower immediately where you need it the most, for either short or long-term engagements, in a highly cost efficient manner.

DBA Schedule
Checkout our extensive training curriculum specifically designed for DBAs, from introductory to advanced levels. Courses are available online, on-demand and in classroom.

Developer Schedule
Training sessions geared towards application developers are regularly scheduled through out the year.

On-Demand Training
Our most popular PostgreSQL administration training courses are available on-demand, giving you the opportunity to train anytime within one year of your registration. New courses

Learning Credits
Take advantage of volume discounts while planning your organization's training needs with credits valid for a full year after purchase.

PostgreSQL Certification
Associate
Professional

Postgres Plus Advanced Server Oracle Compatibility Developer's Guide

10.25 DBA_OBJECTS

The DBA_OBJECTS view provides information about all objects in the database.

Name	Type	Description
owner	VARCHAR2	User name of the object’s owner.
schema_name	VARCHAR2	Name of the schema in which the object belongs.
object_name	VARCHAR2	Name of the object.
object_type	VARCHAR2	Type of the object – possible values are: INDEX, FUNCTION, PACKAGE, PACKAGE BODY, PROCEDURE, SEQUENCE, SYNONYM, TABLE, TRIGGER, and VIEW.
status	VARCHAR2	Included for compatibility only; always set to VALID.
temporary	TEXT	Y if the table is temporary; N if the table is permanent.

Search our site

10.25 DBA_OBJECTS