1,导出表
userid=erptest/erptest
buffer=100000
feedback=10000
file=/oraclebak/compiere_exp/erptest.dmp
log=/oraclebak/compiere_exp/erptest.log
tables=product,product_price
2,导入表
userid=system/system
buffer=100000
feedback=10000
file=/oraclebak/compiere_exp/erptest.dmp
log=/oraclebak/compiere_exp/erptest.log
tables=product
touser=erpnew
3,导出用户
userid=system/system
buffer=100000
feedback=10000
file=/oraclebak/compiere_exp/erpnew.dmp
log=/oraclelog/erpnew_exp/erpnew.log
owner=erpnew
4,导入用户
userid=system/system
buffer=100000
feedback=10000
file=/oraclebak/compiere_exp/erpnew.dmp
log=/oraclelog/erpnew_exp/erpnew_1.log
fromuser=erpnew
touser=erptest
exp parfile=/oracle/c.txt
imp parfile=/oracle/c.txt
userid=erptest/erptest
buffer=100000
feedback=10000
file=/oraclebak/compiere_exp/erptest.dmp
log=/oraclebak/compiere_exp/erptest.log
tables=product,product_price
2,导入表
userid=system/system
buffer=100000
feedback=10000
file=/oraclebak/compiere_exp/erptest.dmp
log=/oraclebak/compiere_exp/erptest.log
tables=product
touser=erpnew
3,导出用户
userid=system/system
buffer=100000
feedback=10000
file=/oraclebak/compiere_exp/erpnew.dmp
log=/oraclelog/erpnew_exp/erpnew.log
owner=erpnew
4,导入用户
userid=system/system
buffer=100000
feedback=10000
file=/oraclebak/compiere_exp/erpnew.dmp
log=/oraclelog/erpnew_exp/erpnew_1.log
fromuser=erpnew
touser=erptest
exp parfile=/oracle/c.txt
imp parfile=/oracle/c.txt
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/22779291/viewspace-630790/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
实验DBMS_LOCK
下一篇：
河南出差
请登录后发表评论
登录
全部评论
