Because of other factors, can't use oracle exp a export, need partial export,,
The current export situation is as follows:
Exp. Exe 'xx/@ XXX (the DESCRIPTION=(ADDRESS=(TCP) PROTOCOL=(HOST=X.X.X.X.X) (1521) PORT=) (CONNECT_DATA=https://bbs.csdn.net/topics/(service_name=backup)))' file="c: \ programdata \ xx. DMP" tables=(users) query=\ "where ID & gt;=0 and ID & lt;
=1000000 \ '
Exp. Exe 'xx/@ XXX (the DESCRIPTION=(ADDRESS=(TCP) PROTOCOL=(HOST=X.X.X.X.X) (1521) PORT=) (CONNECT_DATA=https://bbs.csdn.net/topics/(service_name=backup)))' file="c: \ programdata \ xx. DMP" tables=(users) query=\ "where ID & gt;=1000000 and ID & lt;
=2000000 \ '
Through the exp query where conditions for partial export, may I ask you a great god, and the jar to the local, can let the batch exported data back to a primitive database?
CodePudding user response:
Can, at the import the table before,Each time the import, use ignore=y parameter,
CodePudding user response:
See you now have the ID column, if the column is meaningful on your business field, so no problem, if you are using rownum this pseudo columns, that can not line,