This is one of the good reference documents from metalink. WHAT TO SET UP BEFORE GENERATING THE TRACE These steps must be performed by the DBA on the database server. 1. Set TIMED_STATISTICS to TRUE. For performance issues, make sure TIMED_STATISTICS is turned on, before attempting to generate the trace. Set the following in […]
FNDLOAD is a concurrent program that can move Oracle Applications data between database and text file. FNDLOAD can download data from an application entity into an editable text file, which can be uploaded to another database. Conversion between database format and text file format is specified by a configuration file. But i could not find […]
Create Temporary Table in Oracle To create a table named test with column col1 type varchar2 length 10, col2 type number. col3 type clob we can use CREATE TABLE statement as, CREATE TABLE TEST(col1 VARCHAR2(10), col2 NUMBER, col3 CLOB); Now if I insert data into the table the data is visible and accessible to all […]
About Hierarchical Trees The hierarchical tree displays data in the form of a standard navigator. We can populate a hierarchical tree with values contained in a Record Group or Query Text. At runtime, you can programmatically add, remove, modify, or evaluate elements in a hierarchical tree. The amount of data displayed at any one time […]
This is our requirement. SCHEMA NAME : XXCUSTTOP NAME : XXCUST_TOPApplication : XXCUST Custom ApplicationData Group : StandardRequest Group : XXCUST Request GroupMenu : XXCUST_CUSTOM_MENUResponsibility : XXCUST Custom Assumptions:APPL_TOP: /d01/oracle/VIS/apps/apps_st/applInstance Name: VISServer OS: linux There are 14 simple steps to achieve this.1) Make the directory structure for your custom application files.cd $APPL_TOPmkdir XXCUSTmkdir XXCUST/12.0.0mkdir XXCUST/12.0.0/adminmkdir […]
Recent Comments