CREATE TABLE AWOLF.FILE_LIST (
  FILE_ID        BIGINT NOT NULL,
  FILE_PARENT    BIGINT,
[куча полей]
  /* Keys */
  PRIMARY KEY (FILE_ID),
  /* Foreign keys */
  CONSTRAINT FILE_PARENTS
    FOREIGN KEY (FILE_PARENT)
    REFERENCES AWOLF.FILE_LIST(FILE_ID)
    ON DELETE CASCADE
    ON UPDATE NO ACTION, 
) IN USERSPACE1@

CREATE TABLE AWOLF.FILE_BLOB (
  FILE_ID       BIGINT NOT NULL,
  FILE_BLOB     BLOB( 2147483647 ) NOT LOGGED,
  FILE_VERSION  BIGINT,
  /* Foreign keys */
  CONSTRAINT FILE_LIST_ID_FK
    FOREIGN KEY (FILE_ID)
    REFERENCES AWOLF.FILE_LIST(FILE_ID)
    ON DELETE CASCADE
    ON UPDATE NO ACTION
) IN USERSPACE1@

INSERT INTO AWOLF.FILE_BLOB(FILE_ID, FILE_BLOB, FILE_VERSION)
with 
a (FILE_ID, FILE_PARENT, [куча полей])
as
(
     SELECT * 
     FROM awolf.FILE_LIST 
     WHERE file_id =  3  --pfile_id
     UNION ALL
     SELECT fl.*
     FROM awolf.FILE_LIST fl, a
     WHERE fl.FILE_PARENT = a.file_id
),
b (file_id, new_file_id) as 
(
select a.file_id, nextval for FILE_LIST_ID_SEQ as new_file_id
from a
),
c(new_file_id, new_parent, FILE_ID, FILE_PARENT, [куча полей])
as(
select id.new_file_id, coalesce(pid.new_file_id,  1 ) as new_parent, a.*
from a
     join b id on a.file_id=id.file_id
     left join b pid on a.file_parent=pid.file_id
),
NEW_FILES AS
(
     SELECT  1  as n 
     FROM NEW TABLE
     (INSERT INTO AWOLF.FILE_LIST(new_file_id, new_parent,  [куча полей])
     SELECT FILE_ID, FILE_PARENT, [куча полей]
     FROM c
     )
)
SELECT c.new_file_id, fb.file_blob, fb.file_version
FROM file_blob fb, c
WHERE fb.file_id = c.FILE_ID