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..
Blucel is a software consultancy specialising in Oracle and the Internet. We are currently accepting commisions