From the database home page, you can see various database details that assist you in managing multi-tenancy. The multi-tenancy-related actions you can perform from the home page are dependent upon the type of database connection you define. For a managed database, a scripted database, or an unmanaged database connection, you can:

  • Manage and edit a database connection.
  • Review database connection features; for example, you can see if the database is enabled for multi-tenancy or has support for 64-bit sequences.
  • Manage, edit, and review database security settings for users, and create one or more security administrators.
  • View a security summary, which includes details about various characteristics of the database, such as whether establishing user credentials with a blank user id is allowed; how many database users exist; how many tenants are defined in the database; and additional statistics. Once you review the summary information, you can edit certain database options, modify user or domain properties, or create a tenant.

    Note that if the database whose summary you are viewing is not enabled for multi-tenancy, the summary does not include any of the details that relate specifically to multi-tenancy.

  • Perform data administration by editing sequences and their current values, exporting sequences, or previewing or loading a data definition file.

For an unmanaged database, you can also delete the database connection from the database home page.