Sorry I misunderstood your question

Here is what you can try

Rename the same table to its new name

alter table table_name (empty_table) rename to new_name

and then use export the table from production
and do an import

cheers

Parveen

Tofigh Mike (NIH/NEI) [C] wrote:
> Hello:
>
> I have a empty table that I do not want to delete it, but I want to
> import same table from the production system. What do thing is the best
> way to do this.
>
>
> Thanks
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>


Oracle LazyDBA home page