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)("

jpximport d:\Employee.jpx -userId 1 -username apps -password apps -dbconnection "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)("

export /oracle/apps/per/employee/webui/employeeRN -rootdir d:\jdevhome\jdev\myprojects -username apps -password apps -dbconnection "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)("

//XMLImporter Command: Run this command on server from $JAVA_TOP 
java $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)(host = = 1532)))(connect_data = (sid =EAFIN11)))" 
// XML Exporter Command : Run this command on server from $JAVA_TOP
java /xx/oracle/apps/pa/projects/webui/ProjectSummaryPG -rootdir $JAVA_TOP -username apps -password atgapps -dbconnection "(description = (address_list = (address = (community = = tcp)(host = 1522)))(connect_data = (sid = EAFIN1)))"

No comments:

Post a Comment

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