issue on pump export using sqlcl
Additional Information: ORA-06550: line 44, column 81:
PLS-00201: identifier 'DBMS_FLASHBACK' must be declared
ORA-06550: line 44, column 5:
PL/SQL: Statement ignored
the statement used is
dp export -ve TRUE -
-filesize 6GB -
-d dump_dir -
-f export_file.dmp -
-logdirectory dump_dir_log -
-logfile log-export.log -
-schemas vente -
-reusefile TRUE -
-flashbackscn TRUE -
-version latest
if -flashbackscn TRUE is not used , it will work fine
dp export -ve TRUE -
-filesize 6GB -
-d dump_dir -
-f export_file.dmp -
-logdirectory dump_dir_log -
-logfile log-export.log -
-schemas vente -
-reusefile TRUE -
-version latest
sqlcl version
Oracle SQLDeveloper Command-Line (SQLcl) version: 24.3.1.0 build: 24.3.1.311.1631
SQL> select banner_full from v$version;
Oracle Database 23ai Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
Version 23.5.0.24.07
..