Export and Import of data

Export and import of data

Oracle :-

Use SQL Developer a free tool from Oracle Corp.

https://www.oracle.com/au/tools/downloads/sqldev-v192-downloads.html

Go for Windows 64-bit with JDK 8 included

SQL Developer provides convenient wizards for exporting and importing metadata and data:

• To export metadata or data, or both, use the Export Wizard: click Tools, then Database Export.

• To import metadata or data, or both, use an appropriate method depending on how the material to be imported was created, or the format of the data to be imported. This method might be running a script file, or using the Data Import Wizard to import from a data file (such as a .csv file or a Microsoft Excel .xls file).

Refer: https://docs.oracle.com/cd/E17781_01/server.112/e18804/impexp.htm#ADMQS256

to use CLI or datapump technology is the better option.

refer: https://docs.oracle.com/cd/E17781_01/server.112/e18804/impexp.htm#ADMQS272