nick.mcdermaid (2/7/2013)
As already suggested, the issue is because a column, table or alias name is longer than 30 characters, which is the Oracle size limit on object names.It is nothing to do with the size of a Varchar field.
I guess the wizard is trying to create the target table based on the source table, and a column or table name is too long.
Nick is right. ORA-00972 refers to a column name longer than 30 characters, fix that.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.