What does it all mean?

Discussion:

Madvig, Daniel B

2013-03-22 16:55:54 UTC

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:***@01CA8872.BBCD8CA0]<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.

Dennis Paulus

2013-03-22 17:40:44 UTC

Permalink

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: ***@yahoogroups.com [mailto:***@yahoogroups.com] On Behalf Of Madvig, Daniel B
Sent: Friday, March 22, 2013 12:56 PM
To: '***@yahoogroups.com'
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:***@01CA8872.BBCD8CA0]<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.

Madvig, Daniel B

2013-03-22 18:38:44 UTC

Permalink

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: ***@yahoogroups.com [mailto:***@yahoogroups.com] On Behalf Of Dennis Paulus
Sent: Friday, March 22, 2013 12:41 PM
To: ***@yahoogroups.com
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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of Madvig, Daniel B
Sent: Friday, March 22, 2013 12:56 PM
To: '***@yahoogroups.com'
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:***@01CA8872.BBCD8CA0]<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.

John Dorlon

2013-03-22 19:06:06 UTC

Permalink

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: ***@yahoogroups.com [mailto:***@yahoogroups.com] On Behalf Of Madvig, Daniel B
Sent: Friday, March 22, 2013 1:39 PM
To: '***@yahoogroups.com'
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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of Dennis Paulus
Sent: Friday, March 22, 2013 12:41 PM
To: ***@yahoogroups.com<mailto:***@yahoogroups.com>
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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of Madvig, Daniel B
Sent: Friday, March 22, 2013 12:56 PM
To: '***@yahoogroups.com'
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:***@01CA8872.BBCD8CA0]<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.

Madvig, Daniel B

2013-03-22 19:43:57 UTC

Permalink

Nope, no filter.

[cid:***@01CE270B.AF408DD0]

Daniel B Madvig
Campus Technologies

[cid:***@01CA8872.BBCD8CA0]<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: ***@yahoogroups.com [mailto:***@yahoogroups.com] On Behalf Of John Dorlon
Sent: Friday, March 22, 2013 2:06 PM
To: ***@yahoogroups.com
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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of Madvig, Daniel B
Sent: Friday, March 22, 2013 1:39 PM
To: '***@yahoogroups.com'
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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of Dennis Paulus
Sent: Friday, March 22, 2013 12:41 PM
To: ***@yahoogroups.com<mailto:***@yahoogroups.com>
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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of Madvig, Daniel B
Sent: Friday, March 22, 2013 12:56 PM
To: '***@yahoogroups.com'
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:***@01CA8872.BBCD8CA0]<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.

John Dorlon

2013-03-22 19:46:38 UTC

Permalink

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: ***@yahoogroups.com [mailto:***@yahoogroups.com] On Behalf Of Madvig, Daniel B
Sent: Friday, March 22, 2013 2:44 PM
To: '***@yahoogroups.com'
Subject: [toad] RE: What does it all mean?

Nope, no filter.

[cid:***@01CE270C.11B15C10]

Daniel B Madvig
Campus Technologies

[cid:***@01CA8872.BBCD8CA0]<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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of John Dorlon
Sent: Friday, March 22, 2013 2:06 PM
To: ***@yahoogroups.com<mailto:***@yahoogroups.com>
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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of Madvig, Daniel B
Sent: Friday, March 22, 2013 1:39 PM
To: '***@yahoogroups.com'
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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of Dennis Paulus
Sent: Friday, March 22, 2013 12:41 PM
To: ***@yahoogroups.com<mailto:***@yahoogroups.com>
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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of Madvig, Daniel B
Sent: Friday, March 22, 2013 12:56 PM
To: '***@yahoogroups.com'
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:***@01CA8872.BBCD8CA0]<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.

Madvig, Daniel B

2013-03-22 20:12:13 UTC

Permalink

----------------------------------
Session: ***@ODSTEST.NWC.EDU
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:***@01CA8872.BBCD8CA0]<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: ***@yahoogroups.com [mailto:***@yahoogroups.com] On Behalf Of John Dorlon
Sent: Friday, March 22, 2013 2:47 PM
To: ***@yahoogroups.com
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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of Madvig, Daniel B
Sent: Friday, March 22, 2013 2:44 PM
To: '***@yahoogroups.com'
Subject: [toad] RE: What does it all mean?

