Re: [cx-oracletools-users] CopyData.ph without a PK or unique constraint?

[Victor H. <vic...@ya...>]

heya,

Aweesome =).

Yup, --no-check-exists works fine for us, although I thin I'll probably use
the --key-columns (since there is a column we are "using" for PK, just not
enforced...hmm).

Cheers,
Victor

On Wed, Nov 9, 2011 at 02:59, Anthony Tuininga
<ant...@gm...>wrote:

> Yes, you can do it still. These are your options:
>
> (1) use the --no-check-exists option which will simply perform inserts
> without checking to see if the row exists and an update is needed
> (2) use the --key-columns option which specifies which columns
> function as the key that identifies each row uniquely
>
> Hope that helps!
>
> Anthony
>
> On Mon, Nov 7, 2011 at 3:57 PM, Victor Hooi <vic...@ya...> wrote:
> > Hi,
> > I'm attempiting to use cx_OracleTool's CopyData.py script to copy data
> > between two tables on separate Oracle schemas/instances.
> > I get the error:
> >>
> >> No primary or unique constraint found on table.
> >
> > I don't know much about Oracle, to be honest, but from what I can tell
> the
> > tables don't seem to have any PK constraint or anything like that
> defined.
> > The merits of this aside, I think it's simply been setup that way for
> > expediency, and it's unlikely to change anytime nearterm.
> > Is there any way to get copyData.py to run in this scenario without a PK
> > constraint?
> > Cheers,
> > Victor
> >
> ------------------------------------------------------------------------------
> > RSA(R) Conference 2012
> > Save $700 by Nov 18
> > Register now
> > http://p.sf.net/sfu/rsa-sfdev2dev1
> > _______________________________________________
> > cx-oracletools-users mailing list
> > cx-...@li...
> > https://lists.sourceforge.net/lists/listinfo/cx-oracletools-users
> >
> >
>