Objects that Are Copied

6. Loading and Unloading Databases : Copy Operation : Objects that Are Copied

Share this page

The database objects copied in the copy database operation depend on whether tables are specified for the operation.

The following table shows what is copied in each situation:

Options Specified	What Is Copied
No options specified.	All tables, views, and procedures (owned by the user who performed the copy database operation) and associated indexes, integrities, events, permissions, and rules.
Table/views specified.	Specified tables or views (owned by the user who performed the copy database operation) and associated indexes, integrities, and permissions.

For further flexibility in the statements written to the copy.in script, you can use additional flags so that the generated scripts contain statements to manipulate only certain database objects. The flags can be used with the specified tables or views to print statements for any particular table or view.

For example, use the –with_index flag to print statements only related to index.

For more information on these flags, see the copydb command description in the Command Reference Guide.