Skip to content
Related Articles

Related Articles

How to Export data from Oracle Database?

Improve Article
Save Article
  • Last Updated : 25 Apr, 2022
Improve Article
Save Article

An Oracle database is a collection of data treated as a unit. The sole purpose of a database is to store and retrieve related data. This database contains data in the form of tables which are distributed in rows and columns. In our day-to-day life, we have to work on data and while working on databases we are required to import and export data. We can also import the data into the Oracle database but here in this article, we will see how to export data from the Oracle database.

Exporting data from Oracle Database

Here are a few steps through which we can export our table data into a text file which is in the form of comma-separated values.

Step 1: First Log in to your oracle database as you normally would.

Step 2: Click on option Utilities -> Data Load / Unload->Unload. You can Unload Data to XML and Text Files. Click on Unload to text option as shown in the below image.

Click-on-Unload-to-text-option

 

Step 3: Select the schema in which your table is present which you want to export and click on next. Here my table is present in the system schema so I have selected the system schema.

Select-the-schema

 

Step 4: Select the table name from the list of the table to export and click on next. Here I have already created gfg_demo_table to export so I have selected gfg_demo_table as shown.

Select-the-table-name

 

Step 5: Select the columns which you want to include in your file and click on next. You can also customize the column which you want to include or exclude in your file.

Select-the-columns

 

Step 6: Now select the checkbox to include column names in your file, check the customized details and click on Unload data option which is the final step of data export. 

Select-the-checkbox-to-include-column-names

 

Step 7: Data is successfully exported into a text file that consists of five columns as shown below. The first row consists of column names and other rows followed by its data in CSV format.

Exported-Data

 

My Personal Notes arrow_drop_up
Related Articles

Start Your Coding Journey Now!