Re: Default db

From: Daniel A. Morgan <damorgan_at_exesolutions.com>
Date: Sun, 23 Dec 2001 22:05:00 +0000
Message-ID: <3C26550C.FD533F@exesolutions.com>

I suspect from the way you have worded your question that your background is in SQL Server or Sybase. In Oracle it is not a "default db" it is your schema.

If I am correct please take note that many things in Oracle are also different including the entire locking and concurrency model. Be sure that you understand how Oracle works before you trying developing against it. If not ... please just ignore this posting.

Daniel A. Morgan

Yaron Avior wrote:

> Hi,
> How can I set my default db to other than my user name ? i.e. my user
> login name is xxx,
> and so is my default db (schema). I want yyy to be my default db so I
> can write "select * from table1" in my queries, instead of "select *
> from yyy.table1".
> thanks
Received on Sun Dec 23 2001 - 16:05:00 CST