Re: Oracle data export

christopher.lewis_at_ac.com wrote:
> I'm fairly new to Oracle and was wondering about the best way to
> export/import data from tables that need to be re-created. I know that
> in Sybase one can do a data dump, re-create the table, and import the
> data back in. I'm just wondering how this is done in Oracle.

There are a number of ways to do this. If your userid has rights to create tables, I'd do it this way:

1. create table temp_table as ( select * from table_to_be_changed );
2. drop table table_to_be_changed;
3. Re-create the table (I'll call it 'new_def_table') that needed to be changed with the new desired table defs.
4. insert into new_def_table ( select * from temp_table );
5. drop table temp_table;
6. commit;

If you don't have create rights in the database, you can use SQL*Plus or TOAD to extract the data to a flat text file.

cheers,
bob Received on Tue Apr 25 2000 - 00:00:00 CDT