1.数据库perm大小为10G
Create database testbase as perm=10E9,spool=10E9;
2.创建物理表
create multiset table stg(
stg decimal(,) title'总贷款'
)
no primary index
;
3.创建可变临时表
create volatile multiset table vt_pdm ,no log(
stg decimal(,)
) no primary index on commit preserve rows;