Re: how to clone a table?

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