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 email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
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_nameThen import the table into another database:
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.