Nope, no filter.

[cid:***@01CE270F.58A4A160]

Daniel B Madvig
Campus Technologies

[cid:***@01CA8872.BBCD8CA0]<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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of John Dorlon
Sent: Friday, March 22, 2013 2:06 PM
To: ***@yahoogroups.com<mailto:***@yahoogroups.com>
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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of Madvig, Daniel B
Sent: Friday, March 22, 2013 1:39 PM
To: '***@yahoogroups.com'
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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of Dennis Paulus
Sent: Friday, March 22, 2013 12:41 PM
To: ***@yahoogroups.com<mailto:***@yahoogroups.com>
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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of Madvig, Daniel B
Sent: Friday, March 22, 2013 12:56 PM
To: '***@yahoogroups.com'
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:***@01CA8872.BBCD8CA0]<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.

John Dorlon

2013-03-22 20:17:11 UTC

Permalink

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: ***@yahoogroups.com [mailto:***@yahoogroups.com] On Behalf Of Madvig, Daniel B
Sent: Friday, March 22, 2013 3:12 PM
To: '***@yahoogroups.com'
Subject: [toad] RE: What does it all mean?

----------------------------------
Session: ***@ODSTEST.NWC.EDU<mailto:***@ODSTEST.NWC.EDU>
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:***@01CA8872.BBCD8CA0]<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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of John Dorlon
Sent: Friday, March 22, 2013 2:47 PM
To: ***@yahoogroups.com<mailto:***@yahoogroups.com>
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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of Madvig, Daniel B
Sent: Friday, March 22, 2013 2:44 PM
To: '***@yahoogroups.com'
Subject: [toad] RE: What does it all mean?

Nope, no filter.

[cid:***@01CE2710.556140C0]

Daniel B Madvig
Campus Technologies

[cid:***@01CA8872.BBCD8CA0]<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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of John Dorlon
Sent: Friday, March 22, 2013 2:06 PM
To: ***@yahoogroups.com<mailto:***@yahoogroups.com>
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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of Madvig, Daniel B
Sent: Friday, March 22, 2013 1:39 PM
To: '***@yahoogroups.com'
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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of Dennis Paulus
Sent: Friday, March 22, 2013 12:41 PM
To: ***@yahoogroups.com<mailto:***@yahoogroups.com>
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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of Madvig, Daniel B
Sent: Friday, March 22, 2013 12:56 PM
To: '***@yahoogroups.com'
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:***@01CA8872.BBCD8CA0]<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.

Madvig, Daniel B

2013-03-22 20:35:40 UTC

Permalink

Yup, found it that way, too.

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

----------------------------------
Session: ***@ODSTEST.NWC.EDU
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:***@01CA8872.BBCD8CA0]<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: ***@yahoogroups.com [mailto:***@yahoogroups.com] On Behalf Of John Dorlon
Sent: Friday, March 22, 2013 3:17 PM
To: ***@yahoogroups.com
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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of Madvig, Daniel B
Sent: Friday, March 22, 2013 3:12 PM
To: '***@yahoogroups.com'
Subject: [toad] RE: What does it all mean?

----------------------------------
Session: ***@ODSTEST.NWC.EDU<mailto:***@ODSTEST.NWC.EDU>
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:***@01CA8872.BBCD8CA0]<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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of John Dorlon
Sent: Friday, March 22, 2013 2:47 PM
To: ***@yahoogroups.com<mailto:***@yahoogroups.com>
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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of Madvig, Daniel B
Sent: Friday, March 22, 2013 2:44 PM
To: '***@yahoogroups.com'
Subject: [toad] RE: What does it all mean?

Nope, no filter.

[cid:***@01CE2712.E1B42FE0]

Daniel B Madvig
Campus Technologies

[cid:***@01CA8872.BBCD8CA0]<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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of John Dorlon
Sent: Friday, March 22, 2013 2:06 PM
To: ***@yahoogroups.com<mailto:***@yahoogroups.com>
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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of Madvig, Daniel B
Sent: Friday, March 22, 2013 1:39 PM
To: '***@yahoogroups.com'
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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of Dennis Paulus
Sent: Friday, March 22, 2013 12:41 PM
To: ***@yahoogroups.com<mailto:***@yahoogroups.com>
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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of Madvig, Daniel B
Sent: Friday, March 22, 2013 12:56 PM
To: '***@yahoogroups.com'
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:***@01CA8872.BBCD8CA0]<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.

