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