Comments below ... -- Ron Reidy Lead DBA Array BioPharma, Inc.
-----Original Message----- From: Ron Savage [mailto:[EMAIL PROTECTED] Sent: Thursday, June 08, 2006 10:47 PM To: List - DBI users Subject: Oracle schema names: sqlplus 'v' Perl 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'); [rr] I have never used this method. Why don't you just issue the same query you would issue in SQL*Plus? 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? [rr] No, a tablespace is a logical entity, which must have one or more datafiles assigned to it. Tablespaces are where table and index data live. 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 This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. Please notify the sender of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0), and then delete it from your system.