John Dorlon

2013-03-22 20:51:49 UTC

Permalink

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: ***@yahoogroups.com [mailto:***@yahoogroups.com] On Behalf Of Madvig, Daniel B
Sent: Friday, March 22, 2013 3:36 PM
To: '***@yahoogroups.com'
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: ***@ODSTEST.NWC.EDU<mailto:***@ODSTEST.NWC.EDU>
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:***@01CA8872.BBCD8CA0]<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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of John Dorlon
Sent: Friday, March 22, 2013 3:17 PM
To: ***@yahoogroups.com<mailto:***@yahoogroups.com>
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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of Madvig, Daniel B
Sent: Friday, March 22, 2013 3:12 PM
To: '***@yahoogroups.com'
Subject: [toad] RE: What does it all mean?

----------------------------------
Session: ***@ODSTEST.NWC.EDU<mailto:***@ODSTEST.NWC.EDU>
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:***@01CA8872.BBCD8CA0]<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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of John Dorlon
Sent: Friday, March 22, 2013 2:47 PM
To: ***@yahoogroups.com<mailto:***@yahoogroups.com>
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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of Madvig, Daniel B
Sent: Friday, March 22, 2013 2:44 PM
To: '***@yahoogroups.com'
Subject: [toad] RE: What does it all mean?

Nope, no filter.

[cid:***@01CE2714.B2670C10]

Daniel B Madvig
Campus Technologies

[cid:***@01CA8872.BBCD8CA0]<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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of John Dorlon
Sent: Friday, March 22, 2013 2:06 PM
To: ***@yahoogroups.com<mailto:***@yahoogroups.com>
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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of Madvig, Daniel B
Sent: Friday, March 22, 2013 1:39 PM
To: '***@yahoogroups.com'
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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of Dennis Paulus
Sent: Friday, March 22, 2013 12:41 PM
To: ***@yahoogroups.com<mailto:***@yahoogroups.com>
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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of Madvig, Daniel B
Sent: Friday, March 22, 2013 12:56 PM
To: '***@yahoogroups.com'
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:***@01CA8872.BBCD8CA0]<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.

Madvig, Daniel B

2013-03-22 21:14:24 UTC

Permalink

Walk the plank, ye scurvy dog!

And have a great weekend! I'll not die in the meantime (for as much as I have control over that).

Thanks for trying,

Dan

Daniel B Madvig
Campus Technologies

[cid:***@01CA8872.BBCD8CA0]<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: ***@yahoogroups.com [mailto:***@yahoogroups.com] On Behalf Of John Dorlon
Sent: Friday, March 22, 2013 3:52 PM
To: ***@yahoogroups.com
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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of Madvig, Daniel B
Sent: Friday, March 22, 2013 3:36 PM
To: '***@yahoogroups.com'
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: ***@ODSTEST.NWC.EDU<mailto:***@ODSTEST.NWC.EDU>
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:***@01CA8872.BBCD8CA0]<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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of John Dorlon
Sent: Friday, March 22, 2013 3:17 PM
To: ***@yahoogroups.com<mailto:***@yahoogroups.com>
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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of Madvig, Daniel B
Sent: Friday, March 22, 2013 3:12 PM
To: '***@yahoogroups.com'
Subject: [toad] RE: What does it all mean?

----------------------------------
Session: ***@ODSTEST.NWC.EDU<mailto:***@ODSTEST.NWC.EDU>
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:***@01CA8872.BBCD8CA0]<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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of John Dorlon
Sent: Friday, March 22, 2013 2:47 PM
To: ***@yahoogroups.com<mailto:***@yahoogroups.com>
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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of Madvig, Daniel B
Sent: Friday, March 22, 2013 2:44 PM
To: '***@yahoogroups.com'
Subject: [toad] RE: What does it all mean?

Nope, no filter.

[cid:***@01CE2718.50F45010]

Daniel B Madvig
Campus Technologies

