Re: Sybase to Oracle

One quick question I would like to add to this comparison. Sybase seems to strongly object if you do not put your "devices"/datafiles on raw devices. You don't have to,
but you get a warning message if you don't. What I've heard is that this is because it guarantees comitted information on the OS level. What is Oracle's philosophy on this
potential problem, since it doesn't seem to care what you put your datafiles on. Why
doesn't Oracle see the same potential problem Sybase does?

Denny Koovakattu wrote:

> Hi,
>
> Look at it this way.
>
> 1. Oracle Database/Instance --> Sybase Server
>
> Don't consider parallel server because Sybase has no equivalent.
>
> 2. Oracle Schema/Users --> Sybase Databases
>
> In Sybase the database owns the objects created. You add users to the
> database. In Oracle, the objects are owned by the user creating it. You
> can grant permissions to other users.
>
> 3. Oracle Tablespace --> Sybase Segments
>
> In Sybase you can place objects on segments. For instance you can
> place a table in a particular segment. In Sybase you create devices and
> create segments on that. So you could have multiple segments on a single
> device. I am not sure whether you need to create devices if you are not
> using raw devices. Got to check that out with our Sybase Administrator.
>
> Regards,
> Denny
>
> In article <7m11fi$uev$1_at_nnrp1.deja.com>,
> lanceg_at_my-deja.com wrote:
> > Simple, yet I'm puzzled. After hours of research
> > I'm stumped.
> >
> > What is the deal with Oracle and its definition
> > of a database? Is it an instance, the server
> > itself, a datasource? Can you have more than one
> > db on a single Oracle server?
> >
> > Below is how sybase has its architecture, can
> > some one tranlate it to Oracle? Or point me to
> > the right direction.
> >
> > Basic SYBASE ARCHITECTURE
> >
> > 1. A single Sybase Server (11.5)
> > --- a. first db (ACC_DB)
> > --- b. second db (Survey_DB)
> > --- c. third db (Symposium_DB)
> > --------- c.1 Tables belonging to third db
> > --------- c.2 Storred Procs belonging to third db
> > --------- c.3 Rest of the objects......to third db
> > --- d. forth db (Inventory_DB)
> >
> > --------- c.3 other objetcs
> >
> > All the dbs are up and running concurrently.
> >
> > Thanks in advance.
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Sun Jul 11 1999 - 01:55:24 CDT