I
On Jun 9, 2006, at 2:08 AM, Ron Savage wrote:
On Fri, 9 Jun 2006 01:17:06 -0400, Jeffrey Seger wrote:
So a similar query to what you are looking for in table_info is:
select table_name, owner from all_tables where table_name like
'%STATE%';
Hmmm.
SQL> select table_name, owner from all_tables where table_name like
'%STATE%';
TABLE_NAME OWNER
------------------------------ ------------------------------
SCHEDULER$_STEP_STATE SYS
WRI$_SQLSET_STATEMENTS SYS
WWV_FLOW_TREE_STATE FLOWS_020100
STATE SYSTEM
LOGMNR_DICTSTATE$ SYSTEM
Nice try, but that gives the same value as before, SYSTEM, which
doesn't work
:-((.
However it does give some tables with OWNER=SYS which I didn't get
before...
Just for the sake of completeness, are you logging in as 'SYSTEM' in
your perl script?
Or are you logging in as a user which might not have permission to
see the table?
-Chris
--
"Technically, you would only need one time traveler convention" -
Dorothy Gambrell, "Cat and Girl"