Re: how to update a list of tables using native dynamic sql?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 20 Apr 2005 22:44:48 +0200
Message-ID: <hmfd61phco7u830o707qr3kuv0fgkttdif@4ax.com>

On 20 Apr 2005 12:18:46 -0700, navrsalemile_at_yahoo.ca (navrsale) wrote:

>Given is the list of tables that need to be updated.
>I try to use this syntax (and many others) but got errors:

You seem to intend to update not the table but it's entry in the datadictionary, as you are showing datadictionary attributes. Updating the datadictionary is not supported and will invalidate your support contract, and Oracle won't help you sorting the mess out you are creating by doing this.

--
Sybrand Bakker, Senior Oracle DBA

Received on Wed Apr 20 2005 - 15:44:48 CDT