Pages

Wednesday, October 14, 2015

Toad Version Problem

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




Oracle Version:


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

NLSRTL Version 11.2.0.3.0 - 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
FROM SYS.DBA_TAB_COLS c
WHERE OWNER = :own
AND   USER_GENERATED = 'YES'
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