We are converting our database from Oracle9i to Oracle 11g and so we are implementing Oracle 11g streams. I have 2 question:

1. Do I have to drop 9i streams before implementing 11g streams.
2. If we have to then would the following script do its job OR I have to do something else also. Is there some better way also available.

you help will be highly appreciated. Thanks,

BEGIN
DBMS_APPLY_ADM.DELETE_ALL_ERRORS(apply_name => 'strm01_apply');
END;
/
BEGIN
DBMS_APPLY_ADM.DROP_APPLY('MEAS_APPLY');
END;
/
BEGIN
DBMS_CAPTURE_ADM.DROP_CAPTURE('MEAS_CAPTURE');
END;
/
BEGIN
DBMS_PROPAGATION_ADM.DROP_PROPAGATION('MEAS_PROPAG ATE');
END;
/