Re: Exporting data from Oracle

Yaroslav Perventsev schrieb:
>
> One way to do this:
> create table new_table as select * from old_table
>

and then

drop old_table;
rename new_table to old_table;

Ciao, Christian

> 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 Thu Apr 27 2000 - 00:00:00 CDT