Re: dumb newbie question - won't take you long

To find out which users are in the starter database:

    SELECT username from DBA_USERS;

To find out what tables belong to a user:

    SELECT table_name FROM DBA_TABLES WHERE owner = '<USER_NAME>' Note the username must be upper case and surrounded by single quotes.

For a single user system running on an NT you might as well use the GUI server manager stuff. You shouldn't need it very often, if at all, in normal operations since tasks such as starting up and shutting down the database can be easily done either by using the GUI interface or by making the database a service that NT starts when it boots.

regards

Jerry Gitomer

TwoSheds wrote in message <7hev1j$125l$1_at_quince.news.easynet.net>...
>Hello to all you Oracle experts.
>I am just starting my foray into the world of Oracle8, I have installed it
>on NT (trial version from Oracle site) and read the accompanying docs till
>my eyes hurt (there's just *so* much of it!).
>I'd like to now create an example database of my own, or experiment with
the
>starter database that came with it.
>
>Here's the questions:
>
>In the starter database, the docs say the contents consist of User
accounts,
>Tablespaces, etc. What it doesn't say is whether there is any data in it.
>Are there any data tables already created, which I can muck around with
with
>SQL?
>
>svrmgr30.exe is the Server Manager program, I guess. Issuing a HELP command
>in this utility tells me I should read the Server Manager User's Guide.
>However, there is only an Oracle7 Server Manager User's Guide in the
>documentation, which seems to concern a graphical version of the program.
>Where do I get the docs for Oracle8 Server Manager User's Guide?
>
>Any help will be appreciated, I realise I've probably missed some basic
>points concerning databases of this scale - I've got a long way to go...
>
>Thanks
>
>
>
>
Received on Thu May 13 1999 - 12:02:49 CDT