Revision 7053
Added by ben leinfelder over 12 years ago
| xmltables-oracle.sql | ||
|---|---|---|
| 333 | 333 |
CREATE TABLE xml_path_index ( |
| 334 | 334 |
nodeid NUMBER(20), -- the unique node id |
| 335 | 335 |
docid VARCHAR2(250), -- index to the document id |
| 336 |
path VARCHAR2(1000), -- precomputed path through tree
|
|
| 336 |
path VARCHAR2(4000), -- precomputed path through tree
|
|
| 337 | 337 |
nodedata VARCHAR2(4000), -- the data for this node e.g., |
| 338 | 338 |
nodedatanumerical NUMBER(20), -- the data for this node if |
| 339 | 339 |
nodedatadate TIMESTAMP, -- the data for this node if it is a date |
Also available in: Unified diff
increase amount of text the 'xml_path_index.path' column can accommodate. I was seeing errors like this during indexing:
knb 20120312-11:42:05: [ERROR]: DocumentImpl.buildIndex - SQL Exception while indexing document knb-lter-and.3147 : ERROR: value too long for type character varying(1000) [edu.ucsb.nceas.metacat.DocumentImpl]