We have a problem with creating a user through a script.
All objects related to this schema creation / users / tables / ... are considered with ORACLE_MAINTAINED = Y
Only we want to modify this parameter in order to make it possible to export via DataPump. Exporting with the conventional EXPORT tool is possible but not desired.
Could anyone tell me how to set these data and objetcs as non-system objects? (oracle_maintained=N)
Do we need to recreate users to work around this problem?
The database is in production but we did not know this new parameter related to Oracle 12.
thanks in advance
Let me just say that changing an oracle bit may have way more side effects than just letting Data Pump do something. I would not recommend that you change this bit.