Oracle Data Import and Export imp/exp sp2-0734: Unknown command starting with 'Imp... work und

Oracle Data Import and Export imp/exp sp2-0734: Unknown command starting with 'Imp... worksp2-0734 und: Unknown command starting with 'Imp ignored the remaining line default classification www.2cto.com should be executed at the cmd doscommand prompt, not in sqlplus ...... However, the format must be similar to: imp PERSONNEL_MANAGE/MWQ @ DBSQL full = y file = C: \ personnel_manage.dmpignore = y to commemorate my carelessness ..... I am wrong. The imp command is executed at the dos prompt. Run cmd directly and then export the data not executed in SQL: 1. Export the database TEST completely, and use the User Name system Password manager to D: daochu. exp system/manager @ TEST file = d: daochu in dmp. 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 database tables inner_policy and policy_staff_relat to exp aichannel/aichannel @ TESTDB2 file = d: datanewsmgnt. dmp tables = (inner_policy, policy_staff_relat) www.2cto.com 4 header the field filed1 in table 1 in the database with "00" Exp system/manager @ TEST file = d: daochu. dmp tables = (table1) query = "where filed1 like '000000'" www.2cto.com is commonly used for export. For compression, you can use winzip to compress the dmp file. You can also add compress = y to the command above. Import data 1 import the data in D: daochu. dmp to the TEST database. Imp system/manager @ TEST file = d: daochu. dmp imp aichannel/aichannel @ HUST full = y file = d: datanewsmgnt. dmp ignore = y may be faulty because some tables already exist and an error is reported. Add ignore = y to the end. 2. Importing table 1 in d: daochu. dmp to imp system/manager @ TEST file = d: daochu. dmp tables = (table1) is sufficient. In many cases, you must first completely delete the table and then import it. Note: If the operator has sufficient permissions, a prompt is displayed. Databases can be connected. You can use tnsping TEST to obtain whether the database TEST can be connected. Of course, the above method may export a large package when exporting data, because your user may grant DBA permissions during authorization, therefore, you can use the following method to back up the database: We recommend that you back up the database once a week after the system transition. Or back up the data table to be changed before the data table changes significantly. Perform the following steps to back up the data. In the command line, type "cmd" and press enter to enter the command line window. In the window, enter exp mas/123456 @ mas system prompt: Input array extract buffer size: 4096> you can press enter directly; www.2cto.com system prompt: Export File: EXPDAT. DMP> enter the location of the exported file. The path must exist. Oracle does not automatically create a path here, but the file name can be created. The backup file is suffixed with dmp. Input content such as: e: \ work \ mas_db_090925v1.dmp press enter system prompt: (1) E (complete database), (2) U (User) or (3) T (table ): (2) U> u can be entered here, or you can press enter directly, because at this time the default u system prompts: Export Permission (yes/no): yes> press enter system prompts: export table data (yes/no): yes> press enter system prompt: compression zone (yes/no): yes> press enter system prompt: user to export: (RETURN to exit)> mas system prompt: user to be exported: (RETURN to exit)> Press enter. The system will automatically back up the data.