Re: DBMS_METADATA Remove User ID

  • From: Maxim <mdemenko@xxxxxxxxx>
  • To: post.ethan@xxxxxxxxx
  • Date: Wed, 29 Jul 2009 10:29:58 +0200

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@xxxxxxxxx> 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.
>

Other related posts: