I want to export data from a single data table to a .dat file. Also I want to then import the data from the .dat...
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
file into another database's data table. Both source and destination tables have same design. How can I do this?
You can use Oracle's export/import utilities. First, export just the table as follows:
exp userid=system@source file=table.dat tables=table_name
imp userid=system@dest file=table.dat tables=table_name
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.