Viewing Datafiles

Previous

Next

---

Datafiles are the operating system files that hold the data within the database. The data is written to these files in an Oracle proprietary format that cannot be read by programs other than an Oracle database.

You can view a list of datafile in your database on the Data Files page. To access the Data Files page, you must have a database account that has been granted a DBA role.

To access the Data Files page:

1. On the Database Home Page, click the Administration icon and then Storage.

2. If prompted, enter the appropriate administrator username and password and click Login.

   The Storage page appears. See "Monitoring the Space Available".

3. On the Tasks list, click View Data Files.

   The Data Files page appears and displays the following:

   • Tablespace (name)

   • File Name

   • Size (MB)

   • Maximum Size (MB)

   • Auto Extensible

     Auto Extensible indicates the type of extent management (that is, autoextensible or not).

4. Use the controls at the top of the page to control the page display:

   • To search for a data file, enter a file name in the Search Data File Name field and click Go.

   • To view a specific tablespace, select a tablespace from the Storage list and click Go.

   • To control the number or rows that display, make a selection from the Display list and click Go.