1. create table glt_2004 unrecoverable as select * from glh where lhyear > 2005;


You can manipulate with the create statement or insert /*+ append */ ( not sure if it was available in 7.3.4) to extract data that you need.