In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-04-03 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)05/31 Report--
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!
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.