Re: Copying table: data, structure, AND indexes

From: Steve Phelan <stevep_at_toneline.demon.co.uk>
Date: 1997/07/23
Message-ID: <869661206.25542.0.nnrp-4.c2de712e@news.demon.co.uk>#1/1

Look at using the Oracle IMPort/EXPort utilities.

Steve Phelan.

doknjas wrote in article <5r48ov$4gg$2_at_news.smartt.com>...

>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 Wed Jul 23 1997 - 00:00:00 CDT