RE: 30+ long db_link names and dbms_metadata.get_ddl

From: Herring Dave - dherri <Dave.Herring_at_acxiom.com>
Date: Thu, 26 May 2005 13:14:00 -0500
Message-ID: <7ED53A68952D3B4C9540B4EFA5C76E367E6E14@CWYMSX04.Corp.Acxiom.net>

> I wrote a series of scripts that combined the 50% of DBMS_METADATA
that
> worked with custom calls for the 50% that did not.

Dan - would you be willing to share some of these scripts? I've run into a number of things and would like to see how others have dealt with it or at least share with them what the trouble spots are. Perhaps even create a decent list of all known issues we've found with DBMS_METADATA. For example:

1. The profile 'DEFAULT' cannot be extracted, instead generating an ORA-31603.
2. Constraint DDL leaves off the SQL terminator, even when set via SET_TRANSFORM_PARAM.
3. Database link names > 30 cause ORA-31600 errors.

Thanks.

Dave

---

Dave Herring, DBA
Acxiom Corporation
3333 Finley
Downers Grove, IL 60515
wk: 630.944.4762
<mailto:dherri_at_acxiom.com>

---

---

The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination,=20 distribution, or copying of this communication is strictly prohibited.
If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You.

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

Received on Thu May 26 2005 - 14:19:10 CDT