Database Reference
In-Depth Information
Table Dictionary and Attribute Dictionary. UI Defaults are discussed in more detail
later.
About Database
and
Database Monitor
are special utilities that require the user run-
ning them to have access to a database login that has been granted the DBA role. The
Database Monitor utilities allow the privileged user to view Sessions, Systems Statist-
ics, Top SQL, and Long Operations reports. The About Database report shows detailed
information about the database instance and the APEX environment. Depending on the
settings the Instance Administrator has chosen, these two utilities may not appear in the
list, because they can be turned off.
The
Schema Comparison
utility allows you to compare the objects in two separate
schemas and create a difference report. You may choose to compare only certain attrib-
utes or all attributes of the objects in the selected schemas. The limitation here is that
both schemas must be assigned to the workspace in order for the comparison to take
place.
The
Object Reports
are actually a set of utilities that let you get detailed information
about the different types of objects that live in the “parse as” schema(s) assigned to the
workspace. Although most of the reports have to do with tables, others deal with PL/
SQL objects, invalid objects, grants and permissions, and so on. This is a good place to
find details of the objects in your working schema.
When an object is dropped, Oracle doesn't immediately remove the space associated
with the table, but instead renames the table and places it and its associated storage in
the
Recycle Bin
. The Recycle Bin utility allows you to view and potentially recover ob-
jects that have been dropped from the schemas associated with a workspace. You may
also purge the Recycle Bin, allowing the space to be reclaimed by the Oracle database
for use somewhere else.
Administration and Team Development
The last two functional areas of the UI, Administration and Team Development, are
complex enough to truly deserve their own chapters. Therefore, we refer you to the
chapters that cover these areas in depth.
Chapter 10
covers deploying applications,
Chapter 14
is about managing workspaces, and
Chapter 15
goes over Team Develop-
ment.
You dip into administrative tasks throughout this topic, so if you want to have a full
understanding of administration before you start, you should take a detour and read
these chapters now to get a good foundation. However, if you're prepared to learn on
the fly, go to the next chapter, where you start the real programming.
