oracle清空所有表数据

小蚂蚁

方法：
1. 删除所有外键约束
2. drop表
3. 添加外键约束
代码使用powerdesign生成

/*==============================================================*/ 
/* DBMS name:   ORACLE Version 10g        */ 
/* Created on:   2013/8/16 14:30:03        */ 
/*==============================================================*/ 
 
 
alter table Da_pic 
  drop constraint FK_DA_PIC_REFERENCE_DA_PICSU; 
 
drop table Da_pic cascade constraints; 
 
drop table Da_picsubject cascade constraints; 
 
/*==============================================================*/ 
/* Table: Da_pic            */ 
/*==============================================================*/ 
create table Da_pic ( 
  ID      VARCHAR2(200)      not null, 
  no      VARCHAR2(200), 
  subjiectid    VARCHAR2(200), 
  Name     VARCHAR2(400), 
  UploadTime    DATE, 
  UserId    VARCHAR2(200), 
  picdate     DATE, 
  place    VARCHAR2(200), 
  people    VARCHAR2(200), 
  event    VARCHAR2(200), 
  background    VARCHAR2(200), 
  cameramen    VARCHAR2(200), 
  serial    INTEGER, 
  IsEffect     VARCHAR2(200), 
  constraint PK_DA_PIC primary key (ID) 
); 
 
/*==============================================================*/ 
/* Table: Da_picsubject           */ 
/*==============================================================*/ 
create table Da_picsubject ( 
  ID      VARCHAR2(200)      not null, 
  no      VARCHAR2(200), 
  title    VARCHAR2(200), 
  year     VARCHAR2(200), 
  type     VARCHAR2(200), 
  gdtime    DATE, 
  iseffect     VARCHAR2(200), 
  seiral    INTEGER, 
  constraint PK_DA_PICSUBJECT primary key (ID) 
); 
 
alter table Da_pic 
  add constraint FK_DA_PIC_REFERENCE_DA_PICSU foreign key (subjiectid) 
   references Da_picsubject (ID);