Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: export table data

Re: export table data

From: Jared Still <jkstill_at_gmail.com>
Date: Wed, 1 Nov 2006 15:22:18 -0800
Message-ID: <bf46380611011522s3f5e3c14l92aab7f0a752327e@mail.gmail.com>


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
Received on Wed Nov 01 2006 - 17:22:18 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US