数据库创建脚本

网络服务名： nongji
主机名：     192.168.40.75
服务名(SID)：base
用户名：     nongji
密码：       nongji

 

--创建表空间
create tablespace nongji
logging
datafile'D:\app\Administrator\oradata\nongji\nongji.dbf'
size 50m
autoextend on
next 50m maxsize 2048m
extent management local;

--创建用户
create user nongji identified by nongji
default tablespace nongji
temporary tablespace temp;

--授权
grant dba to nongji;

 

--修改密码
alter user jirui identified by jirui;

 

--导入数据
imp nongji/nongji@nongji file=c:\jiruidb.dmp full=y ignore=y

 

按提示进行导出
exp nongji/nongji@nongji

导出完整数据库(full=y 表示导出全部，full=n 表示不导出全部；grants=n 表示不导出权限)
exp nongji/nongji@nongji file=C:\jiruiDB_bak.dmp full=n grants=n;

导入完整数据库
imp nongji/nongji@nongji file=C:\jiruiDB.dmp log=F:\jiruiDB.txt full=y ignore=y;

一般情况下不需要导入完整数据库，只要结构和数据就可以了【full不可与fromuser、touser一起使用】

要么    imp nongji/nongji@nongji file=C:\jiruidb.dmp full=y ignore=y;

要么    imp nongji/nongji@nongji file=C:\jiruidb.dmp fromuser=jirui touser=jiruidb;

 

--创建序列和触发器

-- Create sequence
create sequence SEQ_TableName
minvalue 1
maxvalue 9999999999
start with 1
increment by 1
cache 20;

--Create Trigger
CREATE OR REPLACE TRIGGER TR_TableName
  BEFORE INSERT ON TableName
  FOR EACH ROW
begin
  SELECT SEQ_TableName.NEXTVAL INTO :NEW.ID FROM DUAL;
end;