Comtech-ef-data NetVue Release 1.1 User Guide Manuale Utente Pagina 224

  • Scaricare
  • Aggiungi ai miei manuali
  • Stampa
  • Pagina
    / 265
  • Indice
  • SEGNALIBRI
  • Valutato. / 5. Basato su recensioni clienti
Vedere la pagina 223
Advanced Configuration (System Display) Revision 3
NetVue User Guide MN-NETVUE
1087
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;
Vedere la pagina 223
1 2 ... 219 220 221 222 223 224 225 226 227 228 229 ... 264 265

Commenti su questo manuale

Nessun commento