RE: What does it all mean?

I shall blame WINDOZE!

Perhaps I should have tried a WINDOZE Restart on Friday. Today the table shows up in the SB list and the query assist works as advertized.

GO FIGURE!

Thanks for the various ideas.

Dan
Daniel B Madvig
Campus Technologies

[cid:[email protected]]<http://nwc.edu/>

Northwestern College & Northwestern Media
3003 Snelling Ave.
St. Paul, MN 55113
www.nwc.edu<http://maps.yahoo.com/py/maps.py?Pyt=Tmap&addr=3003+Snelling+Ave.&csz=St.+Paul%2C+MN+55113&country=us>
651.631.5323

What if a chicken could cross the road without having her motives called into question?

From: [email protected] [mailto:[email protected]] On Behalf Of John Dorlon
Sent: Friday, March 22, 2013 3:52 PM
To: [email protected]
Subject: [toad] RE: What does it all mean?


Hmm...

I have no idea why that table doesn't show up in the SB then.  I don't see anything in the source that would explain it either.  :(

Maybe a fresh brain Monday morning will help.

Sorry I don't have anything more helpful to tell you.

-John


From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Madvig, Daniel B
Sent: Friday, March 22, 2013 3:36 PM
To: '[email protected]'
Subject: [toad] RE: What does it all mean?


Yup, found it that way, too.

NBRCLSH     POSNCTL           NO          DEVELOPMENT 3/21/2013 10:01:26 PM   2227  N                 NO    NO    NO    81920

----------------------------------
Session: [email protected]<mailto:[email protected]>
Timestamp: 15:00:30.616
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 1=1

----------------------------------

Daniel B Madvig
Campus Technologies

[cid:[email protected]]<http://nwc.edu/>

Northwestern College & Northwestern Media
3003 Snelling Ave.
St. Paul, MN 55113
www.nwc.edu<http://maps.yahoo.com/py/maps.py?Pyt=Tmap&addr=3003+Snelling+Ave.&csz=St.+Paul%2C+MN+55113&country=us>
651.631.5323

I want to to live in a world in which a hen can cross the road without being questioned as to her motives.  ;-)

From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of John Dorlon
Sent: Friday, March 22, 2013 3:17 PM
To: [email protected]<mailto:[email protected]>
Subject: [toad] RE: What does it all mean?


Sorry, I should have been more clear.

There are actually two queries that the SB runs to load table info.  The first one looks similar to this one (but may be slightly different, so be sure to find yours in Spool SQL)

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 1=1
order by table_name

My guess is that it will be there though, since it came up in the user_objects query.



From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Madvig, Daniel B
Sent: Friday, March 22, 2013 3:12 PM
To: '[email protected]'
Subject: [toad] RE: What does it all mean?


----------------------------------
Session: [email protected]<mailto:[email protected]>
Timestamp: 15:00:30.976
Select user, object_name, created, last_ddl_time from sys.user_objects
Where object_type = 'TABLE' ORDER BY 2

----------------------------------

I added the ORDER BY 2. Seems Toad sorts the output somewhere else.

NBRCLSH does show up in the output:

POSNCTL             NBRCLSH             3/21/2013 6:07:33 PM    3/21/2013 6:07:56 PM

Dan
Daniel B Madvig
Campus Technologies

[cid:[email protected]]<http://nwc.edu/>

Northwestern College & Northwestern Media
3003 Snelling Ave.
St. Paul, MN 55113
www.nwc.edu<http://maps.yahoo.com/py/maps.py?Pyt=Tmap&addr=3003+Snelling+Ave.&csz=St.+Paul%2C+MN+55113&country=us>
651.631.5323

I want to to live in a world in which a hen can cross the road without being questioned as to her motives .;-)

From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of John Dorlon
Sent: Friday, March 22, 2013 2:47 PM
To: [email protected]<mailto:[email protected]>
Subject: [toad] RE: What does it all mean?


Hm...

if you turn on spool sql and capture the query that loads the LHS, then run that query in the Editor, is NBRCLSH in the result?

From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Madvig, Daniel B
Sent: Friday, March 22, 2013 2:44 PM
To: '[email protected]'
Subject: [toad] RE: What does it all mean?


Nope, no filter.

[cid:[email protected]]

Daniel B Madvig
Campus Technologies

[cid:[email protected]]<http://nwc.edu/>

Northwestern College & Northwestern Media
3003 Snelling Ave.
St. Paul, MN 55113
www.nwc.edu<http://maps.yahoo.com/py/maps.py?Pyt=Tmap&addr=3003+Snelling+Ave.&csz=St.+Paul%2C+MN+55113&country=us>
651.631.5323

If life gives you melons, you may be lysdexic.

From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of John Dorlon
Sent: Friday, March 22, 2013 2:06 PM
To: [email protected]<mailto:[email protected]>
Subject: [toad] RE: What does it all mean?


Is there any filter enabled in the SB on the tables tab?   If so, that might be the reason why your NBRCLSH table doesn't show up.


From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Madvig, Daniel B
Sent: Friday, March 22, 2013 1:39 PM
To: '[email protected]'
Subject: [toad] RE: What does it all mean?


So far as I can tell, both are tables and both have public synonyms. When I look at an F4 DESCribe of them, except for the names I cannot tell them apart. In each case the script begins like this:

ALTER TABLE POSNCTL.NTRPCLS*
DROP PRIMARY KEY CASCADE;

DROP TABLE POSNCTL.NTRPCLS* CASCADE CONSTRAINTS;

CREATE TABLE POSNCTL.NTRPCLS*

*Or NBRCLSH (in black)

When I do an object search on either, I find both the table and the synonym.

To add to my confusion, even though I'm connected as the schema owner, POSNCTL, NBRCLSH is not to be found in the list of Tables. ??? The View and Synonym lists are empty - not a concern.

Dan

P.S. If I'm not using the latest version of Toad, I'm at least close with 11.6.1.6
dbm

From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Dennis Paulus
Sent: Friday, March 22, 2013 12:41 PM
To: [email protected]<mailto:[email protected]>
Subject: [toad] RE: What does it all mean?


Hi Daniel,
By chance, is 'nbrclsh' a synonym or view?  To verify, when you do a describe on it, the describe window displays, and on the left hand side, it'll show you the name, owner, and type.

Thanks,
Dennis


From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Madvig, Daniel B
Sent: Friday, March 22, 2013 12:56 PM
To: '[email protected]'
Subject: [toad] What does it all mean?


In my "FROM" clause the first table is you might say, "Grayed out", but not in the usual sense of, "You can't do anything with this." It seems to be somewhat the opposite. In particular, when I use the nt alias for the table followed by a period, the query assist comes to my aid. But when I try the same with the nb alias, no such help. I can DESCribe the black table and query from it just fine. What's going on here?

FROM
     ntrpcls nt,
     nbrclsh nb

TGIF!!

Dan
Daniel B Madvig
Campus Technologies

[cid:[email protected]]<http://nwc.edu/>

Northwestern College & Northwestern Media
3003 Snelling Ave.
St. Paul, MN 55113
www.nwc.edu<http://maps.yahoo.com/py/maps.py?Pyt=Tmap&addr=3003+Snelling+Ave.&csz=St.+Paul%2C+MN+55113&country=us>
651.631.5323

If life gives you melons, you may be lysdexic.