I am using ODI 11g and able to execute a package, which can accept dynamic file names and schema name. This helps me to load multiple files with same structure in parallel.
However, I am getting issue when I try to drop logical schema at the end of the process usinf command "Drop Schema <schema name>", which I am creating before load process.
Error says that there are open connection, which are restricting the process to drop this schema. I have used disconnect command as well not it seems that connection still persists.
Can anyone advise how to forcefully drop the schema, which ODI have created in the memory?
Below is the error message
ODI-1228: Task drop_schema (Procedure) fails on the target XML connection book_xml.
Caused By: java.sql.SQLException: ODI-40700: Schema XSCHEMA cannot be dropped because it is referenced by one or more connections.
Can you try it out with 'standalone' schema ?
I have not testing this so you need to test and see if it satisfy your requirement.
FYI .. http://docs.oracle.com/cd/E17904_01/integrate.1111/e12644/appendix_xml_driver.htm