Last post Oct 29, 2011 01:59 AM by chandana
Oct 23, 2011 04:44 AM|abdul4au|LINK
How to copy structure and data of table from one database to another database.
ex: i have prod db contains of 100's of tables pointing to service name and hosted in a server.
I have a test db where i want to copy some tables of prod. this test db is pointing to different service name and hosted in different server.
which is the simplest and quickest way to do that
Oct 23, 2011 04:07 PM|Lannie|LINK
If you are using Oracle 10g or 11g,
then DATAPUMP is the best way to move tables between database instances,
and if needed, remap data table to a new SCHEMA name.
Oct 24, 2011 01:35 AM|abdul4au|LINK
can you show some examples how to use datapump.
Oct 24, 2011 09:58 AM|Lannie|LINK
Oct 29, 2011 01:59 AM|chandana|LINK
you can use Oracle export and import commands. I haven't done in latest versions but I have done in 9i. It has exp and imp command. But you have to create the user(schema) related to taget database if it doesnt exist.
other solution is create link beween db and create the table using create table as method in sql.