[cid:***@01CA8872.BBCD8CA0]<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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of John Dorlon
Sent: Friday, March 22, 2013 2:06 PM
To: ***@yahoogroups.com<mailto:***@yahoogroups.com>
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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of Madvig, Daniel B
Sent: Friday, March 22, 2013 1:39 PM
To: '***@yahoogroups.com'
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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of Dennis Paulus
Sent: Friday, March 22, 2013 12:41 PM
To: ***@yahoogroups.com<mailto:***@yahoogroups.com>
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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of Madvig, Daniel B
Sent: Friday, March 22, 2013 12:56 PM
To: '***@yahoogroups.com'
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:***@01CA8872.BBCD8CA0]<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.

Dennis Paulus

2013-03-25 11:41:27 UTC

Permalink

Can you describe the table from SQL*Plus? If so, can you do that and send me the table definition, and I'll try to replicate it here. I don't need any data, just the definition. If you don't want to post it to the boards, you can send it to me privately at ***@quest.com<mailto:***@quest.com>.

Thanks,
Dennis

From: ***@yahoogroups.com [mailto:***@yahoogroups.com] On Behalf Of John Dorlon
Sent: Friday, March 22, 2013 4:52 PM
To: ***@yahoogroups.com
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: ***@yahoogroups.com [mailto:***@yahoogroups.com] On Behalf Of Madvig, Daniel B
Sent: Friday, March 22, 2013 3:36 PM
To: '***@yahoogroups.com'
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: ***@ODSTEST.NWC.EDU<mailto:***@ODSTEST.NWC.EDU>
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:***@01CA8872.BBCD8CA0]<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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of John Dorlon
Sent: Friday, March 22, 2013 3:17 PM
To: ***@yahoogroups.com<mailto:***@yahoogroups.com>
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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of Madvig, Daniel B
Sent: Friday, March 22, 2013 3:12 PM
To: '***@yahoogroups.com'
Subject: [toad] RE: What does it all mean?

----------------------------------
Session: ***@ODSTEST.NWC.EDU<mailto:***@ODSTEST.NWC.EDU>
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:***@01CA8872.BBCD8CA0]<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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of John Dorlon
Sent: Friday, March 22, 2013 2:47 PM
To: ***@yahoogroups.com<mailto:***@yahoogroups.com>
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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of Madvig, Daniel B
Sent: Friday, March 22, 2013 2:44 PM
To: '***@yahoogroups.com'
Subject: [toad] RE: What does it all mean?

Nope, no filter.

[cid:***@01CE292C.25504340]

Daniel B Madvig
Campus Technologies

[cid:***@01CA8872.BBCD8CA0]<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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of John Dorlon
Sent: Friday, March 22, 2013 2:06 PM
To: ***@yahoogroups.com<mailto:***@yahoogroups.com>
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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of Madvig, Daniel B
Sent: Friday, March 22, 2013 1:39 PM
To: '***@yahoogroups.com'
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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of Dennis Paulus
Sent: Friday, March 22, 2013 12:41 PM
To: ***@yahoogroups.com<mailto:***@yahoogroups.com>
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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of Madvig, Daniel B
Sent: Friday, March 22, 2013 12:56 PM
To: '***@yahoogroups.com'
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:***@01CA8872.BBCD8CA0]<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.

Madvig, Daniel B

2013-03-25 22:08:08 UTC

Permalink

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:***@01CA8872.BBCD8CA0]<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: ***@yahoogroups.com [mailto:***@yahoogroups.com] On Behalf Of John Dorlon
Sent: Friday, March 22, 2013 3:52 PM
To: ***@yahoogroups.com
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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of Madvig, Daniel B
Sent: Friday, March 22, 2013 3:36 PM
To: '***@yahoogroups.com'
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: ***@ODSTEST.NWC.EDU<mailto:***@ODSTEST.NWC.EDU>
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:***@01CA8872.BBCD8CA0]<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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of John Dorlon
Sent: Friday, March 22, 2013 3:17 PM
To: ***@yahoogroups.com<mailto:***@yahoogroups.com>
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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of Madvig, Daniel B
Sent: Friday, March 22, 2013 3:12 PM
To: '***@yahoogroups.com'
Subject: [toad] RE: What does it all mean?

