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 [...]

Question: I’m testing an import for one customer and while importing the database dump file with Data Pump I’m getting the following error: IMP-00017: following statement failed with ORACLE error 959: IMP-00003: ORACLE error 959 encountered ORA-00959: tablespace ‘_$deleted$24$0′ does not exist How do I remove the impdp message that the tablespace does not exist? [...]