In Toad 12.5.0.10 (and earlier 12.5’s) I’ve noticed sometimes that when I control-D describe an object (letting Toad figure out the object type and leaving the object owner as “-- N/A or Unknown --”), it sometimes opens the Describe window, but puts . in the tab name and then gives me a dialog box saying “Table . does not exist”. And this is true – the table exists in a different schema. Note that this is different from when I type garbage in the control-D popup
window; if I do that, it immediately tells me “Object ASDFASDF not found” and doesn’t open the Describe window at all.
I tried spooling SQL while I did the control-D describe, but it didn’t seem to tell me much – it consisted only of three queries to USER_OBJECTS and USER_ALL_TABLES. (And yes, I have “check for DBA views” checked, and I have access to them.) It’s like
it was referring to some cached information, erroneously.
Any idea what’s causing this? Below is the spooled SQL. NESCHR is my schema, SALES_ORG_DIM is what I was trying to describe. According to DBA_OBJECTS there are six objects by that name: three private synonyms, a table, a package, and a package body, with
five different owners none of which are NESCHR.
Session: NESCHR@USMGENP.MONSANTO.COM
Timestamp: 14:32:24.893
Select 1
from sys.user_objects
where object_name =:nm
and object_type =:t
:nm(VARCHAR[13],IN/OUT)=‘SALES_ORG_DIM’
:t(VARCHAR[17],IN/OUT)=‘MATERIALIZED VIEW’
Session: NESCHR@USMGENP.MONSANTO.COM
Timestamp: 14:32:27.332
Select last_ddl_time
from sys.user_objects
where object_name = :nam
and object_type = :typ
:nam(VARCHAR[13],IN/OUT)=‘SALES_ORG_DIM’
:typ(VARCHAR[17],IN/OUT)=‘MATERIALIZED VIEW’
Session: NESCHR@USMGENP.MONSANTO.COM
Timestamp: 14:32:27.338
Select t.table_name,user as owner, t.cluster_name,
t.partitioned, t.iot_type, t.tablespace_name, t.last_analyzed,
round(t.num_rows) num_rows
, t.temporary, t.table_type, t.table_type_owner, t.nested
, decode(nvl(tablespace_name, 'x') || upper(partitioned)
|| nvl(iot_type, ‘x’) || to_char(pct_free), ‘xNOx0’,
‘YES’, ‘NO’) is_External
, t.dropped
, t.initial_extent
from sys.user_all_tables t
where t.table_name = :obj
:obj(VARCHAR[13],IN/OUT)=‘SALES_ORG_DIM’
Nate Schroeder
US Row Crops IT Data Management Team
Monsanto Company
800 N. Lindbergh Blvd. G3WB - Saint Louis, MO - 63167
314-694-2592
This e-mail message may contain privileged and/or confidential information, and is intended to be received only by persons entitled
to receive such information. If you have received this e-mail in error, please notify the sender immediately. Please delete it and
all attachments from any servers, hard drives or any other media. Other use of this e-mail by you is strictly prohibited.
All e-mails and attachments sent and received are subject to monitoring, reading and archival by Monsanto, including its
subsidiaries. The recipient of this e-mail is solely responsible for checking for the presence of “Viruses” or other “Malware”.
Monsanto, along with its subsidiaries, accepts no liability for any damage caused by any such code transmitted by or accompanying
this e-mail or any attachment.
The information contained in this email may be subject to the export control laws and regulations of the United States, potentially
including but not limited to the Export Administration Regulations (EAR) and sanctions regulations issued by the U.S. Department of
Treasury, Office of Foreign Asset Controls (OFAC). As a recipient of this information you are obligated to comply with all
applicable U.S. export laws and regulations.