> On 20 Jan 00, at 10:38, Stephen_Reilly at dell.com wrote:
>> > >>er...
> > this would be part of your login script, once you point to one server
> > you can only point to one database. After that what you see are
> > schemas, what the DBA has allowed you to see. The database is not
> > named, its just Oracle and there can be only one.
> >I know this is way off topic, but that's just wrong. You can host
as
>many databases as you have disk space for off one oracle
>instance.
and you can seperate them into distinct databases ?? The visible tables are
related directly to the user's schema not to a different database. What you
would have is still technically one database per server.
>The command (via sqlplus) to connect to a different database would
>be:
>connect user/pass at dbname
which automatically logs you out of your current database . . .
> if you setenv ORACLE_SID, that'll be the default database that's
> connected to.
>or you can set it up via oracle installer
> There are lots of good O'Reilly books on Oracle.
>> A web site called "Oracle Underground" has many links to learning
> material. I don't know the url off hand, but any good search engine
> should find it for you.
>> --
> Irish Linux Users' Group: ilug at linux.ie>http://www.linux.ie/mailman/listinfo/ilug for (un)subscription
> information.
> List maintainer: listmaster at linux.ie>
Maintained by the ILUG website team. The aim of Linux.ie is to
support and help commercial and private users of Linux in Ireland. You can
display ILUG news in your own webpages, read backend
information to find out how. Networking services kindly provided by HEAnet, server kindly donated by
Dell. Linux is a trademark of Linus Torvalds,
used with permission. No penguins were harmed in the production or maintenance
of this highly praised website. Looking for the
Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!
