This script will give you a list of all org_id’s – or just those matching the parameter. Copy paste the client_nfo column to set client info. SQL> @org % ORG_ID NAME CLIENT_INFO ------ ---------------------------- ----------------------------------------------------- 0 Setup Business Group begin dbms_application_info.set_client_info(0);end; 101 XXXX GROUP begin dbms_application_info.set_client_info(101);end; Syntax: @org <partial org. name>
Download: sql4oracle.zip - all sql4oracle scripts - posted 14-03-2013