Re: PUBS Database

From: michael ngong <mngong_at_yahoo.com>
Date: 19 Sep 2003 11:24:18 -0700
Message-ID: <ecf365d5.0309191024.1b562652_at_posting.google.com>


mmidcap <member40221_at_dbforums.com> wrote in message news:<3386814.1063904500_at_dbforums.com>...
> Hello,
>
>
>
> I'm trying to install the PUBS database on my WIN2000, using SQL*PLUS
> (Oracle8i), but I can't get it to work. I don't think I have everything
> I need, but then I don't even know where to put the script file I have.
> I've saved the script in almost every sub-directory of the oracle
> directory, and the oracle directory itself. Then I'll run the following
> from the cmd prompt> sqlplus pubs/pubs_at_diogenes. I receive the following
> error "ORA-12154: TNS:could not resolve service name" Below is the first
> part of the file (before it creates the Tables). What am I doing wrong?
>
>
>
> Thank you in advance for you help.
>
>
>
> Mindy
>
>
>
> ---script...
>
>
>
> drop user pubs cascade;
>
>
>
> create user pubs identified by pubs;
>
>
>
> alter user pubs default tablespace users;
>
>
>
> alter user pubs temporary tablespace temp;
>
>
>
> grant dba to pubs;
>
>
>
> connect pubs/pubs_at_diogenes
>
>
>
>
>
> CREATE TABLE AUTHOR...
Except I am missing something
You are trying to connect to diogenes not PUBS Is PUBS created already ?

Michael Tubuo Ngong Received on Fri Sep 19 2003 - 20:24:18 CEST

Original text of this message