Displaying the Available Objects
Exporting the Database Objects
Deploying a Database Application 7-5
Include BYTE Keyword
: If this option is checked, column length
specifications refer to bytes; if this option is not checked, column length
specifications refer to characters.
Add Force to Views
: If this option is checked, the
FORCE
option is added to
any
CREATE VIEW
statements, causing each view to be created even if it
contains errors.
Constraints as Alters
: If this option is checked, constraints for each table are
defined in separate
ALTER TABLE
statements instead of in the
CREATE
TABLE
statement.
Export Data
: If this option is checked, statements are included to insert the
data for an exported table or view. If this option is not checked, statements are
not included to insert the data for an exported table or view; that is, only the
DDL statements are included.
Include Drop Statements
: If this option is checked,
DROP
statements are
included before the
CREATE
statements, to delete any existing objects with the
same names.
6.
Click the Objects tab.
7.
In the Objects tab:
Select
hr_conn
from the Connection list.
Under Objects, select All, and then select All My Objects to display the
available objects in the
hr_conn
connection.
Ensure that the types of objects (Constraints, Database Links, Functions, and
so on) to be exported are checked. If you want
INSERT
statements created to
insert table data, ensure that Data is checked. If you want certain object types
or the table data not to be exported, uncheck the appropriate options.
