Hi, You should really consider going via the RPD because of the obvious error you’ve received. There are a host of errors and issues you will face if you still plan to use the logical SQL specifically around maintaining and enhancing your report. Try creating simple SQLs to achieve the densification and then model them…

You're almost there.. Yes you need to migrate the base tables along with the spatial metadata in user_sdo*

There is one ODBC function to reset the connection pool: {call NQSResetConnections('Database','Connection Pool');} I have not tried it but I assume it will reset it for all the users. Kindly test it out thoroughly before finalizing the design. Alternate approach would be to use a write-back to store the schema details in…

I'm not sure if you have saved the data type of your columns as a default format. If yes, then please check /system/metadata/_datatype_formats (system-wide default for the data type) or check the subject area specific object (for system-wide default for the specific column) It would be better to have them recreated in the…

Use ":password"