[Q] create second schema under a account ???

e 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. Received on Wed Dec 29 2004 - 15:09:52 CST