469,148 Members | 1,275 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,148 developers. It's quick & easy.

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.
Jul 19 '05 #1
2 1893

"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
Jul 19 '05 #2
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.
Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by aaj | last post: by
6 posts views Thread by Mortrek | last post: by
7 posts views Thread by Danny J. Lesandrini | last post: by
3 posts views Thread by Hanif Merali | last post: by
8 posts views Thread by Mark | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
1 post views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.