From: member40221@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@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@diogenes   
      
      
      
      
      
   CREATE TABLE AUTHOR...   
      
      
   --   
   Posted via http://dbforums.com   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)