----------------------------------
Session: ***@ODSTEST.NWC.EDU<mailto:***@ODSTEST.NWC.EDU>
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:***@01CA8872.BBCD8CA0]<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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of John Dorlon
Sent: Friday, March 22, 2013 2:47 PM
To: ***@yahoogroups.com<mailto:***@yahoogroups.com>
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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of Madvig, Daniel B
Sent: Friday, March 22, 2013 2:44 PM
To: '***@yahoogroups.com'
Subject: [toad] RE: What does it all mean?

Nope, no filter.

[cid:***@01CE297B.0A16DDB0]

Daniel B Madvig
Campus Technologies

[cid:***@01CA8872.BBCD8CA0]<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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of John Dorlon
Sent: Friday, March 22, 2013 2:06 PM
To: ***@yahoogroups.com<mailto:***@yahoogroups.com>
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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of Madvig, Daniel B
Sent: Friday, March 22, 2013 1:39 PM
To: '***@yahoogroups.com'
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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of Dennis Paulus
Sent: Friday, March 22, 2013 12:41 PM
To: ***@yahoogroups.com<mailto:***@yahoogroups.com>
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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of Madvig, Daniel B
Sent: Friday, March 22, 2013 12:56 PM
To: '***@yahoogroups.com'
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:***@01CA8872.BBCD8CA0]<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.

John Dorlon

2013-03-25 22:40:14 UTC

Permalink

Thanks for the update, Dan. I blame windows too!

- John

On Mar 25, 2013, at 5:30 PM, "Madvig, Daniel B" <***@nwc.edu<mailto:***@nwc.edu>> wrote:

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

<image001.jpg><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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of John Dorlon
Sent: Friday, March 22, 2013 3:52 PM
To: ***@yahoogroups.com<mailto:***@yahoogroups.com>
Subject: [toad] RE: What does it all mean?

Hmm

I have no idea why that table doesnt show up in the SB then. I dont see anything in the source that would explain it either. :(

Maybe a fresh brain Monday morning will help.

Sorry I dont have anything more helpful to tell you.

-John

From: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of Madvig, Daniel B
Sent: Friday, March 22, 2013 3:36 PM
To: '***@yahoogroups.com<mailto:***@yahoogroups.com>'
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: ***@ODSTEST.NWC.EDU<mailto:***@ODSTEST.NWC.EDU>
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

<image001.jpg><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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of John Dorlon
Sent: Friday, March 22, 2013 3:17 PM
To: ***@yahoogroups.com<mailto:***@yahoogroups.com>
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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of Madvig, Daniel B
Sent: Friday, March 22, 2013 3:12 PM
To: '***@yahoogroups.com<mailto:***@yahoogroups.com>'
Subject: [toad] RE: What does it all mean?

----------------------------------
Session: ***@ODSTEST.NWC.EDU<mailto:***@ODSTEST.NWC.EDU>
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

<image001.jpg><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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of John Dorlon
Sent: Friday, March 22, 2013 2:47 PM
To: ***@yahoogroups.com<mailto:***@yahoogroups.com>
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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of Madvig, Daniel B
Sent: Friday, March 22, 2013 2:44 PM
To: '***@yahoogroups.com<mailto:***@yahoogroups.com>'
Subject: [toad] RE: What does it all mean?

Nope, no filter.

<image002.png>

Daniel B Madvig
Campus Technologies

<image001.jpg><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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of John Dorlon
Sent: Friday, March 22, 2013 2:06 PM
To: ***@yahoogroups.com<mailto:***@yahoogroups.com>
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 doesnt show up.

From: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of Madvig, Daniel B
Sent: Friday, March 22, 2013 1:39 PM
To: '***@yahoogroups.com<mailto:***@yahoogroups.com>'
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 Im 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 Im not using the latest version of Toad, Im at least close with 11.6.1.6
dbm

From: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of Dennis Paulus
Sent: Friday, March 22, 2013 12:41 PM
To: ***@yahoogroups.com<mailto:***@yahoogroups.com>
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: ***@yahoogroups.com<mailto:***@yahoogroups.com> [mailto:***@yahoogroups.com] On Behalf Of Madvig, Daniel B
Sent: Friday, March 22, 2013 12:56 PM
To: '***@yahoogroups.com<mailto:***@yahoogroups.com>'
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 cant 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. Whats going on here?

FROM
ntrpcls nt,
nbrclsh nb

TGIF!!

Dan
Daniel B Madvig
Campus Technologies

<image001.jpg><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.