learning a new Oracle database 2

[tekkerguy]

I've been asked to learn a new oracle database that is already in use at our company. Problem is, I've been given no relational data, scemas, etc...

What's the best way to go about learning the database?

 

[johnherman]

Can you reverse engineer it into Erwin or some modeling tool? That would be my first try.

If not, draw your own diagram of each table and foreign key relationship on paper.

Also, you could use a profiling tool to look at the domain of each column. That would help you to understand what data is in each column.

What exactly do you mean by "learn" a new database? Will you be supporting it from a DBA, Application Developer, BA, etc. role?

-------------------------
The trouble with doing something right the first time is that nobody appreciates how difficult it was - Steven Wright

 

[tekkerguy]

I'll be working on applications that access the database, which I already do in SQL. I'm familiar with Oracle, but this database is extremely large. Shouldn't be too difficult, I just wanted to know of any quick ways to display the relationships, without being given a chart.

Thanks for the tips, I'll give them a go.

 

[LKBrwnDBA]

You can use DDL Wizard (free) to reverse engineer the database.

Also, you may want to download SQL Developer (free) from Oracle.



----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[tekkerguy]

Great, thanks alot guys, I'll give these progs a try!