Oracle virgin - how do I find out DB structure?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Oracle virgin - how do I find out DB structure?

  1. #1
    Join Date
    Nov 2005
    Posts
    2

    Oracle virgin - how do I find out DB structure?

    Hi,

    I've been stuck in a bit of an awkard position. I've been using Microsoft development products all my working life, including SQL Server, and I've now been asked to write an application which is going to have to interface with an Oracle database.

    The DB in question is powering a bought-in application but I need to be able to read and modify the data for other purposes. Before I can do this though I need to get to look at the tables and relationships of the data so I can construct effective queries to retrieve and modify the data that I need.

    I've been to have a look at the Oracle server in question (it's running Windows Server 2003) to see if I can find some sort of graphical interface to allow me to explore the tables and the data in them. In SQL Server I'd use Enterprise manager for this, so I presumed the Oracle Enterprise manager did the same job. However, it doesn't seem to - I can't get a visual listing of table names and without them I can't construct queries to look at the data, let alone find a GUI tool to dump it for me. I'm not even sure I can see the database I'm supposed to be working with.

    Can any of you kind people possibly enlighten me as to how I can get a table listing and/or point me at a good introduction to the Oracle toolset so I can start to get to grips with this beast?

    Cheers,
    Matt

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    What Oracle version are you using?

    OEM can give you what you want, if you know where to look.

    A lot of people use a program called TOAD which gives a nice representation of a database. There is a trial version you can download for free

  3. #3
    Join Date
    Nov 2005
    Posts
    2
    It's version 9.2.0.1.0

    I'll take a look at the TOAD - thanks for the tip.

    I've managed to find the table lists under "Schema" in the OEM, but there doesn't seem to be a GUI link to list the data. Guess I can just fire off queries in SQL.

    I'm not entirely sure that the database I need to work with is appearing in OEM. Is it possible that a machine could have a database on it that isn't registered with the OEM?

    Cheers,
    Matt
    Last edited by mattDP; 11-24-2005 at 12:02 PM.

  4. #4
    Join Date
    Jul 2002
    Posts
    335
    In OEM right click on a table and select view/edit contents to see the data. However if its more than a few thousand rows you need to start filtering.

    Yes a machine could have a database and not be listed in oem. You really need someone to quickly run you through oem (and get you started on the database you want).

    Toad is a great tool for developers. A similar thing is called sqltoolz, available on sourceforge.net and http://sqltools.net/.

    Not quite as good as toad, but its totally free.

    Bazza

  5. #5
    Join Date
    May 2003
    Location
    Pretoria, Rep of South Africa
    Posts
    191
    or PLSQL Developer

    http://www.download.com/PL-SQL-Devel...4-8591498.html

    do the things TOAD do
    Able was I ere I saw Elba

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