PL/SQL Developer - Export User Objects


After selecting the objects you wish to export, and selecting an output file, you can press the Export button to export the objects.

The output file is a SQL script that is compatible with Oracle's SQL*Plus, and with PL/SQL Developer's Command Window. The Include Privileges/Storage options can be enabled if you want to include the grants of the object privileges to other users and roles or the storage information such as tablespaces and initial extents.

You can control whether a single SQL script is created that contains the DDL for all objects, or if each object should be exported to a specific file (with the object name as filename, and .sql as extension). In that case the output file will contain a series of calls to these object specific files.