Database Administration (MOSC)

MOSC Banner

invalid table


So, this table is invalid:


SQL> desc AZ.AZ_DIFF_RESULTS

ERROR:

ORA-24372: invalid object for describe

SQL> 


This is the construction of the table


SQL> r

 1 select column_name,data_type

 2   from dba_tab_columns

 3  where owner = upper('&p_owner') and table_name = '&p_table'

 4*  order by column_id asc

Enter value for p_owner: az

Enter value for p_table: AZ_DIFF_RESULTS

old  3:  where owner = upper('&p_owner') and table_name = '&p_table'

new  3:  where owner = upper('az') and table_name = 'AZ_DIFF_RESULTS'


COLUMN_NAME           DATA_TYPE

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

NAME               VARCHAR2

DISPLAY_NAME           VARCHAR2

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center