Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Akilesh.

Asked: August 24, 2024 - 6:48 pm UTC

Last updated: August 29, 2024 - 2:30 am UTC

Version: 19C

Viewed 1000+ times

You Asked

1. I am trying to run a dbms_data pump Export and import on Schema level by creating a pricedure, also I have the neccessary Privileges on the database on Which I am Running like EXP_FULL_DATABASE and IMP_FULL_DATABASE,read/write/execute on the data_pump_dir diretory too.

2. I have exported the dump file using a filetype=> KU$_FILE_TYPE_DUMP_FILE and it has created 3/4 dumpfiles. This is in a user ABC.

3. So now im trying to import those dumpfiles to a different user XYZ using dbms_datapump.remap and im changing passing the parameter as my old_value=>'ABC' and new=>'XYZ'

4. Here when im runnig the import procedure in the user ABC to import the dump files to XYZ, im getting an erro as 'INVALID OPERATION' and the line number reffering to dbms_datapump.start_job.

5. The input im passing is my dumpfile and it looks like this 'my_dumpfile_%U.dmp'

Note: when running the import job, i couldn't use the add_file method to add the log file. So i ignoed addi g the log file.

So help me resolve this error, let me know if any further details required.

- akilesh

and Connor said...

Take a look at my version here

https://github.com/connormcd/misc-scripts/blob/master/clone_schema_v2.sql

and see if that helps.

Rating

  (1 rating)

Comments

A reader, August 29, 2024 - 4:40 pm UTC

Sure will check and get back with the update.. thanks a lot for your response..

More to Explore

Data Pump

All of the database utilities including Data Pump are explained in the Utilities guide.