What are the challenges you face when working across database platforms? Take the survey
Options
oracle tablespace names
Arie
Posts: 1 New member
how to handle differences of tablespace names between environments? for example env environment has a single tablespace while prod has specific...when pulling a dev table sql to prod how to change the tablespace name (not manually)
Tagged:
Answers
I'm afraid I cannot think of a solution for your issue, there aren't any comparison options for this as we anticipate parity between environments. The filtering also isn't helpful as it's based on object definitions and in your instance the tablespace will be an attribute of the object rather than the object itself.