At 10:16 AM 3/22/01 -0500, Brooks, Ken wrote:
>I got it.
ah. :) good
>I had the table name listed as aradmin_eps_service_instructions
>when in fact it should have been aradmin.eps_service_instructions (with
>the dot).
>
>I did not know this because all of the tables I had seen linked to this
>before used _ ,but the actual name (which i normally don't have priveledge
>to even view) uses the .
Actually, in Oracle parlance, the table name is
EPS_SERVICE_INSTRUCTIONS, and it exists in the ARADMIN schema. If there is
no public synonym called EPS_SERVICE_INSTRUCTIONS, then you'd need to
specify both schema and table name (eg: owner.table_name) in order to view
the table.
If you didn't have the privs to view a given table, you'd not be able to
view it whether you specified the schema or not. :)
A list of the tables you can "see" along with their schema (owners) can
be obtained by running the following SQL query:
SELECT OWNER,TABLE_NAME FROM ALL_TABLES;
>Whee!
Indeed. :)
..or, try:
SELECT OWNER||'.'||TABLE_NAME FROM ALL TABLES;
- Brian
-------------------------------------
Brian S. Dunworth
Sr. Software Development Engineer
Oracle Database Administrator
The Printing House, Ltd.
(850) 875-1500 x225
<[EMAIL PROTECTED]>
-------------------------------------
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
