Little questions about Export data function

[MadoshiNatsu]

Hi,

I often use the export data into a sql file of a table using a query because it generating the insert lines. Then I replay this script in another schema that have the same table to import data from source.

I would like to make a package or a function that will wrote in a sql file the same thing that your export data function.

There is my questions :

- How do you make the script ? Are you using the "exp.exe" function of oracle to export them with "insert/delete.."

I tried to make a macro when exporting data but it seem it doing nothing... Can I use macro to make the result of my first question ?

Hope I will have some answers

best regards,

MadoshiNatsu

 

[Bernhard S]

Hello MadoshiNatsu,
you could use one of the techniques described here for that: Ask Tom "Create Insert Statements Dynamically"

 

[MadoshiNatsu]

Hi Bernhard,

Thanks for your reply. I made something thanks your links given.