Re: Export/Import Using Oracle XML

So I take it that means you aren't sure of a best approach in regards to this problem either, no?

I completely understand that XML has it's place in some projects and not in others. It is clear to me that for large data exports/imports, XML would NOT be the way to go, but in my case, where I'm dealing with small amounts of data that need to be in a format EASILY readable and manipulated by a user that might not know SQL, but could understand XML, my approach seems to be the best solution.

If anyone is familiar with a better solution, I would welcome any additional options.

Thanks for your help guys/gals!
Leo

"Nuno Souto" <wizofoz2k_at_yahoo.com.au> wrote in message news:73e20c6c.0306251914.293fd823_at_posting.google.com...
> "koert54" <nospam_at_nospam.com> wrote in message
news:<YBmKa.687$P26.1691_at_afrodite.telenet-ops.be>...
>
> > http://www.interealm.com/tao/parchxml.html
> >
>
> LOL!
> <quote>
> Disgraced, the IT Architect rose from the table, quickly excused
> himself from the meeting and was never heard from again.
> </quote>
>
> If only! I once had a GSA "architect" impose on me that
> it was faster to offload data from Oracle into a flat file,
> sort it using Solaris quick-sort and then upload it again
> than it was to sort it inside Oracle. When I pointed out
> the flat file data for the sort would be around 60Gb, the
> reply was : "so?".
> So I let him prove it. Haven't seen him again anywhere
> with the tag of "architect". There is a God!
>
> PS: Now we have XML architects. Myself and our Java guru spent
> an afternoon explaining to one why it wasn't a good idea to
> write an entire framework just to cache and sort XML-based entity
> Java Beans when it takes three orders of magnitude less overhead
> to get the rows off the database in the order he wanted,
> already as DOM-trees.
>
> His main concern was string searches and sorts are "very
> heavy" and could cause the database server to thrash.
> Number of users? 20.
>
> But I'm sure it's just me...
> Cheers
> Nuno Souto
> wizofoz2k_at_yahoo.com.au.nospam
Received on Thu Jun 26 2003 - 07:46:12 CDT