Re: Copying table: data, structure, AND indexes

Look at Oracle Magazine Interactive web site. In the Code Depot ( http://www.oramag.com/code/cod10116.html ) there is a script to do what I believe you want to do.

doknjas wrote:
>
> How would you copy a table including its indexes? Currently, I use
> create table new_table as select * from old_table;
> but this only creates new_table with the same structure as old_table
> containing old_table's data. old_table's indexes are not created with
> new_table.
>
> Appreciate your thoughts on this. Please email me at:
>
> doknjas_at_netpointer.com
Received on Thu Jul 24 1997 - 00:00:00 CDT