Extending the Oracle database

This procedure describes how to extend the table space names of a data file in the Oracle database.

To extend the Oracle database

1. From the Components Tree pane, under the Control-M/EM component, right-click Database: <schema name@database host:database port> and select Extend Database.
2. Log in to the Control-M/EM database as an administrator with your username and password.

   The Control-M/EM Extend Database window appears.

3. From the Table Space Name drop-down list, select the table space name that you want to extend:
4. In the Extension Size field, type the extension size in MB.
5. Select one of the following options:
   • Extend existing file
   • Add new file
6. In the Data file name field, select the data file that you want to extend or type the name of the new data file that you want to extend.
7. Click OK.

   The database file size is extended.