You can run a report that compares database objects in two schemas, displaying differences between them. You can compare all objects in the schemas or limit your report to specific objects.
To compare two schemas, both must be available to your workspace.
Examples:
Compare DEMO_ objects
by searching for that naming convention. The report indicates if the object exists in each of the two schemas.
Analyze the object details in the two schemas to determine why one implementation is different. For example, the report might show that an index in one schema has an additional column or a column with a different data type.
To compare schemas:
Parent topic: Using Oracle Application Express Utilities