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