When running the SDO_Migrate on synonyms, I am getting the following error. The synonym exists for table and an entry exists in user_sdo_geom_metadata for the table.
Error occurs when executing the SQL string:
"execute sdo_migrate.to_current('<tablename>')"
ORA-13261: geometry table <tablename> does not exist
I found that the original schema (say A) which contained this table can run the SDO_Migrate.to_current, however, when I created a public synonym and tried to run the sdo migrate from the new schema (Say B), I am getting this error. All grants have been given to the new Schema (B). Also the synonym name and the tablename are the same.
The new schema (B) does not have any tables, nor does it have privileges to create new tables. I cannot change the schema behavior, however I need a way to migrate the table from the new schema (B).
Any required grants on the table can be given to new Schema, however the new schema cannot create or alter tables.