O'Reilly logo

Advanced Oracle PL/SQL Developer's Guide - Second Edition by Saurabh K. Gupta

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

The DBMS_METADATA package

The DBMS_METADATA package was introduced in Oracle 9i. The API enables the extraction of object metadata from database dictionaries that can be optionally manipulated and re-executed on a database server. The package is owned by SYS whose public synonym is used by all users. A user with SELECT_CATALOG_ROLE can directly access the DBMS_METADATA package.

Note

DBMS_METADATA is a key enabler of metadata export functionality in Data Pump

The package pulls the object's metadata in XML form from the database dictionary and provides transform handlers to build it in the desired form. The formatted XML can then be re-executed in the database.

DBMS_METADATA data types and subprograms

As we said earlier, the DBMS_METADATA package uses ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required