1 Reply Latest reply on Oct 10, 2019 3:10 PM by Dean Gagne-Oracle

    Change Objects attribute to ORACLE_MAINTAINED to N

    2777865

      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

       

      Tom