We need to change data type (from NVARCHAR2 to VARCHAR2) of multiple columns in multiple tables in ArcSDE Oracle Geodatabase in ArcCatalog. Can anyone give some leads on how to do it in ArcCatalog?
Thanks in advance.
In practice, you can't, but I've done this with great success, globally, using SQL scripts.
We have been advised not to do the changes SDE registered featureclass using Toad as SDE defintion and Oracle definition of table will differ and it may lead to problem in future.
Is it possible for you to share the SQL script?
Retrieving data ...