1、在oracle中建一个虚拟目录对应实际目录(存放图片的目录)
create directory PHOTO as 'D:\photo';
2、将这个目录的权限赋予scott用户
grant read,write on directory PHOTO to scott;
3、创建测试表
create table person(pid varchar2(32) primary key,photo blob);
create directory PHOTO as 'D:\photo';
grant read,write on directory PHOTO to scott;
create table person(pid varchar2(32) primary key,photo blob);