Re: Sybase to Oracle

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 Fri Jul 09 1999 - 14:03:43 CDT