We run our smaller java apps against a single database with multiple schemas. Not best practice for tuning, but it is a good use of resources for us and if any schema ever starts to have significant traffic/load, we break them off into their own database. Most of these apps run at less than 1% [...]
Archive for the ‘Import / Export’ Category
Schema refresh script
Posted in Import / Export, Script / Automation, tagged data pump, refresh, schema on March 30, 2010 | 5 Comments »
See all external directories in Oracle 10g
Posted in Import / Export on February 10, 2010 | Leave a Comment »
Took me a while to find this – I knew it had to be there but couldn’t find the view to query – so I thought I’d post this info. Every data pump article I found listed how to create a directory, but not how to make sure there wasn’t already one set up for [...]
