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