temporary table ,hint,over(),imp

create global temporary table  CLTBALANCE
(
  AMOUNT                 NUMBER(21,6),
  DEDATE              DATE,
  ECONTRACTENDDATE   DATE,
  ECONTRACTSTARTDATE DATE
)
on commit preserve rows;

 

 

用Hint 提示减少操作时间

    INSERT   /*+Append*/   INTO     tab1
                SELECT   *   FROM   tab2;

 

 

over()函数：
 ROW_NUMBER() over(ORDER BY NVL(T.Balance, 0.00) DESC, T.TNAME ASC) AS vol

 

 

备份：
create tablespace repspace datafile 'f:\aa.dbf' size 2g;
create user u identified by pass default tablespace t_space;
grant connect,resource,dba to u;
alter user u quota unlimited on t_space;
imp u/pass file='f:\wee.dmp' fromuser=other touser=u