DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: purging active data from change table

  1. #1
    Join Date
    Oct 2001
    Location
    Calcutta , India
    Posts
    78

    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

  2. #2
    Join Date
    Jan 2003
    Location
    Hull, UK
    Posts
    220
    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

  3. #3
    Join Date
    Oct 2001
    Location
    Calcutta , India
    Posts
    78
    Thanx for the reply

    And what about the Purging ?

    Regards

    Deba

  4. #4
    Join Date
    Jan 2003
    Location
    Hull, UK
    Posts
    220
    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
  •  


Click Here to Expand Forum to Full Width