I have a great script that I inherited from the former dba here. It a c shell that reads an oracle dmp file and then (using sed ,grep and awk) creates seperate files with all of the ddl statements. So you have seperate files for creating tables, indexes etc. Which is wonderful when recreating instances. The problem that I have with it is that it doesn't handle modifying column defaults correctly. I was wondering if anyone else out there has a script that accomplishes the same thing. I know that I can use the indexfile option of the import but I then need to go edit the file and seperate everything out.

Thanks in advance!