Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Please ask technical questions in the appropriate category. Thank you!

Automating Oracle Forms and Reports RCU

Mubashar TariqJun 15 2023

Our Oracle Forms and Reports Developers use a four step process to create required schema in the database. We use one database and each developer's schema are prefixed with their initials. This process can be simpler if DBA share SYS password but that is not possible. I am trying to see if this whole process can be scripted and hand the script to DBA to run. Following are current 4 steps

1- Developer runs C:\Oracle\Middleware\FR\oracle_common\bin\rcu.bat –silent –responseFile c:\Temp\rcuSystemLoadResponseFile.properties . This generate script_systemLoad.sql and script_postDataLoad.sql

2- DBA runs script_systemLoad.sql

3- Developer runs C:\Oracle\Middleware\FR\oracle_common\bin\rcu.bat –silent –responseFile c:\Temp\rcuDataLoadResponseFile.properties

4- DBA runs script_postDataLoad.sql

Question: How I can simplify this whole thing and make it one step process.

Comments
Post Details
Added on Jun 15 2023
1 comment
95 views