"ad-hoc queries" as in, we'll write something that will bring your database to its knees
that kind of reporting, it's better to have a separate database --- "Thater, William" <[EMAIL PROTECTED]> wrote: > Weaver, Walt scribbled on the wall in glitter crayon: > > > Okay, we have a request for quite a few of our customers for > read-only > > copies of their databases they can do their ad-hoc queries on. > These > > read-only databases need to as closely matched to the production > > database as possible, i.e., exact, from their point of view. > > can they use a read only login for it? just set up a username with > no quota > and grant it select on the tables it needs. or am i missing > something here? > > -- > Bill "Shrek" Thater ORACLE DBA BAARF Party member #25 > [EMAIL PROTECTED] > ------------------------------------------------------------------------ > Making allowances for human imperfections, I do feel that in America > the > most valuable thing in life is possible; the development of the > individual > and his creative powers. - Albert Einstein > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Thater, William > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).