Export/Import Specific Table in Oracle

Export/Import Specific Table in Oracle 

Step1: Export specific table/tables backup using following command

exp /password@db_name tables=  file=D:\cnsstnt.dmp  statistics=NONE log=D:\cnsstnt.log

Step2: Import specific table/tables backup using following command

imp /password@db_name fromuser= touser= tables=  file=D:\cnsstnt.dmp  statistics=NONE ignore=Y log=D:\cnsstnt.log

Cheers....