Modifying Queue Tables

You can use Enterprise Manager to modify some of the storage options of an existing queue table. Changing the storage options for a queue table can improve the performance of the queues that use the queue table.

To modify a queue table: 

1. In Oracle Enterprise Manager, log in to the database as the Oracle Streams administrator.

2. Go to the Database Home page.

3. Click Data Movement to open the Data Movement subpage.

4. Click Manage Advanced Queues.

5. In the Related Links section, click Queue Tables to open the Queue Tables page.

6. Select the queue table that you want to modify.

7. Click Edit.

   The Edit Queue Table page appears, showing the General subpage.

8. Click Storage to open the Storage subpage or LOB Storage to open the LOB Storage subpage.

9. Modify one or more queue table properties.

10. Click Apply to save your changes.