problem with large xml-document and large xml-element
470904Nov 22 2005 — edited Nov 23 2005Hi everybody,
i hope some of you can help me.
(I'm working with Oracle9iR2.)
I've two problems:
1. The documents i'm trying to put into Oracle have a size of 30-70 mb.
A document contains several informations and one element, which contains a sequence of dna with 20-45 million characters. Due to the size of the element i annotated to save this element as a CLOB.
The problem is, that not the whole sequence is stored. Only a few thousands of characters are stored ( i tried to query substrings of the CLOB and met the problem). I've 12 xml-documents ( each representing one chromosome of rice). But the dna-sequences of the documents are not "cut" at the same position.
2. To load the documents into the repository i use ftp/WebDAV. I can't load documents with a size of 53 mb or more into the repository. I'm getting an error (ORA-00600: internal error code, arguments: [733], [67107908], [pga heap], [], [], [], [], []).
thanks in advance
Nick
Message was edited by:
Nick_MD