grepSedExpDmp.txt
2005-08-13 Bikle
------------------

This file contains some syntax I use frequently to pull Oracle syntax
out of the Data Dictionary via use of some simple UNIX commands
run against an export file.

#! /bin/sh

# grepSedExp.txt

# Simple demo of pulling some syntax out of an Oracle Export file

exp system/manager rows=n statistics=none full=y

strings expdat.dmp | grep CREATE |  sed '/$/s/$/;/' | sed '1,$s/"//g' > expCREATE.txt
strings expdat.dmp | grep ALTER |  sed '/$/s/$/;/' | sed '1,$s/"//g' > expALTER.txt