Re: Import/Export

EN: How To export and import data from a oracle database

FR: Comment exporter et importer des données à partir d'une base de données oracle

Under SQL

SQL> create table table_tempo as select * from table where corig='A';

SQL> select count(*) from table_tempo ;

Under Dos

DOS> exp userid=user/password_at_ file=table_tempo tables=table_tempo

DOS> imp userid=user/password_at_base file=table_tempo.dmp DOS> tables=table_tempo commit=y ignore=y

Under SQL

SQL> insert into table select * from table_tempo;

SQL> commit;

And then DROP the table_tempo

NOTE: You have to pass by a tempo table if your oracle version is 8i

      and under. the next version allows you the where clause for
      import data.

Yours,

Paul Lorillou

--
Posted via http://dbforums.com