Re: DBMS_METADATA Remove User ID
From: Mathias Magnusson <mathias.magnusson_at_gmail.com>
Date: Wed, 29 Jul 2009 08:24:39 +0200
Message-ID: <8580d4110907282324l5c0a60c5qf3843e3a7b71b11b_at_mail.gmail.com>
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.
Date: Wed, 29 Jul 2009 08:24:39 +0200
Message-ID: <8580d4110907282324l5c0a60c5qf3843e3a7b71b11b_at_mail.gmail.com>
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_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-lReceived on Wed Jul 29 2009 - 01:24:39 CDT