Return-Path: X-Original-To: oracle-l@orafaq.com Delivered-To: oracle-l@orafaq.com Received: from puck1183.startdedicated.com (localhost [127.0.0.1]) by puck1183.startdedicated.com (Postfix) with ESMTP id 110261960242 for ; Thu, 5 May 2016 16:29:11 +0200 (CEST) Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by puck1183.startdedicated.com (Postfix) with ESMTPS for ; Thu, 5 May 2016 16:29:10 +0200 (CEST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1BC4728EA1; Thu, 5 May 2016 10:29:10 -0400 (EDT) X-Virus-Scanned: Debian amavisd-new at turing.freelists.org Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id uveb67sqj1oW; Thu, 5 May 2016 10:29:10 -0400 (EDT) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DAF87350DD; Thu, 5 May 2016 10:28:57 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 05 May 2016 10:27:36 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D3F3928EA1 for ; Thu, 5 May 2016 10:27:35 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id mzHt_aV4li0w for ; Thu, 5 May 2016 10:27:35 -0400 (EDT) Received: from sasl.smtp.pobox.com (pb-smtp1.pobox.com [64.147.108.70]) (using TLSv1.2 with cipher AECDH-AES256-SHA (256/256 bits)) (No client certificate requested) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTPS id 9E4D6288B0 for ; Thu, 5 May 2016 10:27:35 -0400 (EDT) Received: from sasl.smtp.pobox.com (unknown [127.0.0.1]) by pb-smtp1.pobox.com (Postfix) with ESMTP id 1992E1745C for ; Thu, 5 May 2016 10:27:33 -0400 (EDT) Received: from pb-smtp1. (unknown [127.0.0.1]) by pb-smtp1.pobox.com (Postfix) with ESMTP id 103BD1745B for ; Thu, 5 May 2016 10:27:33 -0400 (EDT) Received: from mail-ig0-f170.google.com (unknown [209.85.213.170]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) by pb-smtp1.pobox.com (Postfix) with ESMTPSA id A5E6917457 for ; Thu, 5 May 2016 10:27:32 -0400 (EDT) Received: by mail-ig0-f170.google.com with SMTP id s8so15150411ign.0 for ; Thu, 05 May 2016 07:27:32 -0700 (PDT) X-Gm-Message-State: AOPr4FWa0DJVnMiEuJBsbOz7DjZjw1FzYovpUGQGtEkD0PTS01sAr0LIqmXgwHI1P7mnlzTt546h7IRDWCmmng== X-Received: by 10.50.18.166 with SMTP id x6mr4130149igd.12.1462458452138; Thu, 05 May 2016 07:27:32 -0700 (PDT) MIME-Version: 1.0 Received: by 10.107.58.136 with HTTP; Thu, 5 May 2016 07:27:02 -0700 (PDT) In-Reply-To: References: From: Luis Santos Date: Thu, 5 May 2016 11:27:02 -0300 X-Gmail-Original-Message-ID: Message-ID: Subject: Re: Looking for null byte (0x0) characters in triggers To: don@seiler.us Cc: ORACLE-L Content-Type: multipart/alternative; boundary=14dae93a0cbd89f2a705321924fc X-Pobox-Relay-ID: 81386834-12CD-11E6-931E-9A9645017442-02349853!pb-smtp1.pobox.com X-archive-position: 64823 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: lsantos@pobox.com Precedence: normal Reply-To: lsantos@pobox.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l --14dae93a0cbd89f2a705321924fc Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable I really don=C2=B4t have advice to you. I=C2=B4m replying just to say that = I loved your technique! Copying dba_triggers to a temp table and convert the trigger_body to a LOB to make it searchable was a great idea! *--* *Att* *Luis Santos* 2016-05-05 10:41 GMT-03:00 Don Seiler : > Oracle 12.1.0.2 w/ Jan 2016 PSU, x86-64. > > We're using the datapump API to import objects from one DB to another. > However we occasionally hit the error described in DocID 1628926.1. It > seems some of these triggers have null bytes in them somehow. However, > rather than just doing trial and error to find them one-at-a-time as we h= it > them, I'd like just search for the ones that have the null byte. > > One thing I've done copy dba_triggers to a temp table, converting the > trigger_body to a lob and then using dbms_lob.instr(trigger_body,chr(0)) = to > try to find them. However that only returned one trigger. Perhaps that is > right and our other DP trigger import errors are due to some oother reaso= n, > but I want to confirm that I'm not missing anything or there isn't a bett= er > way to search. > > Don. > > -- > Don Seiler > http://www.seiler.us > --14dae93a0cbd89f2a705321924fc Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
I really don=C2=B4t have adv= ice to you. I=C2=B4m replying just to say that I loved your technique! Copy= ing dba_triggers to a temp table and convert the trigger_body to a LOB to m= ake it searchable was a great idea!

=

<= div style=3D"margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:= 0px" align=3D"justify">

--
Att<= /div>
Luis Santos



2016-05-05 10:41 GMT-03:00 Don Seiler <don@seil= er.us>:
Oracle 12.1.0.2 w/ Jan 2016 PSU, x86-64.

We're u= sing the datapump API to import objects from one DB to another. However we = occasionally hit the error described in DocID 1628926.1. It seems some of t= hese triggers have null bytes in them somehow. However, rather than just do= ing trial and error to find them one-at-a-time as we hit them, I'd like= just search for the ones that have the null byte.

One t= hing I've done copy dba_triggers to a temp table, converting the trigge= r_body to a lob and then using dbms_lob.instr(trigger_body,chr(0)) to try t= o find them. However that only returned one trigger. Perhaps that is right = and our other DP trigger import errors are due to some oother reason, but I= want to confirm that I'm not missing anything or there isn't a bet= ter way to search.

Don.

--

--14dae93a0cbd89f2a705321924fc-- -- http://www.freelists.org/webpage/oracle-l