oracle 执行sql出错了就回滚

比如执行如下语句：
grant create any directory to system;/
create directory tmp as 'C:\Users\guozhixing\Desktop\案例\web\圈人\img';
/create table FACELOOK_ACTIVITY
(
  FA_ID       NUMBER(10) not null,
  FU_USER_ID  VARCHAR2(20) not null,
  FA_TIME     DATE not null,
  FA_TYPE     NUMBER(6) not null,
  FP_PHOTO_ID NUMBER(10) not null,
  FC_ID       NUMBER(10),
  FM_ID       NUMBER(10)
)
等等当中出错了，就回滚全部