On 24 Jan 00, at 4:18, Stephen_Reilly at dell.com wrote:
> 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.
You can have multiple completely different databases managed by their own
processes and with their own tablespaces (collections of disk files and/or
raw partitions) and within each database your schema can then be
partitioned by user, but one users tables may be accessed by another user
if they have the permissions to do so. In fact you can do a select across
databases if you really need or want to.
> >connect user/pass at dbname>> which automatically logs you out of your current database . . .
...and into the new one.
> > if you setenv ORACLE_SID, that'll be the default database that's
> > connected to.
> or you can set it up via oracle installer
but if you setenv (or export=) just before you connect it replaces the
'@dbname' part of the connect string.
This no longer has anything to do with Linux so if anyone wants to
continue the conversation, email me privately.
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!