Posts Tagged ‘tips and tricks’

Vertical text in javascript

I’ve just recently been given a Word document with a mock up of a report that I needed to reproduce in HTML. Well, i looked at various options like using transforms, rotate, DX filters in IE, but none of them worked properly, or without major headaches. Whilst searching around, I found a JS library called […]

Share
More »

Oracle Apex sticky hide and show regions

Recently had a need for sticky hide/show regions in Oracle Apex 4.1. Here’s how I done it. Add the jQuery cookie library to your page template Added the following line to the hide and show region template ?View Code HTML1 $.cookie(‘#REGION_STATIC_ID#’,$(‘##REGION_STATIC_ID# .hide:first:visible’).length);return false; So my hide and show region template looks like this: ?View Code […]

Share
More »

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

Share
More »

Tablespace does not exist

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? […]

Share
More »

Switch to our mobile site