Re: export & import data base without exp.exe & imp.exe

Lamjed wrote:

> Hi,
>
> can any one help me to export & import data base without exp.exe & imp.exe
>
> thanks
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.504 / Virus Database: 302 - Release Date: 24/07/2003

Export your data by spooling off insert statements. For example:

SELECT 'INSERT INTO table_name VALUES (' || column_1 .... FROM some_table;

But why? Is this an academic exercise or are you just trying to make a simple job difficult?

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)