Skip to main content
Announcements
Qlik Connect 2025! Join us in Orlando join us for 3 days of immersive learning: REGISTER TODAY

Why does Replicate perform 'create directory' and 'drop directory' when using Oracle source endpoint?

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
OritA
Support

Why does Replicate perform 'create directory' and 'drop directory' when using Oracle source endpoint?

Last Update:

Jan 14, 2022 4:34:03 AM

Updated By:

OritA

Created date:

Jan 14, 2022 4:34:03 AM

As mentioned in the Replicate Users Guide, when using Replicate Log Reader to access the Redo logs, if you want Replicate to create and manage the Oracle directories, you need to grant the CREATE ANY DIRECTORY privilege to the user specified in the Oracle endpoint settings.  

When the task that uses the Oracle source endpoint starts, as part of the actions to test connection and check the privileges, Replicate performs ‘create directory’ and ‘drop directory’.

Note:

  • If the Oracle redo logs are on ASM the CREATE ANY DIRECTORY privilege is not required.

 

Product Component: Replicate using Oracle source endpoint

Labels (2)