There are a number of feature classes in our current Oracle 12c/19 GDB that are still SDE Binary or ESRI LOB that I'm running an impact analysis on for upgrading to ST_GEOMETRY.
When I tried to use the Migrate Storage tool, I received an underlying DBMS error (Error 000955). Upon having a trace run on the backend, we found that
The following statements encountered a error during parse:
SELECT * FROM SDE.SCH_DATASET
Error encountered: ORA-00942
--------------------------------------------------------------------------------
UPDATE MYSCHEMA.BIRDS_FEATURES SET SDE_CONVERSION = SDE.ST_GEOMETRY(:s1,:s2,:s3,:s4,:s5,:s6,:s7,:s8,:s9,:s10,:s11,:s12,:s13,:s14) WHERE SHAPE = :fid1
Error encountered: ORA-00600
So, it appears that SDE.SCH_DATASET doesn't exist (?) - is there a way to remedy this?
I think the preferred upgrade path (especially since it's what ESRI suggests) would be the Migrate Storage route. The other route (copy, paste as ST, then rename) while successful, could raise too many impact issues on possible roles inherited, privs, and any underlying tables that get updated from a different interface.