I wish to copy a table in one oracle database to a different using Java. (JDBC APIs) the 2 databases are disconnected from one another (i,e) they don't have any DBlinks pointing to one another.
can someone specify the best method of doing this.
These tables is going to be getting between 30,000 to 50,000 rows with 10 posts
open an association to database 1 open another link with database 2 read from database 1 into java structures write into database 2 from java structures.
or make use of an available out of the box utility.