Sample Header Ad - 728x90

How to extract Procedure, Function, etc. Source Code from an Oracle Export

8 votes
3 answers
13843 views
I have generated an EXPDAT.DMP file of an Oracle database with the command: exp userid=usr/pass@db owner=own rows=n compress=n I then ran the following command to generate a file containing the 'Create Table...' statements: imp userid=usr/pass@db full=y indexfile=output.sql This is great for the Create Table statements, but I also want the Create Procedure / Create Function / Create View source code. I can see them there in the .DMP file, but I haven't found a way to extract them. Is it possible to extract this information from the EXPDAT.DMP file? Or will I need to use another method? The purpose is to have the source exportable to files that can be source-controlled.
Asked by MatthewToday (325 rep)
May 18, 2011, 11:10 PM
Last activity: Sep 24, 2016, 08:49 AM