Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: how to view all tables?

Re: how to view all tables?

From: Kevin Crosbie <caoimhinocrosbai_at_yahoo.com>
Date: Thu, 14 Apr 2005 11:03:29 +0200
Message-ID: <1113469673.1af48da62ed276acae6f4bf90d25035e@teranews>


Install Toad from Quest Software and that will give you a nice GUI view of your database.

Or Enterprise Manager if you have it...

That way you will know what you can play with. Toad will even let you change the data directly.

"Lewis C" <lewisc_at_excite.com> wrote in message news:49bj51lo9sed3r41jqamcpf0qhd3ln33jp_at_4ax.com...
> On Mon, 11 Apr 2005 03:04:40 +0930, "Ian" <not_at_available.com.au>
> wrote:
>
> >Hi,
> >I have just installed Oracle 10 on Solaris and would like to practice
some
> >SQL
> >I selected the examples & schema examples to be installed.
> >Could someone please help me how to find the examples schema, or the
command
> >to view all the table names?
> >I need to know what to querry. eg select * from ???
> >thanking you in advance
> >
>
> Others have answered the question about finding table names.
>
> But which examples did you want? SCOTT/TIGER is the oldman of the
> bunch. Standard EMP, DEPT etc. However there are more, off the top
> of my head, I remember HR, OE, and SH. I think there was an OLAP or
> BI or something like that also. I do remember that SH has a
> warehousing schema with a large table and a materialized view.
>
> There may be others. Again, off the top of my head I remember the
> passwords for these are the same as the account, i.e. HR/HR, SH/SH,
> OE/OE.
>
> By default, unless you chose to unlock them during install, the
> accounts are locked. You will know this if you try to login and get a
> message that the accounts are locked. heh Doi.
>
> To unlock them, log in as a DBA and issue:
>
> ALTER USER HR ACCOUNT UNLOCK;
> ALTER USER OE ACCOUNT UNLOCK;
> ALTER USER SH ACCOUNT UNLOCK;
>
> Hope that helps,
>
> Lewis
>
> -----------------------------------------------------------
> Lewis R Cunningham
>
> Author, ItToolBox Blog: An Expert's Guide to Oracle
> http://blogs.ittoolbox.com/oracle/guide/
>
> Topic Editor, Suite101.com: Oracle Database
> http://www.suite101.com/welcome.cfm/oracle
>
> Sign up for courses here:
> http://www.suite101.com/suiteu/default.cfm/416752
> -----------------------------------------------------------
Received on Thu Apr 14 2005 - 04:03:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US