S_SRM_REQUEST table update (Doc ID 737338.1)

Goal

In the document "Restoring Production Environments into Test Environments (Doc ID 477772.1)", there is a table which lists the processes that need to be prevented from executing in a copy of a Production environment. We were wondering if we would get the same results substituting the DELETE statement for this command below: update SIEBEL.S_SRM_REQUEST set STATUS = 'CANCELED' And what are we missing if we only run this update statement

Another question: we use RCRs in our environment and we would like to keep them "Active" after the database refresh.

But if we delete all of those mentioned tables the RCRs will be "deleted" as well, right? How could we manage that?

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.