Database Utilities (MOSC)

MOSC Banner

Export data from one table and import it to another table

edited Oct 8, 2009 12:40AM in Database Utilities (MOSC) 7 commentsAnswered
 I need to copy the data from one table in the server to another table with different table name in another server.

I have exported the table to a dump file. Then I scp the dump file to the other server. When I try to import it, it complains that the table name cannot be found in the export file. Can I not import data to a table with different table name?

What other ways can I achieve my objectives? Thanks.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center