Re: DBMS_METADATA Remove User ID

  • From: Mathias Magnusson <mathias.magnusson@xxxxxxxxx>
  • To: post.ethan@xxxxxxxxx
  • Date: Wed, 29 Jul 2009 08:24:39 +0200

You need to let us know the tool you are using. The easiest way is to never
write it into the scrip you use to create the table in the first place...
But assuming the table was not created with a script and now needs to be
moved, there are more than one choice for how to move the structure.

dbms_meta_metadata? Datapump? Old imp/exp?
Mathias

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: