Datapump out from all pdb's in one go? — by Richard Harrison on

0 comment

Again inspired by an otn question i came up with a solution thats perhaps a useful concept to so...

The wallet, the password and the odd requirement — by Richard Harrison on

0 comment

An otn question this week had the requirement to allow a client account to be able to run "...

How oracle resolves names.........an analogy — by Richard Harrison on

1 comment

Ever been asked what the hell it is you do at work and tried to relate it to everyday life? ...

VIEWS_AS_TABLES in 11g and even 10g ??? — by Richard Harrison on

0 comment

12c introduced a new feature for datapump which allowed you to extract a 'view' as if it...

Pointless method of pfile recreation? — by Richard Harrison on

0 comment

I've got a disaster recovery situation for you - pretty unlikely and pretty pointless but it...

Datapump, partitioning and parallel — by Richard Harrison on

2 comments

One of our systems is reasonable large (~2TB) and has 4 tables that have over a billion rows eac...