Re: Need To Dummy-Down Oracle

From: <mpir_at_compuserve.com>
Date: Sat, 05 Dec 1998 20:01:33 GMT
Message-ID: <74c3es$rtm$1@nnrp1.dejanews.com>

Column names only have to be unique within the same table. What you may be asking is to disable the foreign key constraints between the tables. Dangerous.

I do not understand what the Powerbuilder problem is, but you can do an 'Alter Table Disable Constraint xxxxxxxx' command (the exact syntax escapes me and I am at home, so my references are not available.) When you are done with whatever, then an 'Alter Table Enable Constraint xxxxxxxx' can be issued.

Could the powerbuilder problem be that you are not qualifying the field names such as 'owner.table.field'?

In article <74bnn1$ogu_at_dfw-ixnews10.ix.netcom.com>, "Doug Stone" <dstone_at_res-q.com> wrote:
> Hi. I have to implement, in Oracle, a db that includes duplicate column
> names.
>
> For instance, emp_id is in the employee table, and in the address table.
>
> The application was build with PowerBuilder datawindows.
>
> If I setup correct RI between all the duplicate column names, the
> datawindows will fail.
>
> Does anyone know how I can, temporarily, disable Oracle insistence on unique
> column names?
>
> Thank you,
> Doug
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sat Dec 05 1998 - 14:01:33 CST