Oracle Data Pump (expdp and impdp)

Data Pump Export is a utility for unloading data and metadata into dump file. The same exported dump file can be imported only by Data Pump Import utility. With the help of this Data Pump Export we can export the data of one machine and import into another machine. Dump File : The dump file set is made up of one or more disk files that contain table data, database object metadata, and control information. The files are written in

» Read more

Toad – SQLNET Editor and TNS Names Editor Disabled

While trying to connect to a Database using Toad with TNS, Even the TNS entry is created in tnsnames.ora file under Oracle Home\NETWORK\ADMIN Issue 1: SQLNET Editor and TNS Names Editor Disabled as shown in below snapshot  Issue 2: Not able to find the TNS Name in the dropdown as shown in below snapshot Cause: TNS entry missing in the environmental variables Resolution:  Go to environmental variables and create a new variable Name as “TNS_ADMIN” and set the value as  Oracle Home\NETWORK\ADMIN

» Read more

Oracle – Import data from CSV file using SQL Loader

In this post we will see how we can transfer the data from CSV to oracle database using SQL Loader. SQL Loader is a bulk loader utility used for moving data from external files into the Oracle database. One can use SQL Loader utility to transfer the data for high performance. Syntax: sqlldr username@server/password control=control_file.ctl sqlldr username/password@server control= control_file.ctl Exmaple: Let‘s take a CSV file named as test_data.csv First we need to create a table where we want to transfer

» Read more

Oracle – Toad – Add an external tool to the tool bar

Click on the “configure” button as below Toad Tool Option dialog box will open then click on the “Auto add…” button Below screen will open after that you can selecte the listed program ( as we selected Notepad) then click “OK” Now you can check the your selected program add in the tool bar   Similarly, you can add your desired program here.

» Read more