Oracle imp and exp commands

oracle unix sqlplus exp imp
Vijay picture Vijay · Jul 7, 2011 · Viewed 12.8k times · Source

Normally when i have to take a backup of of a database on unix, i do,

exp DBUSER/DBPSW@INST file=xxx.dmp

or load from a dump 

imp DBUSER/DBPSW@INST file=xxx.dmp

my question here is :

  1. how can we take a backup of a single table
  2. how can we import the data backup from the dump into a single table.
  3. how can we disable the constraints when taking a backup

I rarely do these when required.some times i need to do the above mentioned things but instead because i donot know i take the complete backup of all the table and load it. does anybody know how we can do it?

Answer

maximdim picture maximdim · Jul 7, 2011

You can list tables you want to export or import in your command line as 'tables=...' Or run exp/imp interactively and it will ask you for list of tables. Here is a good FAQ

Related questions

Connect to Oracle DB using sqlplus

I am using below command in Unix environment to connect to Oracle database: sqlplus test/test@'(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=hostname.com )(PORT=1521)))(CONNECT_DATA=(SID=mysid))' But I am getting below error: Use SQL*…

Read More
SqlPlus SP2-0734: Error

I am new to using SqlPlus but not new to using SQL, and I get the following error after writing this in my editor and attempting to run the script that I wrote. All of this appears to be valid …

Read More
ORA-00060: deadlock detected while waiting for resource

I have a series of scripts running in parallel as a nohup on an AIX server hosting oracle 10g. These scripts are written by somebody else and are meant to be executed concurrently. All the scripts are performing updates on …

Read More