Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Export SQL Format

Re: Export SQL Format

From: Hexathioorthooxalate <ruler_at_removemetoemail.clara.co.uk>
Date: Tue, 31 May 2005 17:53:22 +0100
Message-ID: <1117558382.914.0@echo.uk.clara.net>


> 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US