Tech, Oracle, user experience, coffee, design standards, and shameless ranting

Exporting an Oracle schema and uploading to Amazon S3

Question: How do I upload an oracle database schema file to s3 from linux command prompt

Answer: Download s3cmd

run ./s3cmd –configure

enter your access key and secret key when prompted

run your expdp command as oracle user

i.e. expdp sys/password schemas=rivpacs directory=DATA_PUMP_DIR dumpfile=rivpacs100309.dmp logfile=rivpacs100309.log

upload to your s3 bucket

i.e.

./s3cmd put rivpacs100309.dmp s://mybucketname

Voila. comments please..

Share

You can follow any responses to this entry through the RSS 2.0 feed.

Switch to our mobile site