Return-Path: 
 <ddlutils-user-return-91-apmail-db-ddlutils-user-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-ddlutils-user-archive@www.apache.org
Received: (qmail 87226 invoked from network); 22 Jan 2006 23:32:47 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 22 Jan 2006 23:32:47 -0000
Received: (qmail 28726 invoked by uid 500); 22 Jan 2006 23:32:46 -0000
Delivered-To: apmail-db-ddlutils-user-archive@db.apache.org
Received: (qmail 28702 invoked by uid 500); 22 Jan 2006 23:32:46 -0000
Mailing-List: contact ddlutils-user-help@db.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:ddlutils-user-help@db.apache.org>
List-Unsubscribe: <mailto:ddlutils-user-unsubscribe@db.apache.org>
List-Post: <mailto:ddlutils-user@db.apache.org>
List-Id: <ddlutils-user.db.apache.org>
Reply-To: ddlutils-user@db.apache.org
Delivered-To: mailing list ddlutils-user@db.apache.org
Received: (qmail 28691 invoked by uid 99); 22 Jan 2006 23:32:46 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 22 Jan 2006 15:32:46 -0800
X-ASF-Spam-Status: No, hits=-0.0 required=10.0
	tests=SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: domain of tomdzk@gmail.com designates
 66.249.92.198 as permitted sender)
Received: from [66.249.92.198] (HELO uproxy.gmail.com) (66.249.92.198)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 22 Jan 2006 15:32:45 -0800
Received: by uproxy.gmail.com with SMTP id o2so667716uge
        for <ddlutils-user@db.apache.org>;
 Sun, 22 Jan 2006 15:32:24 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=ZpIsmRvW/wiwvD9fattEwxY3BnJgZowgXb3J6MgNpsdk/P0du9hnuLPDQYe53uKUVW0KSY2PK4/5d7JLIQ2GCD59rgu03spv3eeYQBeORtjOPMGmfOyAyObFdRzFnfDDj/UMddkY52igpcWmaXMa+7MNkl05pAI1C9GxVX+eGcA=
Received: by 10.67.31.13 with SMTP id i13mr2015461ugj;
        Sun, 22 Jan 2006 15:32:24 -0800 (PST)
Received: by 10.67.30.2 with HTTP; Sun, 22 Jan 2006 15:32:24 -0800 (PST)
Message-ID: <224f32340601221532wc1aaf73o81e03325c95a8959@mail.gmail.com>
Date: Mon, 23 Jan 2006 00:32:24 +0100
From: Thomas Dudziak <tomdzk@gmail.com>
To: ddlutils-user@db.apache.org
Subject: Re: probem reading oracle database?
In-Reply-To: <43D3D4FD.7020508@guydavis.ca>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <43D241F1.6010503@informaticsmatters.com>
	 <43D3D4FD.7020508@guydavis.ca>
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

On 1/22/06, Guy Davis <davis@guydavis.ca> wrote:
> I had the same problem on Friday after trying out ddlutils for the first
> time.  I'm hoping to pull the schema off our main Oracle 9i database and
> let me automatically load it onto developer workstations running Oracle
> 10g Express Edition via the Ant tasks.  Any ideas on how to get around
> this issue would be most appreciated.

FYI, I'm currently struggling to setup a Oracle 10 for testing.
I've already adapted the dump task, and it would be nice if you could
test it on your 9i like this:

    <taskdef name=3D"dumpMetadata"
             classname=3D"org.apache.ddlutils.task.DumpMetadataTask">
             classpathref=3D"project.class.path"/>
    <dumpMetadata outputfile=3D"db-metadata.xml"
                  catalogpattern=3D""
                  schemapattern=3D"SOMESCHEMA"
                  tablepattern=3D""
                  procedurepattern=3D""
                  tabletypes=3D"TABLE" >
      <database driverclassname=3D"${datasource.driverClassName}"
                url=3D"${datasource.url}"
                username=3D"${datasource.username}"
                password=3D"${datasource.password}"/>
    </dumpMetadata>

This should run through (though it might take a bit, esp. when reading
the procedures which you can turn it off with the dumpProcedures task
attribute) and the created XML file should contains all tables etc.
that you were expecting.

Tom