Anil's Blog is Best Viewed on GOOGLE CHROME

Sunday, April 5, 2009

Import & Export Commands 11i & R12

//Note : Need to run these commands from window command prompt
// For 11i - JDevInstallDir\jdevbin\jdev\bin>
// For R12 - JDevInstallDir\jdevbin\oaext\bin;

import d:\jdevhome\jdev\myprojects\xx\oracle\apps\per\webui\EmployeeRN.xml -rootdir d:\jdevhome\jdev\myprojects -username apps -password apps -dbconnection "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=camoradb9.xx.com)(PORT=1525))(CONNECT_DATA=(SID=DEV)))"

jpximport d:\Employee.jpx -userId 1 -username apps -password apps -dbconnection "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=camoradb9.xx.com)(PORT=1525))(CONNECT_DATA=(SID=DEV)))"

export /oracle/apps/per/employee/webui/employeeRN -rootdir d:\jdevhome\jdev\myprojects -username apps -password apps -dbconnection "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=camoradb9.xx.com)(PORT=1525))(CONNECT_DATA=(SID=DEV)))"


//XMLImporter Command: Run this command on server from $JAVA_TOP 
java oracle.jrad.tools.xml.importer.XMLImporter $JAVA_TOP/xxx/oracle/apps/pa/sco/webui/StaffingRN.xml -rootdir  $JAVA_TOP -userId 1 -username apps -password xxx -dbconnection "(description = (address_list = (address = (community  = tcp.world)(protocol = tcp)(host = camoradb8.xxx.com)(port = 1532)))(connect_data = (sid =EAFIN11)))" 
 
// XML Exporter Command : Run this command on server from $JAVA_TOP
java oracle.jrad.tools.xml.exporter.XMLExporter /xx/oracle/apps/pa/projects/webui/ProjectSummaryPG -rootdir $JAVA_TOP -username apps -password atgapps -dbconnection "(description = (address_list = (address = (community = tcp.world)(protocol = tcp)(host =CAMORADB8.xxx.com)(port = 1522)))(connect_data = (sid = EAFIN1)))"

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.