Oracle Database Discussions

Hello,

There are around 5 schemas on my Oracle database (version 19c) that I want to export using expdp utility and have followed the below steps while exporting data from my_schema:

1. sqlplus / as sysdba
2. create directory prf_dir as '/home/oracle/Export_Full';
3. grant read, write on directory prf_dir to prf_schema;
4. grant datapump_exp_full_database to prf_schema;
5. exit
6. expdp prf_schema/Password1@pdb_1 DIRECTORY=prf_dir DUMPFILE=prf_schema_dump.dmp LOGFILE=prf_schema_dump.log schemas=prf_schema;

But I am getting below errors:

ORA-39002:  invalid operation
ORA-39070: Unable to open the log file
ORA-39087: directory name prf_dir is invalid.

Prior check:

1. I have checked the valid directories using dba_directory and could see my directory over there.
2. I have checked permission on the path /home/oracle/Export_Full and it's 777.
3. Prior to this, I performed the same activity for another schema which is app_schema in the same path and for that, it got successfully executed with the steps I mentioned above but when trying to do the same thing by just changing the schema name it throws this error.

This I was trying individually for each schema but I need to take export of all schemas at once. I tried searching on other platforms where I got the command
expdp SYS/Password@pdb_1 DIRECTORY=prf_dir DUMPFILE=prf_schema_dump.dmp LOGFILE=prf_schema_dump.log schemas=schema1, schema2, schema3;

But when I am trying to login using SYS user it is throwing error as ```!@pdb_1 event not found``` error.