Hi Everyone,
As part of deployment tool, We have a Unix script which uses the OEDQ APIs to export the project before importing updated project for backup purpose.
Which is taking lot of time.To expedite the process, we are exploring other options as well, One of which we could thought of is :
Renaming the Project Name ( Node Name) by updating the relevant row of director.dn_xtree which will be matter of few seconds.
Now my questions are as following ( for OEDQ 8.1.x , 9.x and 12.x)
1. Is it allowed by Oracle to update the row in the dn_xtree table?
2. will there be any contractual breach if we apply DML statement on dn_* tables? or is there any other issues/breach of using DMLs?
3. is it allowed to create the tables or any other oracle objects ( which obviously will not disturb any other existing OEDQ - Product Tables) in the Schema?
( can PL/sql code be written for any data transformation process? can Trigger be written for any audit log activities?)
Quick response would be appreciated!
(Please help me in pointing to the right page where I can put this query forward if this forum is not the right forum for this query)
Thanks in Advance,
Raj