How do I see the schema of my Oracle database (one is on Solaris & other on NT).

Shiva.

01-15-2001, 02:15 PM

rpardip

Log into the database as Schema Owner and:

SQL> select * from tab;
SQL> select * from cat;

Is this what you are looking for OR do you want to see it graphically (use a CASE tool to reverse engineer the schema).

01-15-2001, 02:20 PM

pst

You could connect as sys or system and do a

SELECT * FROM ALL_USERS ;

This will give all the schema names within that database.

cheers

pst.

01-15-2001, 02:27 PM

rshivagami

I want to see it graphically. I Reverse Enginner with Erwin for my SQLServer database.
And I tried doing the same for Oracle too.
But I could not establish a connection with my Oracle DSN from Erwin. It does not give me an error, but the login screen just stays there. Erwin version is 3.5.2.
Have you used this tool before?? Will you be knowing what the problem is?

Shiva.

01-15-2001, 02:36 PM

rpardip

Yes. I have used Erwin before and I was able to connect to
Oracle DB without any problems using a DNS (with Oracle Driver).

01-15-2001, 03:01 PM

rshivagami

Hi,

Thanks for your response.
If Erwin talks to Oracle without any hazzle, then why is mine not working??
These are the steps I followed :
1. Set up a system DSN on any machine for Oracle ODBC Driver 8.01.06 using the service name.
2. Open up Erwin and then set the target server to Oracle 8.x
3. Click on Oracle Connection and fill in the username/password, along with the DSN name.
4. And when I click 'connect', the screen just stays there, giving neither an error message nor a 'connected' message.

To think that anything could be wrong with the service name - I am able to use a 3rd party tool to export and import table data to and from the Oracle database without any poblem using the same DSN.
Is there anything like the DSN should reside in the same machine as the server for Erwin(though it is highly unlikely...)?
What do you think the problem could be?