purging active data from change table
I want to purge a change table for those data for which the subscriber has not been able to call PURGE_WINDOW. Now is it possible ? tehn how?
I know that a change table can be forcefully dropped while active subscribers still exist
by using the force option of DBMS_CDC_PUBLISH.DROP_CHANGE_TABLE
Now Can I purge forcefully those data for which subscriber do not call purge_window ?
otherwsie the size of the change table gets growing since not calling of purge_window.
Using which script can I install JVM and how to check whether that is installed or not?
To install JVM,
run initjvm.sql script in $ORACLE_HOME/javavm/install directory.
you have many other scripts in the same directory connected with java.
To check whether its installed properly
WHERE object_type Like '%JAVA%';
this query will return more than 4000 rows,
To remove JVM run rmjvm.sql
Thanx for the reply
And what about the Purging ?
Dont know about the purging problem.
"If initjvm.sql executed properly, the total count of Java schema
objects should be greater than 8,000,"
Sorry i said 4000
Click Here to Expand Forum to Full Width