Re: export table data

On 11/1/06, crcbedoy_at_proteccion.com.co <crcbedoy_at_proteccion.com.co> wrote:
>
>
> I would like to know something, I need to export the table data from one
> instance to another, how can I do so?
>
>

You will need to provide more detail.

Do you just want to copy to a new database:

1. just a few tables
2. a schema
3. the whole database

How large is the data to be moved?

How will data be moved to the target?:

1. by Gig ethernet
2. by 100Meg ethernet
3. by 10Meg ethernet
4. T1
5. Fractional T1
6. DSL
7. Flash Drive
8. Dial up

You could:

export/import
replicate with Data Guard
replicate with Materialized views
restore a backup

   duplicate with rman
   restore hot backup, rman or file based

other choices I haven't thought of.

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l