dbTalk Databases Forums  

copy table data to another database programatically

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss copy table data to another database programatically in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Sean Nakasone
 
Posts: n/a

Default copy table data to another database programatically - 01-09-2008 , 05:51 PM






anyone have code snippets to copy table contents from one database to
another? i usually use toad and make 2 database connections, then copy
data across, but i really would like to find more automated way.

Reply With Quote
  #2  
Old   
Ana C. Dent
 
Posts: n/a

Default Re: copy table data to another database programatically - 01-09-2008 , 10:06 PM






Sean Nakasone <seannakasone (AT) yahoo (DOT) com> wrote in
news:Pine.WNT.4.64.0801091348580.2936 (AT) ctfanxnfba (DOT) unjnvvnaryrpgevp.arg:

Quote:
anyone have code snippets to copy table contents from one database to
another? i usually use toad and make 2 database connections, then copy
data across, but i really would like to find more automated way.

So you'd like Oracle to read your mind to discern which 2 databases are
involved, differentiate between source & target DB, & automagically
moved the contents of the desired table for you without you doing anything
but think about what should be done.
RIGHT?

Now that would be a great example of AUTOMATION!

I apologize for Oracle for forcing to take wasteful actions to move data.


Reply With Quote
  #3  
Old   
Ana C. Dent
 
Posts: n/a

Default Re: copy table data to another database programatically - 01-09-2008 , 10:06 PM



Sean Nakasone <seannakasone (AT) yahoo (DOT) com> wrote in
news:Pine.WNT.4.64.0801091348580.2936 (AT) ctfanxnfba (DOT) unjnvvnaryrpgevp.arg:

Quote:
anyone have code snippets to copy table contents from one database to
another? i usually use toad and make 2 database connections, then copy
data across, but i really would like to find more automated way.

So you'd like Oracle to read your mind to discern which 2 databases are
involved, differentiate between source & target DB, & automagically
moved the contents of the desired table for you without you doing anything
but think about what should be done.
RIGHT?

Now that would be a great example of AUTOMATION!

I apologize for Oracle for forcing to take wasteful actions to move data.


Reply With Quote
  #4  
Old   
Ana C. Dent
 
Posts: n/a

Default Re: copy table data to another database programatically - 01-09-2008 , 10:06 PM



Sean Nakasone <seannakasone (AT) yahoo (DOT) com> wrote in
news:Pine.WNT.4.64.0801091348580.2936 (AT) ctfanxnfba (DOT) unjnvvnaryrpgevp.arg:

Quote:
anyone have code snippets to copy table contents from one database to
another? i usually use toad and make 2 database connections, then copy
data across, but i really would like to find more automated way.

So you'd like Oracle to read your mind to discern which 2 databases are
involved, differentiate between source & target DB, & automagically
moved the contents of the desired table for you without you doing anything
but think about what should be done.
RIGHT?

Now that would be a great example of AUTOMATION!

I apologize for Oracle for forcing to take wasteful actions to move data.


Reply With Quote
  #5  
Old   
Ana C. Dent
 
Posts: n/a

Default Re: copy table data to another database programatically - 01-09-2008 , 10:06 PM



Sean Nakasone <seannakasone (AT) yahoo (DOT) com> wrote in
news:Pine.WNT.4.64.0801091348580.2936 (AT) ctfanxnfba (DOT) unjnvvnaryrpgevp.arg:

Quote:
anyone have code snippets to copy table contents from one database to
another? i usually use toad and make 2 database connections, then copy
data across, but i really would like to find more automated way.

So you'd like Oracle to read your mind to discern which 2 databases are
involved, differentiate between source & target DB, & automagically
moved the contents of the desired table for you without you doing anything
but think about what should be done.
RIGHT?

Now that would be a great example of AUTOMATION!

I apologize for Oracle for forcing to take wasteful actions to move data.


Reply With Quote
  #6  
Old   
shakespeare
 
Posts: n/a

Default Re: copy table data to another database programatically - 01-11-2008 , 03:24 AM




"Sean Nakasone" <seannakasone (AT) yahoo (DOT) com> schreef in bericht
news:Pine.WNT.4.64.0801091348580.2936 (AT) ctfanxnfba (DOT) unjnvvnaryrpgevp.arg...
Quote:
anyone have code snippets to copy table contents from one database to
another? i usually use toad and make 2 database connections, then copy
data across, but i really would like to find more automated way.
Look at database links. Together with the answer to your previuos question,
it will put you in the right direction.

Shakespeare




Reply With Quote
  #7  
Old   
shakespeare
 
Posts: n/a

Default Re: copy table data to another database programatically - 01-11-2008 , 03:24 AM




"Sean Nakasone" <seannakasone (AT) yahoo (DOT) com> schreef in bericht
news:Pine.WNT.4.64.0801091348580.2936 (AT) ctfanxnfba (DOT) unjnvvnaryrpgevp.arg...
Quote:
anyone have code snippets to copy table contents from one database to
another? i usually use toad and make 2 database connections, then copy
data across, but i really would like to find more automated way.
Look at database links. Together with the answer to your previuos question,
it will put you in the right direction.

Shakespeare




Reply With Quote
  #8  
Old   
shakespeare
 
Posts: n/a

Default Re: copy table data to another database programatically - 01-11-2008 , 03:24 AM




"Sean Nakasone" <seannakasone (AT) yahoo (DOT) com> schreef in bericht
news:Pine.WNT.4.64.0801091348580.2936 (AT) ctfanxnfba (DOT) unjnvvnaryrpgevp.arg...
Quote:
anyone have code snippets to copy table contents from one database to
another? i usually use toad and make 2 database connections, then copy
data across, but i really would like to find more automated way.
Look at database links. Together with the answer to your previuos question,
it will put you in the right direction.

Shakespeare




Reply With Quote
  #9  
Old   
shakespeare
 
Posts: n/a

Default Re: copy table data to another database programatically - 01-11-2008 , 03:24 AM




"Sean Nakasone" <seannakasone (AT) yahoo (DOT) com> schreef in bericht
news:Pine.WNT.4.64.0801091348580.2936 (AT) ctfanxnfba (DOT) unjnvvnaryrpgevp.arg...
Quote:
anyone have code snippets to copy table contents from one database to
another? i usually use toad and make 2 database connections, then copy
data across, but i really would like to find more automated way.
Look at database links. Together with the answer to your previuos question,
it will put you in the right direction.

Shakespeare




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.