Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.server -> Re: Analysing an existing Oracle system

Re: Analysing an existing Oracle system

From: Jan Gelbrich <>
Date: Fri, 26 Jul 2002 09:21:38 +0200
Message-ID: <ahqtfj$v5pv0$>

Hi Exodus,

if you have an existing Oracle DB and applications to analyze, you might face a long way to go.
There are Two things to do:

Oracle DB:

    Find out what tables, views, constraints and other schema objects exist in the database.

    You have to analyse the *data model*.    For this purpose, you may use HORA4 from Keeptools, especially its Reverse Engineer function.

   Then You would put this "db structure dump" into a tool like PowerDesigner, to have a map of all tables

   and constraints.
   This is the easyer part of it =)


   I personally do not know of any anaylizing tool for this. E.g. You have Oracle Forms & Reports,

   You would have to go through all the Forms and Reports and analyze what they do. They also can call

   each other. And if You are new to Oracle, I assume that You are new to Oracle Forms as well, and

   I am very sorry to say so: You might not be able to make it. I say this because I am working with Forms for

   5 months now, and I had a Oracle background, but I find myself not-knowing-what-to-do many times.

   I cannot give You any advices for other apps than Forms, so maybe other people should answer to it, too.

This is all I can say about it. But please do not feel discouraged, Your job will be definitely interesting !
You will learn quite a lot on it.

Jan =)

"Exodus" <no.mail_at_sorry.nochance.flip> schrieb im Newsbeitrag news:7K%%8.778$
> Hi group,
> I'm about to take on a new job, and one of the projects is to remove an
> system, which runs on top of an Oracle database. Now I'm going to have to
> move all the processes and data usage to another system, but being a total
> newbie to Oracle, I wondered what tools/techniques existed for analysing
> existing systems?
> Any ideas?
> Cheers
> Ex.
Received on Fri Jul 26 2002 - 02:21:38 CDT

Original text of this message