Re: Question

On Fri, 23 Feb 2001 16:25:41 -0500, "Thomas Durlach" <durlecht_at_msu.edu> wrote:

>Currently i am using sybase server for my application....i am using two
>different database files (one for system stuff and the other for
>data)....when the user logs in from the system one it then lets it into the
>other one with the data. i am trying to convert over to Oracle....can i use
>this scheme? is it possible? should i do a view-type setup? any suggestions
>or comments would be greatly apprecaited.
>
>
>regards,
>
>thomas durlach
>

In Oracle you don't have multiple databases as in Sybase. You have multiple schemas. You would typically connect as a schema owner, and leave system alone as the data dictionary is automatically accessed on your behalf.
Oracle is a completely different beast. Please try to read the Oracle Concepts Manual and try to avoid 'porting' your Sybase habits to Oracle, from the Oracle perspective this will end in a problematic application.

Regards,

Sybrand Bakker, Oracle DBA Received on Fri Feb 23 2001 - 15:42:13 CST