Hi,
We imported a database dump into a blank database (Oracle 11.2.0) with Unicode AL32UTF8 character set. The actual character set of the database from where the dump was take is WE8MSWIN1252. This led to some loss of data.
ORA-12899: value too large for column "<COLUMN_NAME>" (actual: 36, maximum: 35)
I am trying to follow one document which seemed relevant (ORA-00904: : invalid identifier) but somehow can't find the table while running the statement : drop table semantics$
Please advise.
Regards.