Questions tagged [data-pump]
5 questions
14
votes
2 answers
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 :
expdp \"/ as sysdba\"
However, I cannot find how to…
Denis R.
- 293
- 1
- 2
- 6
1
vote
2 answers
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 entire import again. I know I can have it skip…
Brian Deterling
- 243
- 2
- 6
1
vote
1 answer
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 could no find out how to get dump I have locally…
Pacchy
- 21
- 1
- 4
0
votes
2 answers
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 nologfile=y flashback_time='2009-06-03 12:00:02'…
FerranB
- 1,362
- 2
- 18
- 28
0
votes
1 answer
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 (although edited for the purpose of posting this…
Jarmund
- 535
- 1
- 6
- 16