Oracle dmp import troubleshooting

1. First, you must understand that the dmp file imported and exported from Oracle is executed using the cmd command, rather than SQL plus.

You can also use PLSQLDev to import and export data.

Note that the executable file export selects the exp.exe tool under the BIND installed on the client.

Ii. problems found in the export process:

The reason for online query is that there is a problem with the version of the database oracle server and the client. You need to change the version of the oracle client to the server to export the dmp file.

3. If no client version is available, why don't we directly connect to the server and use the cmd name to export the import.

1. Import command:

Imp userId/psw @ orcl full = y file = D: \ data \ T_DAYLOG_CALLANALYSIS.dmp ignore = y

2. Export commands

Exp userId/psw @ orcl file = d: \ dkj \ test. dmp tables = (wf_test)

4. How can I view the database version of the dmp file exported from?

Use ultraEdit to open the dmp file. You can see the version number on the top line.

We can see that the database is 11 GB.