Sample Header Ad - 728x90

Oracle 12c to 19c Internal Schema Export & Import

0 votes
1 answer
7076 views
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?
Asked by jrdba123 (29 rep)
Jan 6, 2022, 01:06 PM
Last activity: Mar 7, 2023, 05:07 PM