User`s guide

220 Chapter 14: Database Administration

• View Extended Info (Advanced): Enables the user to display extended

information about the schema.

• Recreate all constraints (Advanced): Enables the user to execute a script that

recreates all constraints in the schema. Typically needed after a "support only"

import, or if some constraints for some reason are missing. Missing

constraints are reported in the status window.

• Recreate all sequences and recompile schema (Advanced): Enables the user to

recreate all sequences in the schema and then recompiles the entire schema.

This is usually done by normal imports, but could be needed if something

went wrong during the import, or if “support only" import was used. This will

also fix problems that might appear if for some reason a manual import was

done.

• Recompile schema (Advanced): Enables the user to recompile all packages,

triggers, functions and procedures.

• Reorganize LOB's (Advanced): Enables the user to speed up SQL in older

databases. This option will only be visible with older VCP installations (usually

VCP 4 and some 5.1 versions). For example: The large object (LOB) columns of

Plakat_data

are stored in_row. If you have problems with slow SQL,

reorganizing the columns could improve the SQL performance.