select 'create table ' || b.OWNER || '_' || b.TABLE_NAME ||
' nologging as select * from ' || b.OWNER || '.' || b.TABLE_NAME ||
'@dblink;'
from temp_table t, dba_tables b
where t.owner = b.OWNER
and t.object_name = b.TABLE_NAME
' nologging as select * from ' || b.OWNER || '.' || b.TABLE_NAME ||
'@dblink;'
from temp_table t, dba_tables b
where t.owner = b.OWNER
and t.object_name = b.TABLE_NAME