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

Without exp/imp, you still have a few options.

1. Look into Transportable Tablespaces. It has some restrictions, but could be the "easiest" to do.
2. Look at the SQL*Plus COPY command
3. Write your own routine (maybe in Perl) to pull from one database and push into another. Pretty easy to do actually.
4. Dump the data to a flat file (you can use SQL*Plus) and then use SQL*Loader to load the data.

I'm sure other options exist, including 3rd party apps.

HTH,
Brian

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

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"