Home > SQL Developer Dialog Boxes ... > Shared Wizard Pages
These pages are shared by two or more wizards, such as Database Diff, Database Copy, Database Export, Data Pump Export, and Data Pump Import. The page titles may vary slightly depending on the wizard.
(The page title is Types to Diff, Types to Export, or Object Types.)
Check the types of objects that you want to be included in the operation. You can click Toggle All to check and uncheck all individual types.
You must select at least one object type.
You can limit the types or objects, and the objects within selected types, for the operation. You can specify a Name string filter (including % wildcard characters) and optionally an object type (or All for all object types), and click Lookup to display objects that satisfy the filter.
Name: Shows only objects that satisfy the filter specification. You can use the standard % wildcard character (for example, EM%
to show all objects starting with EM
). You can use quotation marks (double quotes) to specify mixed-case searching.
%: If this option is checked, the % wildcard is automatically added to any Name string that you specify.
More and Less: Click More to enable filtering by Schema and Type; click Less to hide the Schema and Type controls.
Schema: Select the database schema in which to search for objects.
Type: Select All Objects for all object types, or a specific type of object to further filter the display of objects.
Lookup: Click Lookup to display a list of objects that meet the selection criteria for the selected connection. Use the arrow keys to move selected objects or all objects from the available objects box to the selected objects box.
(The page title is Specify Data or Table Data.)
You can limit the data for the operation by selecting objects in the same way as on the Specify Objects page.
You can select the columns included in the operation by clicking the pencil icon in the Columns cell. (Note: For an export operation involving CLOB columns, only the first 32 KB of any CLOB is exported.)
You can limit the rows in the operation by entering a valid WHERE clause for a query on the table, without the WHERE keyword. For example, to restrict the data to rows where a column named RATING contains a value greater than 5, specify rating > 5
and click Go to see the results of the query
(The page title is Summary, Copy Summary, Diff Summary, or Export Summary.)
You can review a hierarchical display of your specifications for the operation.
To go back and make any changes, click Back.
To perform the operation, click Finish.