Restore multiple tables

The schema command file in this example extracts a table test1:tlr_1 and test1:tlr_2 from the most recent backup of dbspace1 and places the data in test1:tlr_1_dest and test1:tlr_2_dest. This is an efficient way of restoring multiple tables because it requires only one scan of the archive and logical log files.

database test1;
create table tlr_1 
  (  columns  ) in dbspace1;
create table tlr_1_dest (  columns  ); 
create table tlr_2 
  (  columns  ) in dbspace1;
create table tlr_2_dest (  columns  );
insert into tlr_1_dest select * from tlr_1;
insert into tlr_2_dest select * from tlr_2;