CONNECT system/manager;
DROP USER samp CASCADE;
DROP DIRECTORY AUDIO_DIR;
DROP DIRECTORY FRAME_DIR;
DROP DIRECTORY PHOTO_DIR;CREATE USER samp identified by samp;
GRANT CONNECT, RESOURCE to samp;
CREATE DIRECTORY AUDIO_DIR AS '/tmp/';
CREATE DIRECTORY FRAME_DIR AS '/tmp/';
CREATE DIRECTORY PHOTO_DIR AS '/tmp/';
GRANT READ ON DIRECTORY AUDIO_DIR to samp;
GRANT READ ON DIRECTORY FRAME_DIR to samp;
GRANT READ ON DIRECTORY PHOTO_DIR to samp;
CONNECT samp/samp
CREATE TABLE a_table (blob_col BLOB);
CREATE TYPE Voiced_typ AS OBJECT (
Originator VARCHAR2(30),
Script CLOB,
Actor VARCHAR2(30),
Take NUMBER,
Recording BFILE
);CREATE TABLE Multimedia_tab (
Clip_ID NUMBER NOT NULL,
Story CLOB default EMPTY_CLOB(),
FLSub NCLOB default EMPTY_CLOB(),
Photo BFILE default NULL,
Frame BLOB default EMPTY_BLOB(),
Sound BLOB default EMPTY_BLOB(),
Voiced_ref REF Voiced_typ,
InSeg_ntab InSeg_tab,
Music BFILE default NULL,
Map_obj Map_typ
) NESTED TABLE InSeg_ntab STORE AS InSeg_nestedtab
DROP USER samp CASCADE;
DROP DIRECTORY AUDIO_DIR;
DROP DIRECTORY FRAME_DIR;
DROP DIRECTORY PHOTO_DIR;CREATE USER samp identified by samp;
GRANT CONNECT, RESOURCE to samp;
CREATE DIRECTORY AUDIO_DIR AS '/tmp/';
CREATE DIRECTORY FRAME_DIR AS '/tmp/';
CREATE DIRECTORY PHOTO_DIR AS '/tmp/';
GRANT READ ON DIRECTORY AUDIO_DIR to samp;
GRANT READ ON DIRECTORY FRAME_DIR to samp;
GRANT READ ON DIRECTORY PHOTO_DIR to samp;
CONNECT samp/samp
CREATE TABLE a_table (blob_col BLOB);
CREATE TYPE Voiced_typ AS OBJECT (
Originator VARCHAR2(30),
Script CLOB,
Actor VARCHAR2(30),
Take NUMBER,
Recording BFILE
);CREATE TABLE Multimedia_tab (
Clip_ID NUMBER NOT NULL,
Story CLOB default EMPTY_CLOB(),
FLSub NCLOB default EMPTY_CLOB(),
Photo BFILE default NULL,
Frame BLOB default EMPTY_BLOB(),
Sound BLOB default EMPTY_BLOB(),
Voiced_ref REF Voiced_typ,
InSeg_ntab InSeg_tab,
Music BFILE default NULL,
Map_obj Map_typ
) NESTED TABLE InSeg_ntab STORE AS InSeg_nestedtab
建议用clob 代替long
BLOB 代替 Long raw
就可以支持多个clob或者blob