On 11/1/06, crcbedoy@xxxxxxxxxxxxxxxxx <crcbedoy@xxxxxxxxxxxxxxxxx> 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
6) 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
