Case in hand: Given a PeopleSoft Data Mover exported data file (db or dat file), how to extract the DDL statements [from that data file] which gets executed as part of the Data Mover's data import process?Here is a quick way to do it: Insert the SET EXTRACT statements in the Data Mover script (DMS) before the IMPORT .. statement.eg.,% cat /tmp/retrieveddl.dms..SET EXTRACT OUTPUT /tmp/ddl_stmts.log;SET EXTRACT DDL;..IMPORT *;It is mandatory that the SET EXTRACT OUPUT statement must appear before any SET EXTRACT statements. Run the Data Mover utility...
Thursday, 11 February 2010
Subscribe to:
Posts (Atom)
