Re: DBMS_METADATA Remove User ID

From: Maxim <mdemenko_at_gmail.com>
Date: Wed, 29 Jul 2009 10:29:58 +0200
Message-ID: <8dde6bbd0907290129u58d8a72dj599555533a8399fc_at_mail.gmail.com>

DBMS_METADATA.SET_REMAP_PARAM(th,'REMAP_SCHEMA',user,'');

should work.
You can see an example here
http://www.sql.ru/forum/actualthread.aspx?tid=598309#6221573 ( it is a russian forum, but the code doesn't need to be translated)

Best regards

Maxim

On Wed, Jul 29, 2009 at 12:05 AM, Ethan Post <post.ethan_at_gmail.com> wrote:

> Is there a way to remove the owner name from the DDL for a create table? I
> can get rid of everything else but not that. Oracle 10G.
>

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

Received on Wed Jul 29 2009 - 03:29:58 CDT