Re: Exporting data from Oracle

One way to do this:
create table new_table as select * from old_table

chrisjlewis_at_my-deja.com ÐÉÛÅÔ × ÓÏÏÂÝÅÎÉÉ <8e2lqp$kb4$1_at_nnrp1.deja.com> ...
>Hi,
>
>I'm fairly new to Oracle, and was wondering what the best way is to export
>data from a table that needs to be re-created. I know in Sybase one can do
 a
>"data dump", re-create the table, and then import the data back in. What's
>the best way to do this in Oracle?
>
>Thanks,
>Chris
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Wed Apr 26 2000 - 00:00:00 CDT