Wednesday, October 14, 2015

Toad Version Problem

I use Oracle 11.2. version and have been using Toad version.

Oracle Version:

Oracle Database 11g Enterprise Edition Release - 64bit Production
PL/SQL Release - Production
CORE        Production
TNS for IBM/AIX RISC System/6000: Version - Production

NLSRTL Version - Production

Recently when I tried to export the DDL of a particular table from this menu:

Toad => Database => Export => Generate Schema script:

I got this error:

I tried to see how this error occurs: so I spooled sql into the screen and got this output:

Select table_name, column_name, data_type, data_type_mod, data_type_owner,
       decode(data_type, 'CHAR', char_length,
                         'VARCHAR', char_length,
                         'VARCHAR2', char_length,
                         'NCHAR', char_length,
                         'NVARCHAR', char_length,
                         'NVARCHAR2', char_length,
                         data_length) data_length,
       data_precision, data_scale, nullable, char_used
       , virtual_column
       , identity_column, column_id, hidden_column, default_on_null
and exists (select 'x'
            from  sys.DBA_ALL_TABLES t
            where t.table_name = c.table_name
            and   t.owner = c.owner)
order by table_name, internal_column_id

I tried looking information about the column 'USER_GENERATED' in the table DBA_TAB_COLS in the Oracle Documentation and got the below information:

This column is a Oracle 12c column and my Toad tried to look for this column as I use the wrong version of Toad.

Resolution: Toad and Oracle versions are incompatible. So Installed Toad 11.6 version. This will resolve the version discrepancy issue.

No comments:

Post a Comment