Oracle Error ORA-53039: user-defined preference document: string already exists

Oracle Error Message

ORA-53039: user-defined preference document: string already exists

Reason for the Error

The insert operation failed because only one user-defined preference document is allowed.

Solution

To change an existing user-defined preference document, follow these steps:

1. Export the specified document to a file.

2. Delete the specified document from the repository.

3. Make changes to the exported document.

4. Insert the updated document into the repository. To add a new user-defined preference document, follow these steps:

1. Delete the specified document from the repository.

2. Insert the new document into the repository.