Www.cnblogs.comsongwinarticles1593087.html1.imp.exe if the environment variable is configured, you can directly use imp in cmd. If not, you need to enter oralce .. under the bin directory 2. enter the user name and password. 3. enter the import path name. expdat. dmp *. dmp input buffer size (minimum: 8192) 30
Http://www.cnblogs.com/songwin/articles/1593087.html 1.imp.exe if configured to the environment variable, you can then cmd directly imp, if not, need to enter oralce /.. /Under the bin directory 2. enter the user name and password. 3. enter the import path name. expdat. dmp *. dmp input buffer size (minimum: 8192) 30
Http://www.cnblogs.com/songwin/articles/1593087.html
1.imp.exe if the environment variable is configured, you can directly use imp in cmd. If not, you need to enter the bin directory under oralce /../.
2. Enter the user name and password
3. Enter the import path name.
>. Expdat. dmp> *. dmp
Input insert buffer size (minimum 8192) 30720> press ENTER
Only list the content of the imported file (yes/no): no>
The creation error is ignored because the object already exists (yes/no): no> yes
Import Permission (yes/no): yes>
Import table data (yes/no): yes>
Import the entire exported file (yes/no): no> yes
. Importing the TEST object to SCOTT.
.. Importing table "CMAMENU" 4336 rows being imported
Import is terminated successfully, but a warning is displayed. Window closed automatically