Pages

Thursday, November 27, 2008

ORACLE: How to Import

>imp userName_InWhich_BackUpTo_BeImported/password@orcl
Import file: ImportFileNameWithFullPath> fullPath\fileName.dmp
Enter insert buffer size (minimum is 8192) 30720> Press Enter
List contents of import file only (yes/no): no>
Ignore create error due to object existance (yes/no): no> Press Enter
Import grants (yes/no): yes> Press Enter
Import table date (yes/no): yes>Press Enter
Import entire export file (yes/no): no>
username:ExportFile_UserName
Import Terminated successfully with warnings.
-------------------------------------------------

No comments: