[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
RE: [sqr-users] SQR Database Object Problem
- Subject: RE: [sqr-users] SQR Database Object Problem
- From: "the dragon" <ceprn@hotmail.com>
- Date: Wed, 16 Mar 2005 09:55:04 -0600
- Bcc:
- Delivery-date: Wed, 16 Mar 2005 10:57:32 -0500
- In-reply-to: <LPEPJEDGBGOKOJJDHJJMIEMNCKAA.Nachman.Kreitman@corp.idt.net>
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
I think she's using the workbench... If that's the case, and you're
experiencing these issues, guess you'll have to build your sqr from scratch,
the old fashioned way.
peace,
clark 'the dragon' willis
PSA: Salary <> Slavery. If you earn a salary, your employer is renting your
services for 40 hours a week, not purchasing your soul. Your time is the
only real finite asset that you have, and once used it can never be
recovered, so don't waste it by giving it away.
I work to live; I don't live to work.
"Time is the coin of your life. It is the only coin you have, and only you
can determine how it will be spent. Be careful lest you let other people
spend it for you."
Carl Sandburg
(1878 - 1967)
----Original Message Follows----
I am not using any tool. This happens when I go into the "Query Builder -
Select Tables". All this is SQR supplied.
-----Original Message-----
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-----
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