Re: Where's my sample database?

Try
select table_name, owner
from dba_tables
where table_name in ('EMP','DEPT');
(The capitals are mandatory, all object_names are in uppercase) If that doesn't result in anything the script to build the tables has not been run. AFAIK it is stored as demobld.sql in $ORACLE_HOME/rdbms/admin.

Hth,

Sybrand Bakker, Oracle DBA

kev <kevin.porter_at_fast.no> wrote in message news:3785F9B9.9BD3BFB0_at_fast.no...
> Hi,
> I've just installed Oracle8 on Linux. Oracle's installation instructions
> didn't work, so I used the instructions at
> http://jordan.fortwayne.com/oracle/index.html, which includes a step to
> install the sample database.
> I don't know if I have this sample database, however, in fact I can't
> connect as scott/tiger in svrmgrl. I just get "ORA-01017: invalid
> username/password; logon denied".
>
> Could someone tell me how can I tell if the sample db is there or not
> (I've already connected as internal and done a startup), for example
> what tables are in it, so I can do a simple select statement which'll
> tell me if it exists.
>
> thanks,
>
> - Kev
>
>
Received on Sat Jul 10 1999 - 14:49:31 CDT