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.