home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.oracle      Overblown overpriced overengineered SHIT      2,288 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 315 of 2,288   
   tojo to All   
   Re: how to view sample schema   
   03 Sep 03 08:52:37   
   
   XPost: comp.databases.oracle.misc, comp.database.oracle   
   From: Tojo@hotmail.com   
      
   In article ,   
   res1e24o@verizon.net says...   
   > what's the command to view if the sample schema has been installed with 9i   
   > on my RH7.3?   
   >   
   Log on as SYSTEM, then   
      
   select owner, count(*) num_schema_tables   
   from dba_tables   
   group by owner   
      
   Owners for sample schemas will be OE, PM, HR, stuff like that.   
      
   -- Tom   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca