You can copy a database (using the copydb command) to back up the tables, views, and procedures that you own in a database.

Because any user authorized to use a database can use the copy database operation, this is a useful backup method for a non-DBA, who can use it to back up tables, views, and procedures.

By default, all of the tables, views, and procedures that you own in the database are copied. If you specify table names, only those tables are copied.

For a complete explanation of the copy database operation, see the chapter “Loading and Unloading Databases.”