Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Export SQL Format
> I'd like to know if there was a possibility to migrate a .DMP file to a
> plain/text file containing the SQL commands (CREATE TABLE, INSERT) with
> the EXP tool.
Bruno, the answer is both yes and no but I'm betting you are after the DDL only and this case the answer is yes. A good starting point and a process I have used in the past can be found here:
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:526422273445
Look for the conversation starting "how to get roles etc September 15, 2002 ", "Reviewer: T from USA "
Regards
Hex
Received on Tue May 31 2005 - 11:53:22 CDT