Question on migrating from MSSQL temp tables and remote queries

[lev]

Hello,

I am attempting to migrate an MSSQL server application to Oracle. This
application pulls in data from remote databases into temp tables and
then does various joins of that data with local tables.

There are two requirements: the temp tables cannot be permanent
members of the schema and application has to be self sufficient in
create database links - users cannot be asked for that.

The only solution that comes to mind is to create database links via
SQL, pull in the data, create the temp tables and then drop the
created links and temp tables when they are no longer needed. But that
seems inelegant. Is there a better way?

Any info is much appreciated. Cheers, Lev.

[Jim Kennedy]

"lev" <pe*****@msn.com> wrote in message
news:63**************************@posting.google.c om...

Hello,

I am attempting to migrate an MSSQL server application to Oracle. This
application pulls in data from remote databases into temp tables and
then does various joins of that data with local tables.

There are two requirements: the temp tables cannot be permanent
members of the schema and application has to be self sufficient in
create database links - users cannot be asked for that.

The only solution that comes to mind is to create database links via
SQL, pull in the data, create the temp tables and then drop the
created links and temp tables when they are no longer needed. But that
seems inelegant. Is there a better way?

Any info is much appreciated. Cheers, Lev.

Why are the requirements such? Do we have the tyranny of the requirement of
a genuine business need? Describe the problems that you are trying to solve
instead of how to implement a solution. There may be a better solution.
Jim

[lev]

>

Why are the requirements such? Do we have the tyranny of the requirement of
a genuine business need? Describe the problems that you are trying to solve
instead of how to implement a solution. There may be a better solution.
Jim

Jim,

This is a commercial software product, and history shows that the
average customer gets very upset if the schema is changed from
previous version or if any if accessive manual database administration
is involved. In this appliction there can be many databases involved,
and all need to exchange data. This would require a creation of N^2
database links - something we are trying to avoid.

Thanks.

Lev.