Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Multiple "databases" in Oracle...from a SQL Server Admin view..HELP

Re: Multiple "databases" in Oracle...from a SQL Server Admin view..HELP

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Sat, 5 Oct 2002 23:52:32 +1000
Message-ID: <Q0Cn9.46760$g9.134189@newsfeeds.bigpond.com>

"Galen Boyer" <galenboyer_at_hotpop.com> wrote in message news:uwuoxih80.fsf_at_hotpop.com...
> On Tue, 1 Oct 2002, howardjr2000_at_yahoo.com.au wrote:
> >
> > you use SQL Server databases to break a complete SQL Server server
> > down into smaller pieces. Precisely what a tablespace does
> > (physically) or a schema does (logically).
>
> Well, even a tablespace is really a logical thing, right? But, then
> again, a schema is physical to many people I talk to. :-)

Depends how you view it, but I can point to the datafiles making up a database. What do you point to for a schema? Apart from row returns from dba_users and dba_objects?

Regards
HJR
> --
> Galen deForest Boyer
> Sweet dreams and flying machines in pieces on the ground.
Received on Sat Oct 05 2002 - 08:52:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US