We are using asynch propogation for one of the master group and using queue table def$_aqcall in system tablespace.
As there is more I/O generated on system tablespace, we want to move que table to other tablespace.
If we stop replication ,create another table in other table space unser same schema with same table defination ,drop original and rename the new table to def_aqcall, Will it effect any thing ?
This is very critical so please help.
5. Connect to Sql*Plus as SYSTEM. Drop the following tables in
the order specified below:
drop table SYSTEM.DEF$_CALLDEST;
drop table SYSTEM.DEF$_DEFAULTDEST;
drop table SYSTEM.DEF$_ERROR;
drop table SYSTEM.DEF$_ORIGIN;
drop table SYSTEM.REPCAT$_REPSCHEMA;
drop table SYSTEM.DEF$_DESTINATION ;
I am also faced same problem. But I have solved the problem very easily. by default DEF$_AQCALL will reside in system tablespace. This will grow very fast.
just move the table to another tablespace.
frequently you have truncate the table.
If you are not able to do the above things plz let me know I will forward you the commands.
My id is firstname.lastname@example.org or email@example.com