To Modify a journal batch that is frozen, follow this procedure: a). Setup > Journal > Sources b). Query the Journal Source c). Uncheck the Freeze Journals box and save the changes before [...]
1.For Loading jar use cmd loadjava -force -genmissing -r -user username/password@servicename -verbose jar 2.For droping jar use cmd dropjava -f -verbose -u [...]
Query: SELECT owner, table_name, chain_cnt FROM dba_tables WHERE chain_cnt > 0; SELECT owner_name,table_name,count(head_rowid) row_countFROM chained_rows GROUP BY owner_name,table_name