Re: how to clone a table?
From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 22 Aug 2008 09:52:15 -0700
Message-ID: <1219423924.919630@bubbleator.drizzle.com>
>
> This looks like what I need... thanks!!
Date: Fri, 22 Aug 2008 09:52:15 -0700
Message-ID: <1219423924.919630@bubbleator.drizzle.com>
mh_at_pixar.com wrote:
> fitzjarrell_at_cox.net <oratune_at_msn.com> wrote:
>> I would start by extracting the relevant DDL using >> dbms_metadata.get_ddl, then modifying the resulting script. Yet
>
> This looks like what I need... thanks!!
You can also do it using DBMS_REDEFINITION. http://www.psoug.org/reference/dbms_redefinition.html
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Fri Aug 22 2008 - 11:52:15 CDT