Hi

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.
What are the requirement ? do we need an online database or not to do this ?

Thanks for the tips

Regards

Bruno

> 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...D:526422273445

Look for the conversation starting "how to get roles etc September 15, 2002
", "Reviewer: T from USA "

Regards
Hex

See http://www.ddlwizard.com/ (formerly called Databee)

--
Terry Dykstra
Canadian Forest Oil Ltd.


"Bruno Guerpillon" <bruno.guerpillon@free.fr> wrote in message
news:429c2755$0$6725$626a14ce@news.free.fr...
> Hi
>
> 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.
> What are the requirement ? do we need an online database or not to do this
?
>
> Thanks for the tips
>
> Regards
>
> Bruno
>
>

Hi

Well, doing a common answer for Hex and Terry
Definitely, great links u gave me. It completly answer my question.
Got some work with that now

Regards

"Bruno Guerpillon" <bruno.guerpillon@free.fr> a écrit dans le message de
news: 429c2755$0$6725$626a14ce@news.free.fr...
> Hi
>
> 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.
> What are the requirement ? do we need an online database or not to do this
> ?
>
> Thanks for the tips
>
> Regards
>
> Bruno
>