RE: [sqr-users] SQR Database Object Problem

["Nachman Kreitman" <Nachman.Kreitman@corp.idt.net>]

I am not using any tool.  This happens when I go into the "Query Builder -
Select Tables".  All this is SQR supplied.

-----Original Message-----
From: sqr-users-bounces+nachman.kreitman=corp.idt.net@sqrug.org
[mailto:sqr-users-bounces+nachman.kreitman=corp.idt.net@sqrug.org]On
Behalf Of Knapp, Richard
Sent: Wednesday, March 16, 2005 9:54 AM
To: This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.
Subject: RE: [sqr-users] SQR Database Object Problem


Sounds like not an SQR question.  What tool are you using?  PS query?
If so, you're screwed without the quick security fix.  Use another tool,
sqlplus, eg or toad and query the user or dba tables.

Richard Knapp
Database Programmer/Analyst
Institutional Research and Planning
University of Missouri System
573-882-8856
knappr@umsystem.edu

-----Original Message-----
From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org
[mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On Behalf Of
Nachman Kreitman
Sent: Wednesday, March 16, 2005 8:47 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] SQR Database Object Problem

I want to create a report with tables from a particular schema.  This
schema
contains 119 tables, 197 views and 69,913 synonyms.  When I click on the
schema, it takes 9 minutes before I get any response back (nothing else
is
running on my desktop).  The "+" sign disappears and I see no database
objects from that schema.  When I click on a schema that does not have
too
may objects, the response comes back with no problem, and I see all of
the
necessary objects from that schema.  How may I retrieve the database
objects
from this large schema?  You assistance is greatly appreciated.

Thank you.


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users