Create globaltemporary table temp_temporary_001 ( Field1varchar2(100), Fiels2varchar2(1000) ) On commit preserve rows ;