SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Techinical issue loading an XML file in to database

User_GTJEPMay 16 2012 — edited May 16 2012

hi,

i am trying to load an XML file into Oracle database using SSIS 2005. the XML file is huge with 4000+ columns and also has many sub catogoreys. if i try to load the file using XSD it is taking lot of space to read the entire file upto 10GB even if the data row in the file is only one. I am only loading 60 columns out of the 4000+ columns. please provide me any alternatives that you can think of.

Thanks in advance.

Deb

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 13 2012

Added on May 16 2012

7 comments

404 views