Skip to Main Content
Forums

LiveLabs & Workshops

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!

How to Automate the output files created to local drive folder/share drive folder/share point portal

CA SatishApr 8 2022

Hi Experts, In PBC when the extracts gets created from Data Exchange/Mgt the file created with Input folder. I want those files automatically created either in my local drive folder or share drive folder or in share point portal.
Since daily i need to move manually from Inbox folder to specific location. Is there is way where i can automate the target location, so that when ever the extracts gets created it move to that specific target location.
Thanks in advance.

Comments

PoorbandTony
Answer

Nevermind - figured out that it was SQL Developer being it's usual self, and not committing the changes to the view when I updated the expression in the UI.
Instead ran the following and it's stuck this time:
ALTER MATERIALIZED VIEW myview REFRESH NEXT SYS_EXTRACT_UTC(SYSTIMESTAMP)+1/1440;

Marked as Answer by PoorbandTony · Nov 3 2021
1 - 1

Post Details

Added on Apr 8 2022
#epm, #hyperion, #oracle-cloud-infrastructure-fundamentals, #pbcs
0 comments
125 views