Dear,
I have deployed an application from client side which has been working fine. However, i am facing issue regarding database user backup.
So now i am looking the way to export database user from Apex application.
Thanks.
❇️ OrclQA.Com is a question and answer forum for programmers.
❇️ Here anyone can ask questions and anyone can answer to help others.
❇️ It hardly takes a minute to sign up and it is 100% FREE.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
OrclQA.Com is a question and answer forum for programmers.
Here anyone can ask questions and anyone can answer to help others.
It hardly takes a minute to sign up and it is 100% FREE.
Vinish Kapoor
You can export the user/schema using the dbms_datapump utility package. Check the below example:
Also, create a database directory object before running the procedure:
Then run the following program; it will export the ERP schema. Configure the user/schema name accordingly.
Note: Your Oracle Apex database user must have the required privileges to export a schema.
Hussain
Thanks for the update.
But how i will be calling you code in apex runtime in order to execute you provided script.
Can you please elaborate further more.
Thanks.
Vinish Kapoor
Create a database procedure of the above PL/SQL code, then call it using any process or dynamic action in Oracle Apex.