Questions tagged [data-pump]
The data-pump tag has no usage guidance.
5
questions
0
votes
1
answer
524
views
Oracle database schema export
I'm trying to run a schema export through expdep on an oracle database:
expdp somedatabase/something directory=EXP_DIR schemas=someschema dumpfile=dumpfile.dmp logfile=logfile.log
The above command (...
- 535
1
vote
1
answer
3k
views
Copying local files to RDS
How do I copy/upload my dump files from local system to RDS instance. The documentation talks about creating a dump from sample table to data_pump_dir and copying the same to another file. However I ...
- 21
14
votes
2
answers
164k
views
How to execute datapump commands as sysdba from remote machine
I would like to know the syntax to call datapump commands (expdp/impdp) logged as 'sys as sysdba' from a remote machine.
I know that when logged on the machine which runs the database, I can use :
...
- 293
1
vote
2
answers
224
views
How do I re-execute a skipped section in Oracle Data Pump?
I did a start_job=skip_current on a large import because I thought it was hanging on some bad data. It turns out it was just a really large index so I'd like to re-run it but I don't want to do the ...
- 243
0
votes
2
answers
4k
views
How to get a consistent export with Oracle Data Pump?
I'm trying to obtain a consistent export (with data pump) from an schema emulating the CONSISTENT=Y. Currently I'm executing data pumb in this way:
'/ AS SYSDBA' schemas=arrels dumpfile=arrels.dmp ...
- 1,382