Oracle data Import Export IMP/EXP sp2-0734: unknown command opening IMP

sp2-0734: Unknown command opening ' imp ignored remaining row default category

It should be executed at the DOS command prompt at CMD, not inside the sqlplus ... But the format must be similar to the following:

Imp Personnel_manage/mwq@dbsql full=y file=c:personnel_manage.dmpignore=y

I would like to commemorate my carelessness. I was wrong.

The IMP command is executed at a DOS prompt.
Execute directly after CMD instead of executing in SQL

Data export:
1 completely export database test, user Name System Password Manager exported to D:daochu.dmp
Exp System/manager@test file=d:daochu.dmp full=y
2 Exporting a table from the system user in the database to the SYS user
Exp system/manager@test file=d:daochu.dmp owner= (System,sys)
3 Export the table inner_notify, Notify_staff_relat in the database
Exp AICHANNEL/AICHANNEL@TESTDB2 file= d:datanewsmgnt.dmp tables= (Inner_notify,notify_staff_relat)

4 Export the fields in the table table1 in the database filed1 with the data beginning with "00"
Exp system/manager@test file=d:daochu.dmp tables= (table1) query= "where filed1 like ' 0% '"

The above is commonly used for export, for compression, both with WinZip to DMP file can be very good compression.
You can also implement it by adding compress=y to the command below.

Import of data
1 Import the data from D:DAOCHU.DMP into the test database.
Imp system/manager@test file=d:daochu.dmp
Imp aichannel/aichannel@hust full=y file=d:datanewsmgnt.dmp ignore=y
There may be something wrong with it, because some tables already exist, and then it complains, and the table is not imported.
Just add ignore=y to the back.
2 Import the table table1 in D:daochu.dmp
Imp system/manager@test file=d:daochu.dmp tables= (table1)

Basically, the import export above is sufficient. In many cases, you should first delete the table completely and then import it.

Attention:
The operator must have sufficient permissions, and the permission is not sufficient for it to prompt.
Database can be connected to. You can use tnsping test to get the database test to connect.

Of course, the above method may export a large package when exporting data, because your users may grant DBA authority at the time of authorization, so you can use the following method for database backup:

Database backup
It is recommended that you make a backup once a week after the system transitions. Or, before a significant change in the datasheet, make a backup of the datasheet that you want to change.
Perform the following steps to make a backup.
In the command line, typing "cmd", enter the command line window.
In the window, enter:
Exp Mas/123456@mas

System hint: Input array extract buffer size: 4096 >
can enter directly;

System hint: Export file: Expdat. Dmp>
Here you can enter the location of the exported file where the path must exist, and Oracle will not automatically establish the path here, but the file name may be created. The backup file is dmp as a suffix.
Input content such as: e:workmas_db_090925v1.dmp carriage return

System tip: (1) E (complete database), (2) u (user) or (3) T (table): (2) u > U
Here you can enter, or you can return directly, because the system at this time the default is U

System Hint: Export permission (yes/no):yes> carriage return

System Hint: Export table data (yes/no):yes> carriage return

System Tip: Compressed Area (yes/no):yes> carriage return

System hint: Users to export: (Return to exit) > Mas

System hint: The user to export: (Return to exit) > enter

The system will be backed up automatically at this time