创建用户并授权
SQL> create user samp identified by samp;

User created.

SQL> grant connect, resource to samp;

Grant succeeded.

SQL> GRANT CREATE ANY DIRECTORY to samp;

Grant succeeded.

SQL> CONNECT samp

Enter password:

Connected.

创建directory，上传拷贝图像文件到directory目录

SQL> CREATE OR REPLACE DIRECTORY my_directory_object AS '/tmp';

Directory created.

[root@localhost script]# cp /media/sf_hostmnt/20160831.png /tmp/

[root@localhost script]# chown oracle:oinstall /tmp/20160831.png

创建表，插入数据

SQL> CREATE TABLE print_media

( product_id NUMBER(6)

, ad_id NUMBER(6)

, ad_composite BLOB

, ad_sourcetext CLOB

, ad_finaltext CLOB

, ad_fltextn NCLOB

, ad_photo BLOB

, ad_graphic BFILE

); 2 3 4 5 6 7 8 9 10

Table created.

SQL> INSERT INTO print_media VALUES (1726, 1, EMPTY_BLOB(),

'my Oracle', EMPTY_CLOB(), EMPTY_CLOB(),

NULL, BFILENAME('my_directory_object', '20160831.png'));

1 row created.

ITPub博客

Oracle 11g 向表中大字段插入数据