For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Hi I have 2 database running Synchronous Streaming. However, the stream tablespace was growing due to the error in apply the data and it hit the limit that i have set at 300MB. Now that i have solved the problem, there are records in this table AQ$_DB1_APPLY_QUEUE_TABLE_C which is not cleared. Hence it occupying the tablespace as shown in the pic attached So the tablespace taken is 682.2 MB due to these records in the above table AQ$_DB1_APPLY_QUEUE_TABLE_C. How can i safely remove the records in that table to reduce the space used? This how i delete all the apply errors from the apply queue and there isnt any more errors after i have fixed the problem. So, the only problem is how to reduce that table space used. please advise regards chris