Category: Oracle-Utilities

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

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

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

If you want to update your select result in toad, just add the ROWID is your select statement. Once you select the records with ROWID then you can edit/update your result grid. You can also see the Green indicator as shown in the below screenshot that means your records are editable.

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.