creating table from data, writing out data from SQLplus
How can I write out a data selection into a file or some SQL which I can import into another database.
Scenario: database A:
create view x as select SACH_NR from IDENT_DATEN where KLASS_ART = 'W' and KLASS_TYP = 'K';
write out this selection in some form to a file or something.
database B:
create table X (SACH_NR VARCHAR(50));
now load the data from above selection/file into this table.
Thanks.
Christoph