dynamobi/dynamobi — Issue #327: [EXT-11] misleading error message from do_for_entire_schema if schema exists but no tables
Author: dynamobi-build
Created: 2011-12-30 02:31:15+00:00
State: open
Labels: Applib, EXT

[reporter="ksecretan", created="Mon, 6 Jun 2011 15:32:05 -0500 (GMT-05:00)"]
0: jdbc:luciddb:rmi://localhost> CREATE SCHEMA FOODMART;

No rows affected (0.085 seconds)

0: jdbc:luciddb:rmi://localhost> CALL APPLIB.COMPUTE_STATISTICS_FOR_SCHEMA('FOODMART');

Error: Schema 'FOODMART' could not be found (state=,code=0)

----

Use DBA_SCHEMAS instead of DBA_TABLES for schema existence check.