Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How do you extract SQL from Oracle Forms and Reports files?

578366May 18 2007 — edited May 21 2007

I am developing an "as is" data model for a government client for a 14 year old system that has three databases, 20 schemas, over 1500 tables, and over 23,000 columns. Needless to say, I do not plan to perform a manual mapping of data to screens and reports.

Most of the system has been developed in Oracle Forms and Reports. I am trying to map the live tables and columns to forms and reports.

The process here has been to save the forms and reports files as .fmb and .rdf files. The client does not have an available copy of Oracle Designer, which I understand could be used to extract the SQL.

Is there a utility somewhere that can parse the .fmb and .rdf files to extract the SQL?

Thanks,

Jim Gearing

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 18 2007

Added on May 18 2007

#forms, #moved-from-devops

4 comments

1,537 views