This is Oracle V 10.02.0010 for Windows. Under sqlplus I can log in as system/seekrit, and can do:
SQL> select table_name, tablespace_name from user_tables where table_name like '%STATE%'; TABLE_NAME TABLESPACE_NAME ------------------------------ ------------------------------ STATE SYSTEM LOGMNR_DICTSTATE$ but in Perl, if I do: my($table_sth) = $dbh -> table_info(undef, 'SYSTEM', '%', 'TABLE'); I don't get back any table data at all. I assume the problem is the 'SYSTEM', i.e. the value of the schema parameter. So, any ideas as to what schema I should use in Perl? Is TABLESPACE_NAME the same as schema? More info: I used table_info() to get a list of schema names, and from that can get tables per schema for some of the schema, but nothing for SYSTEM: Schema => Tables ---------------- TSMSYS => SRS$ OUTLN => OL$ OL$HINTS OL$NODES HR => COUNTRIES LOCATIONS DEPARTMENTS JOB_HISTORY EMPLOYEES REGIONS JOBS FLOWS_FILES => WWV_FLOW_FILE_OBJECT$ SYS => No tables SYSTEM => No tables XDA => ^C (Took so long) MDSYS => ^C FLOWS_020100 => ^C DBSNMP => ^C CTXSYS => ^C -- Ron Savage [EMAIL PROTECTED] http://savage.net.au/index.html
