DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Oracle - schema

  1. #1
    Join Date
    Sep 2000
    Location
    VA
    Posts
    343
    Hi all,

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

    Shiva.

  2. #2
    Join Date
    Sep 2000
    Posts
    155

    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).

  3. #3
    Join Date
    Sep 2000
    Posts
    103
    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.

  4. #4
    Join Date
    Sep 2000
    Location
    VA
    Posts
    343

    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.

  5. #5
    Join Date
    Sep 2000
    Posts
    155

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


  6. #6
    Join Date
    Sep 2000
    Location
    VA
    Posts
    343
    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?

    Shiva.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width