May 2010 Archives

FNDLOAD - Upload, download oracle program definitions

By chandramouly on May 5, 2010 10:47 PM | No Comments | No TrackBacks
Need to migrate concurrent program definition from one instance to another without creating it again manually. Say the program definitions have to be moved from Instance A to B.

1. Download the program definitions from one instance using FNDLOAD command
2. Use the .ldt file for download and upload, run the scripts in the UNIX box. Get the output
3. Upload the program definition using FNDLOAD command

Execute this in Source Instance A
FNDLOAD usr/pwd@instance 0 Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct PRG_XX.ldt PROGRAM APPLICATION_SHORT_NAME="XX" CONCURRENT_PROGRAM_NAME="XX_CP"

Get the PRG_XX.ldt output file and copy into local.

Then execute the below upload in Instance B where the definition needs to be migrated.

FNDLOAD usr/pwd@instance 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct PRG_XX.ldt 

Related Posts:
http://oracle.anilpassi.com/oracle-fndload-script-examples.html
http://www.oracleappshub.com/aol/its-all-about-fndload/

Extract tables from Oracle Apps - Code migration between instances

By chandramouly on May 5, 2010 10:35 PM | No Comments | No TrackBacks
I faced this situation: Need to move tables from one instance to another instance in Oracle applications. I just need to extract create table definitions, so that I can execute those create statements in another instance.

Script:

    SELECT DBMS_METADATA.GET_DDL('TABLE',u.table_name)
     FROM ALL_TABLES u
     where u.table_name like 'XX_TABLE_NAME'

dbms_metadata package helps us to get the create table definition. You can use all_tables or user_tables to get the table name details.

Usage: Move table definitions from one instance to another instance. 
« April 2010 | Main Index | Archives | September 2010 »

Search

About this Archive

This page is an archive of entries from May 2010 listed from newest to oldest.

April 2010 is the previous archive.

September 2010 is the next archive.

Find recent content on the main index or look in the archives to find all content.