Perform a distributed restore

The schema command file in this example extracts a table test:tlr_1 from the most recent backup of dbspace1 and places the data on the database server rem_srv in the table rem_dbs:tlr_1.

database rem_dbs
create table tlr_1 
   ( columns  );
database test1;
create table tlr_1 
  (  columns  ) in dbspace1;
insert into rem_dbs@rem_srv.tlr_1 
  select * from tlr_1;