There are a lot of testing on the way how to create RCU schemas on ATP database with the normal Admin user, its look like that there are some tricks :)
I spend a lot of time debugging and testing the issue and the only way that preliminary is visible is that the process should be divided in a few steps.
- script generation
- execute generated scripts with sqlplus
- data load
hmm... after some time I take a look into Oracle Marketplace to check what kind of images with WebLogic are there... and guess what I find out?
WebLogic Standard Edition with the possibility to integrate with ATP database or Database on VM -( Database Service )
If Oracle has already Weblogic integration with ATP database, this means that all that I need is to find out how they manage to create such RCU schemas with admin user.
--- you can check full story for WebLogic creating using an image from Marketplace - here soon