I'd just make the link and try the queries to see how slow they are and if
they have any effect on production apps. (It sounds like you don't have a
test or development environment to try this in.). If the queries are slow
or impact production apps, you could suggest an alternative - perhaps
materialized views.
"Rose" <rosebernardo_at_yahoo.com> wrote in message
news:d200c71d.0311081723.4a3acd71_at_posting.google.com...
> I am working for the Business Investigation Department. They requested
> a database link to production so they can perform their research to
> the production environment through this database link.
> Their investigation consists of procedures that read files of any
> number between 50,000 to 1,000,000 records and perform queries against
> the production database - one by one. Since their customers make about
> twenty to thirty different requests every day, they don't have time to
> make up test data. Therefore they also wish to test their procedure
> with production data using this same databalink link.
>
> I believe this whole thing to be crazy. Can someone give me some very
> good technical explanation and/or point me to somewhere I can get a
> technical paper of something I can give to my boss to stop my boss?
Received on Sun Nov 09 2003 - 12:03:33 CST
