Hello together,
for a Staging developing system in APEX we've 4 databases called apex11D, apex11T, apex11A and apex11P (D = Development, T =Test, A = Abnahme [german for acceptance], P = productive). All databases are running under Oracle DB 11.2.0.3 on different servers, the servers all have Oracle Linux 6 as OS.
On every database there is a schema which is called OPTIMADATA. When we do changes on the metaobjects structure of OPTIMADATA we're doing them on the development base apex11D first. Now I'm trying to find an automatic way, how I can export the changes of the medadata objects without the data to import them into the next level. The data is different on every level and that is intended!
I've found the way to generate an export dump with expdp with option flag "content=metadata_only" which shold be the correct one for me. But I've problems by the import because I want to import the metadata changes into the next level also for the existing objects.
An example:
At development base apex11D there is a table called T_PERSON. I modify this Table by adding some columns col10, col11 and col12. At test system apex11T the T_PERSON has the estate from apex11D without the added columns. Now I generate the export dump with "content=metadata_only" but I didn't found the option to Update the T_PERSON to add the added columns. The existing data in T_PERSON at test level has to be the same as before!
I hope you guys understand my explanation. Is there any way by using the expdp and impdp tool fo that way? As we've many tables (for about 1200) and many changes we've to implement I don't wanna do that all over sql scripts.
Thanks and regards,
Dave