-
purging active data from change table
Hi,
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?
Regards
Deba
-
Hi,
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
SELECT Count(1)
FROM dba_objects
WHERE object_type Like '%JAVA%';
this query will return more than 4000 rows,
To remove JVM run rmjvm.sql
HTH
Srini
-
Thanx for the reply
And what about the Purging ?
Regards
Deba
-
Hi,
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
HTH
Srini
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|