Oracle Export and Import Database

Export/Import Data to Database

Export

C:\>EXP UserName/Password@DB FILE=Name_Of_Dump_File.dmp TABLES=Name_Of_Table_For_Export QUERY=\"Where_Clause\" LOG=Name_Of_Log_File.log

Import

C:\>IMP UserName/Password@DB FILE=Name_Of_Dump_File.dmp FROMUSER=UserName_In_DB_Old TOUSER=UserName_In_DB_New TABLES=Name_Of_Table_For_Import IGNORE=Y CONSTRAINTS=N LOG=Name_Of_Log_File.log