The dbschema utility
The dbschema utility displays the SQL statements (the schema) that are necessary to replicate database objects.
You can also use the dbschema utility for the following
purposes:
- To display the distributions that the UPDATE STATISTICS statement creates.
- To display the schema for the Information Schema views
- To display the schema for creating objects such as databases, tables, sequences, synonyms, storage spaces, chunks, logs, roles, and privileges
- To display the distribution information that is stored for one or more tables in the database
- To display information about user-defined data types and row types
After you obtain the schema of a database, you can redirect the dbschema output to a file that you can use with DB-Access.
The dbschema utility is supported on all updatable secondary servers.
The dbschema utility is also supported on read-only secondary servers. However, the dbschema utility displays a warning message when running on these servers.
Attention: Use of the dbschema utility
can increment sequence objects in the database, creating gaps in the
generated numbers that might not be expected in applications that
require serialized integers.