SQL>
SQL> set linesize 500
SQL> set trimspool on
SQL> set embedded on
SQL> spool logmnr.opt
SQL> select
2 'colmap = ' || user || ' ' || table_name || ' (' ||
3 max( decode( column_id, 1, column_id , null ) ) ||
4 max( decode( column_id, 1, ', '||column_name, null ) ) ||
5 max( decode( column_id, 2, ', '||column_id , null ) ) ||
6 max( decode( column_id, 2, ', '||column_name, null ) ) ||
7 max( decode( column_id, 3, ', '||column_id , null ) ) ||
8 max( decode( column_id, 3, ', '||column_name, null ) ) ||
9 max( decode( column_id, 4, ', '||column_id , null ) ) ||
10 max( decode( column_id, 4, ', '||column_name, null ) ) ||
11 max( decode( column_id, 5, ', '||column_id , null ) ) ||
12 max( decode( column_id, 5, ', '||column_name, null ) ) || ');' colmap
13 from user_tab_columns
14 group by user, table_name
15 /
COLMAP
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
colmap = RNTSOFT AVAIL_TRACE_FILES (1, USERNAME, 2, FILENAME, 3, DT);
COLMAP
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
colmap = RNTSOFT INTEREST (1, YR, 2, RATE);
colmap = RNTSOFT AUTHOR_PUBLICATION (1, ID, 2, NAME, 3, TITLE, 4, WRITTEN_DATE);
colmap = RNTSOFT DEPT_OR (1, DEPTNO, 2, DNAME, 3, LOC, 4, EMPS);
colmap = RNTSOFT BIN$z+/2/T9WTRWmOfXZhvGBPQ==$0 (1, ID, 2, WORKER_ID, 3, LOGICAL_WORKPLACE_ID, 4, ACTIVE_DATE, 5, INACTIVE_DATE);
colmap = RNTSOFT HOME_ADDRESS_LIST (1, LIST_ID, 2, HOME_ADDRESSES);
colmap = RNTSOFT MYCLOB (1, ID, 2, CLOB_DATA);
colmap = RNTSOFT CRS_OFFERINGS (1, COURSE_CODE, 2, DESCRIPTION, 3, BEGINDATE);
colmap = RNTSOFT BIN$2AYTRnCPRfG80DYlHN4sJg==$0 (1, ID, 2, WORKER_ID, 3, LOGICAL_WORKPLACE_ID, 4, ACTIVE_DATE, 5, INACTIVE_DATE);
colmap = RNTSOFT HRC_ORG_SITE (1, HRC_CODE, 2, HRC_DESCR, 3, ORG_ID, 4, ORG_SHORT_NAME, 5, ORG_LONG_NAME);
colmap = RNTSOFT EMPLOYEE_EMPLOYEE_EVALUATION (1, ID, 2, NAME, 3, TITLE, 4, WRITTEN_DATE);
colmap = RNTSOFT EMPLOYEE_EVALUATION (1, ID, 2, TITLE, 3, WRITTEN_DATE);
COLMAP
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
colmap = RNTSOFT I2 (1, N, 2, V);
colmap = RNTSOFT DEPT20_V (1, EMPNO, 2, ENAME, 3, INIT, 4, JOB, 5, MGR);
colmap = RNTSOFT USER_AVAIL_TRACE_FILES (1, USERNAME, 2, FILENAME, 3, DT);
colmap = RNTSOFT T1_TIMES (1, XSTART, 2, XSTOP);
colmap = RNTSOFT WORKING_CUSTOMERS (1, CUST_NO, 2, LASTNAME, 3, FIRSTNAME, 4, MIDINIT, 5, STREET);
colmap = RNTSOFT STUDENT (1, STUDENT_ID, 2, PERFORMANCE, 3, GENDER, 4, ETHNICITY, 5, AGE);
colmap = RNTSOFT WORKING_EMPLOYEES (1, EMPL_NO, 2, LASTNAME, 3, FIRSTNAME, 4, MIDINIT, 5, STREET);
colmap = RNTSOFT EMP_V (1, EMPNO, 2, ENAME, 3, JOB, 4, MGR, 5, SAL);
colmap = RNTSOFT BIN$BIALfQCESHa/SipQl+oqGg==$0 (1, ID, 2, WORKER_ID, 3, LOGICAL_WORKPLACE_ID, 4, ACTIVE_DATE, 5, INACTIVE_DATE);
colmap = RNTSOFT COURSE_DAYS (1, EMPNO, 2, ENAME, 3, DAYS);
colmap = RNTSOFT HAZARD_LEVEL_T (1, ID, 2, MAGNITUDE, 3, CODE, 4, DESCRIPTION, 5, ACTIVE_DATE);
COLMAP
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
colmap = RNTSOFT EMP_VIEW (1, ENAME, 2, EMPNO);
colmap = RNTSOFT DDL_AUDIT (1, OBJECT_NAME, 2, OBJECT_TYPE, 3, WHEN_CREATED, 4, WHO_CREATED, 5, WHEN_UPDATED);
colmap = RNTSOFT MYTABLE1_TIMES (1, XSTART, 2, XSTOP);
colmap = RNTSOFT I1 (1, N, 2, V);
colmap = RNTSOFT CRS_COURSE_SCHEDULE (1, COURSE_CODE, 2, DESCRIPTION, 3, BEGINDATE);
colmap = RNTSOFT EMPLOYEE_PUBLICATION (1, ID, 2, NAME, 3, TITLE, 4, WRITTEN_DATE);
colmap = RNTSOFT SALES_BY_ATLAS_V (1, PRODUCT_NAME, 2, SALESPERSON, 3, ORDER_DATE, 4, QUANTITY);
colmap = RNTSOFT SALES_PER_PERSON_V (1, SALESPERSON, 2, PRODUCT_NAME, 3, ORDER_DATE, 4, QUANTITY);
colmap = RNTSOFT AVG_EVALUATIONS (1, COURSE, 2, AVG_EVAL);
colmap = RNTSOFT APPLICATION_USERS (1, UNAME, 2, PW, 3, ROLE_TO_GRANT);
colmap = RNTSOFT SITE_TAB (1, SITE_NO, 2, SITE_DESCR);
COLMAP
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
colmap = RNTSOFT OUTRAIN (1, DY, 2, RAINFALL);
colmap = RNTSOFT DUMMY (1, COL1);
colmap = RNTSOFT BIN$uR9LzoavTbyjK4b4t8kgXg==$0 (1, ID, 2, WORKER_ID, 3, PHYSICAL_WORKPLACE_ID, 4, ACTIVE_DATE, 5, INACTIVE_DATE);
colmap = RNTSOFT BIN$ukEn3nqRT+u/paBe8fJpxQ==$0 (1, ID, 2, WORKER_ID, 3, LOGICAL_WORKPLACE_ID, 4, ACTIVE_DATE, 5, INACTIVE_DATE);
colmap = RNTSOFT MAP (1, N, 2, I1, 3, I2);
colmap = RNTSOFT EMP_DEPT_CLUSTER (1, DEPTNO);
colmap = RNTSOFT HASH_CLUSTER (1, HASH_KEY);
41 rows selected.
SQL> spool off
SQL>