easiest way to clone a table?

From: <mh_at_pixar.com>
Date: Wed, 24 Sep 2008 00:14:22 GMT
Message-ID: <yDfCk.1142$x%.1090@nlpi070.nbdc.sbc.com>


Given a table FOO, what is the easiest way to create a table COPY_OF_FOO that has identical schema, indexes, etc.?

Preferrably something that can be scripted or performed programatically, and not via Toad, etc.
etc.

Many TIA!
Mark.

-- 
Mark Harrison
Pixar Animation Studios
Received on Tue Sep 23 2008 - 19:14:22 CDT

Original text of this message