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