PUBS Database
Date: Thu, 18 Sep 2003 13:01:40 -0400
Message-ID: <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...
--
Posted via http://dbforums.com
Received on Thu Sep 18 2003 - 19:01:40 CEST