Comtech EF Data NetVue Release 1.1 User Guide - Manual (Page 224)

Advanced Configuration (System Display) Revision 3
NetVue User Guide MN-NETVUE
10–87
10.9.2.3.2 Oracle database
If the central database is an Oracle database, every NetVue that is instructed to offload (some of) its data,
logs on to a shared folder on the server that is hosting the central database. Files containing the data to
be offloaded are put in this shared folder.
Next, on the central database, run a query to insert the offloaded file contents into the central database.
The query could be similar to this example:
CREATE OR REPLACE DIRECTORY ext AS
'C:\Documents and Settings\All Users\Documents\NetVueOffload\';
// Path to be defined in db.xml: RemoteFileShare@localPath
CREATE TABLE load ORGANIZATION EXTERNAL
(type oracle_loader default directory ext access parameters
(records delimited by newline nologfile fields terminated by X'09'
missing field values are null reject rows with all null fields
("ID" CHAR(5), "VALUE" CHAR(200))) LOCATION ('filename.dat') );
// Creation of an external table pointing to the data file that
// was placed in the shared folder by a NetVue
INSERT INTO table (SELECT * FROM load);
// Copy data from the data file to the database
DROP load;