how to import table dump into a schema using any tool
Posted on 2009-04-25
I have a table say Table_A in a schema say schema_A in database say database_A. I have other schema schema_B in database_B has same structured table Table_B. I need to move across the data across these two tables with ease using some tool like sqldeveloper or toad etc. I see a option for exporting the data into .csv, .xls etc files. But i do not see any option to import the .csv, .xls files though. Is there is a option i can do table import easily using tool. Any links, resources, ideas, sample code highly appreciated. Thanks in advance.