Viewing the local or system database directory files

Use the LIST DATABASE DIRECTORY command to view the information associated with the databases that you have on your system.

Before you begin

Before viewing either the local or system database directory files, you must have previously created an instance and a database.

Procedure

  • To see the contents of the local database directory file, issue the following command:
       LIST DATABASE DIRECTORY ON location
    where location specifies the location of the database.
  • To see the contents of the system database directory file, issue the LIST DATABASE DIRECTORY command without specifying the location of the database directory file.