Re: how to clone a table?
Date: Sun, 24 Aug 2008 13:58:33 -0700 (PDT)
On Aug 22, 11:52 am, DA Morgan <damor..._at_psoug.org> wrote:
> m..._at_pixar.com wrote:
> > fitzjarr..._at_cox.net <orat..._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
> damor..._at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org
Or via DBMS_METADATA.GET_DDL, which I failed to mention.
David Fitzjarrell Received on Sun Aug 24 2008 - 15:58:33 CDT