Excluding tables in script-based extraction

By default, data from all tables will be extracted. If you do not want data from certain tables to be extracted, take these steps:

  1. Edit the ExtractORCLAI.SQL file.
  2. In the ExtractORCLAI.SQL file, comment the SELECT query for the object that you do not want to extract. To comment the query, place /* before the SELECT statement and place */ as the end of the SELECT statement. Refer to the example given below.

    Example

    SET TERMOUT ON

    PROMPT Extracting AK_RESP_SECURITY_ATTRIBUTES

    SET TERMOUT OFF

    SPOOL &1\AK_RESP_SECURITY_ATTRIBUTES.txt

    /* SELECT NULL||'$$$$!@**'||'@B$R@C!I#D#'||'$$$$!@**'|| ZAK_RESP_SECURITY_ATTRIBUTES.RESPONSIBILITY_ID||'$$$$!@**'|| ZAK_RESP_SECURITY_ATTRIBUTES.RESP_APPLICATION_ID||'$$$$!@**'|| ZAK_RESP_SECURITY_ATTRIBUTES.ATTRIBUTE_CODE||'$$$$!@**'|| ZAK_RESP_SECURITY_ATTRIBUTES.ATTRIBUTE_APPLICATION_ID||'$$$$!@**'|| ZAK_RESP_SECURITY_ATTRIBUTES.CREATED_BY||'$$$$!@**'||(CASE WHEN TO_CHAR(ZAK_RESP_SECURITY_ATTRIBUTES.CREATION_DATE, 'YYYY-MM-DD HH24:MI:SS') < '1900-01-01 00:00:00' THEN '1900-01-01 00:00:00' ELSE TO_CHAR (ZAK_RESP_SECURITY_ATTRIBUTES.CREATION_DATE, 'YYYY-MM-DD HH24:MI:SS') END)||'$$$$!@**'||ZAK_RESP_SECURITY_ATTRIBUTES.LAST_UPDATED_BY||'$$$$! @**'||(CASE WHEN TO_CHAR(ZAK_RESP_SECURITY_ATTRIBUTES. LAST_UPDATE_DATE, 'YYYY-MM-DD HH24:MI:SS') < '1900-01-01 00:00:00' THEN '1900- 01-01 00:00:00' ELSE TO_CHAR(ZAK_RESP_SECURITY_ATTRIBUTES. LAST_UPDATE_DATE, 'YYYY-MM-DD HH24:MI:SS') END)||'$$$$!@**'|| ZAK_RESP_SECURITY_ATTRIBUTES.LAST_UPDATE_LOGIN||'$$$$!@**###' FROM AK_RESP_SECURITY_ATTRIBUTES ZAK_RESP_SECURITY_ATTRIBUTES; */

    SPOOL OFF