[Q] How to create second schema under a user account?

  • From: dba1 mcc <mccdba1@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 29 Dec 2004 13:07:59 -0800 (PST)

We have ORACLE 9.2.0.6 on UNIX server.  I know ORACLE
support multiple schemas under a user account.  Does
any know how to do following and give me a sample:

   1. create second schema under a user

   2. create table or view under second schema

   3. switch between schemas


Thanks.

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
--
//www.freelists.org/webpage/oracle-l

Other related posts:

  • » [Q] How to create second schema under a user account?