Oracle export commands
Oracle Export utility provides a number of options to help you export your data for different scenarios.
Here are some examples of the most common options that Developers/DBAs use.
Export based on a query:
You can use thess options to export selected rows from a table. For example below I am exporting all records from orders table where id < 300 .
exp scott/tiger file=test1.dmp query=\”where id \< 300\” tables=orders statistics=none
Note above that I am using escape character “\”. This will be needed when you run your export in Unix/Linux environment.
Continue reading
How to Install Oracle 11g Client
These instructions apply to Microsoft Windows only. When you install Oracle database software (try installing Enterprise edition), by default it also installs Oracle client. So if you have installed Oracle database software in your machine and want to connect to your local database you simply invoke the Oracle Client and given the necessary login credentials and you are in. You do not have to worry much about setting up your sql*net configuration as the installation process should usually take care of that if you chose to do so.
But for people who want to access an Oracle database that is not local and in a remote machine then you must need to install Oracle client in your machine. Even if You do not want to use SQL*Plus but want to use TOAD or SQL Developer or something like that, you still need Oracle client. Because internally these database access/development tools use Oracle clients software to connect to the target database.
So the most important thing to remember is, you must need Oracle client software in your machine if you want to connect to a remote Oracle database.
Installing Oracle client is not difficult. You just need to be a bit careful. The step by step instructions below should help you to install an Oracle Client in your machine. These instructions assume that you have downloaded the Oracle client software that you desire to install and unzipped the zip file into some folder. Continue reading
Recent Comments