We are migrating the database from sybase 12.5 to oracle 11gr2. And we are facing the below problem :
'RS_MARKER procedure is a system procedure in sybase , its use to execute the collection of database transaction log',
Also I have mentioned the code below:
SELECT 1 INTO v_temp
WHERE NOT EXISTS ( SELECT sysstat
WHERE NAME = 'rs_marker'
AND TYPE = 'P'
AND UTL_RAW.BIT_AND(sysstat,v_rep_constant) != 0 );
Above mentioned code is after migrating to oracle 11gr2. So help please me to resolve this issue, also tell me is there any similar procedure in oracle database 11gr2 to collect the transaction log of the database. (like rs_marker in sybase).
So please tell how to migrate those system procedure to oracle database 11gr2 also Don't hesitate please answer my question.
(Please Note after migrating to oracle above code its not compiled its given the error table or view does not exists I mean sysobjects view its does not exist .)
If I understand correctly, all the RS_*** procedures are associated with the replication server in Sybase. Oracle doesn't have such packages/procedures to begin with. You should evaluate options for data replication in Oracle and then take necessary steps for configuring those features. It may be that you don't need any procedures for data replication.