Re: Migrating an Application from SQL Server 2000 to Oracle 10g

From: gazzag <>
Date: Wed, 16 Jul 2008 04:17:16 -0700 (PDT)
Message-ID: <>

On 15 Jul, 23:38, tcole6 <> wrote:
> We have an application that was written using SQL Server 2000 as the
> RDBMS. We now have a need to convert this to Oracle. We know that we
> obviously need to hire an Oracle DBA, but we don't have one at this
> time...
> Our application uses queries with joins across databases. In SQL
> Server this is acheived like so:
> SELECT a.a, a.b, b.a, b.b from Database1.dbo.Table1 a LEFT JOIN
> Database2.dbo.Table1 b WHERE a.c = '123'
> We absolutely do not understand the how Oracle uses Schemas, but we
> are hoping to be able to create a structure where the above select
> statement would still function. In other words we need to create these
> databases with tables under the schema dbo. Otherwise we would need to
> rewrite lots of code.
> Are schemas tied to user accounts? Can anyone help me understand this,
> or is this information just too vague?
> Thanks in advance.

In addition to everything Joel Garry said, this may be of some use too:

HTH -g Received on Wed Jul 16 2008 - 06:17:16 CDT

Original text of this message