I want to exp & imp operations for APEX users from Oracle Database 12cR1 to 19c.
Data Pump Utility can't do that. When I try to export by using following parfile and command:
DUMPFILE=APEX.dmp LOGFILE=APEXEXPLOG.log SCHEMAS=APEX_PUBLIC_USER,APEX_040200,FLOWS_FILES DIRECTORY=APEXEXP CLUSTER=N EXCLUDE=STATISTICS expdp "'/ as sysdba'" PARFILE=/apexexp/apex_06012022.par
And when I try to traditional export, it also couldn't this operation:
exp \'/ as sysdba\' FILE=APEX_2.dmp LOG=APEXEXP_2log.log OWNER=APEX_PUBLIC_USER,APEX_040200,FLOWS_FILES STATISTICS=NONE
About to export specified users ... EXP-00010: APEX_040200 is not a valid username EXP-00010: FLOWS_FILES is not a valid username
How can I provide it?