Count(*)ing nested tables
- From: "John Currier" <md4curvs@xxxxxxxxx>
- Date: 25 Jul 2005 06:23:34 -0700
In SchemaSpy I attempt to provide row counts for every table to help in
the analysis of a schema, especially when evaluating indexes.
I had a user submit a "feature request" that the code that does this
count blows up when it tries to evaluate a table with nested tables. I
don't know anything about nested tables (I assume they're
Oracle-specific), but the error message is:
ORA-22812: cannot reference nested table column's storage table
I'm doing a simple "select count(*) from whatever". I've modified the
code to not fail when it can't determine the count, but is there
anything more I can do?
Thanks,
John Currier
http://schemaspy.sourceforge.net
.
- Follow-Ups:
- Re: Count(*)ing nested tables
- From: Bill Karwin
- Re: Count(*)ing nested tables
- From: --CELKO--
- Re: Count(*)ing nested tables
- Prev by Date: Re: Oracle Isolation Level and ADO
- Next by Date: Re: Count(*)ing nested tables
- Previous by thread: Oracle Isolation Level and ADO
- Next by thread: Re: Count(*)ing nested tables
- Index(es):