Category database

bash, database, datapump, export, script, shell

DataPump — Export & Import Scripts

Use these 2 scripts together and you should be good to go… Here’s the DataPump Export Script Here’s the DataPump Import Script

Matt
August 3, 2012
2 Comments

Automatic Diagnostic Repository (ADR), bash, database

Purging the Automatic Diagnostic Repository (ADR)

Matt
June 12, 2012

bash, database, dbms_metadata, dbms_xmlgen, oracle, xml

Quick Demo to get MetaData & Data in XML

Here’s a quick demo to show off DBMS_METADATA and DBMS_XMLGEN APIs in the Oracle Database…enjoy

Matt
May 29, 2012

ASM, bash, database, dbfs, script, shell

Setup DBFS and mount DBFS

For those who don’t know what DBFS (DataBase FileSystem) is, here’s a little snippet: The Oracle Database File System (DBFS) enables the database to be used as a POSIX-compatible file system on Linux. This feature includes a PL/SQL package on…

Matt
May 22, 2012

ASM, database, linux, oracle, shell, vbox, VirtualBox

Add ASM Disks to VirtualBox

Thought I’d share some VBox goodness. Adding additional disks to VBox is simple with the following scripts From the VBox host: Once the VBox guest is fired up ssh into the guest via port forwarding (you’re port forwarding aren’t you?…