Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Change Objects attribute to ORACLE_MAINTAINED to N

User_TK958Oct 8 2019 — edited Oct 10 2019

Hi,

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