This content has been marked as final. Show 2 replies
I've never known an example of being able to move or recreate an Apex installation by exporting and importing the schemas associated with Apex. I think the relationships between schemas and objects are just too complicated for this to work easily.
I would have thought it would be easier to move the application you are developing against, but given I know nothing about Banner ERP, this may also not be an option. Also what I don't understand, given that you are trying to save any changes the developers make to their application in development, if you are refreshing the whole environment, aren't you also losing any changes the developers make at the database level. What about custom versions of DB objects they may be using for development purposes? How do you allow for this?
My preference for overcoming this would be rather than dropping the refreshed Apex environment at the schema level, but to do it at the Apex level. In order to automate this, and please you developers, there are command line options for exporting and importing applications that you can use to automate this process.
Applications can be exported through a tool Oracle supplies with the Apex download called APEXExport.class and as applications are simply sqlplus scripts, they can be imported using sqlplus command line. I haven't done this personally, but I think it would be possible.
Hope this helps.
Interesting problem and even more interesting suggestions.
It's a bit difficult and certainly not documented how you import an entire APEX environment using impdp. Not only are there multiple schemas, but there are cross-schema grants, grants on SYS objects, a handful of objects actually installed in SYS, and a number of system privileges.
As Andre suggests above, exporting the applications via the APEXExport command-line utility would be something to consider. You could entirely automate and script the export and import process. But this would not "recreate their development environment". This would miss any uploaded scripts, SQL Command history, uploaded files, etc.
Is it possible to do the reverse? That is - is it feasible to import the Banner data into your development environment? Sorry if this is a silly question.