What about the imp/exp sp2-0734 error of Oracle data import and export

This article is to share with you what to do with Oracle data import and export imp/exp sp2-0734 errors. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

Oracle data import and export imp/exp sp2-0734: unknown command beginning 'imp ignores the default classification solution for the remaining lines

Sp2-0734: unknown command start 'imp ignores default classification of remaining lines

It should be executed at the dos command prompt in cmd, not in sqlplus. But the format must be similar to:

Imp PERSONNEL_MANAGE/MWQ@DBSQL full=y file=C:\ personnel_manage.dmpignore=y

In memory of my carelessness. I was wrong.

The imp command is executed at the dos prompt.

Executed directly after cmd rather than under sql

Data export:

1 Export the database TEST completely, and export the user name system password manager to D:daochu.dmp

Exp system/manager@TEST file=d:daochu.dmp full=y

2 export the tables of system users and sys users in the database

Exp system/manager@TEST file=d:daochu.dmp owner= (system,sys)

3 export the tables inner _ notify and notify_staff_relat in the database

Exp aichannel/aichannel@TESTDB2 file= d:datanewsmgnt.dmp tables= (inner_notify,notify_staff_relat)

4 export the field filed1 in the table table1 in the database with the data starting with "00"

Exp system/manager@TEST file=d:daochu.dmp tables= (table1) query= "where filed1 like'00%'"

The above are commonly used exports, for compression, both using winzip to dmp files can be very good compression.

You can also add compress=y to the above command.

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 a problem above, because some table already exists, and then it reports an error and does not import the table.

Just add ignore=y at the end.

2 Import the table table1 in d:daochu.dmp

Imp system/manager@TEST file=d:daochu.dmp tables= (table1)

Basically, the above import and export is enough. In many cases, the table is deleted completely and then imported.

Note:

The operator should have sufficient permissions, and it will prompt if the permissions are not enough.

You can connect to the database. You can use tnsping TEST to find out whether the database TEST can be connected.

Of course, the above method may export a large package when exporting data, because your user may have granted DBA permission at the time of authorization, so you can use the following methods to backup the database:

Database backup

It is recommended that the system be backed up once a week after the transition. Or back up the data table to be changed before a major change occurs.

Perform the following steps to make a backup.

On the command line, type "cmd", enter, and enter the command line window.

In the window, enter:

Exp mas/123456@mas

Prompt: enter the array extraction buffer size: 4096 >

You can enter directly.

Prompt: export file: EXPDAT.DMP >

Enter the location of the exported file here, and its path must exist. Oracle will not automatically establish the path here, but you can establish the file name. Backup files are suffixed with dmp.

Enter something such as: e:\ work\ mas_db_090925v1.dmp enter

The system prompts: (1) E (complete database), (2) U (user) or (3) T (table): (2) U > u

You can enter u here or enter directly, because the default of the system at this time is U

Prompt: export permission (yes/no): yes > enter

Prompt: export table data (yes/no): yes > enter

System prompt: compression area (yes/no): yes > enter

Prompt: user to export: (RETURN to exit) > mas

System prompt: user to export: (RETURN to exit) > enter

At this point, the system will automatically back up.

Thank you for reading! On "Oracle data import and export imp/exp sp2-0734 error how to do" this article is shared here, I hope the above content can be of some help to you, so that you can learn more knowledge, if you think the article is good, you can share it out for more people to see it!