Getting data from Oracle to Texis

Post Reply
nealp
Posts: 1
Joined: Wed Jan 03, 2001 4:28 pm

Getting data from Oracle to Texis

Post by nealp »

Hello

We have a bit of a problem. We need to get a large amount of data (10000+ rows) from 3 oracle tables into texis. This is a brand new install of thunderstone. Since the texis database files are not a standard database file such oracle. How do we get data from oracle into texis?? Is there a utility or procedure that will make this easier for us?..So far all we can come up with is to write a cgi script and have it pull the data one row at a time and do inserts into the texis tables. However we're worried about the scripts timingout for such a large amount of data. I'm sure this question has been asked before. Any help would be greatly appreciated.
Thanks
neal
User avatar
mark
Site Admin
Posts: 5513
Joined: Tue Apr 25, 2000 6:56 pm

Getting data from Oracle to Texis

Post by mark »

You have several options.

1) Use Oracle's dump to dump the data then timport to import the data.
See http://thunderstone.master.com/texis/ma ... 1&q=oracle

2) Export the Oracle data in some other ascii format for which you can write a timport schema. See http://thunderstone.master.com/texis/ma ... mport&s=.1

3) Some variation of your CGI script idea. You can make the vortex timeout infinite with <timeout=-1></timeout> ( http://thunderstone.master.com/texis/ma ... &q=timeout ). And run the script from a shell prompt instead of from the web as a CGI ( http://thunderstone.master.com/texis/ma ... ation&s=.2 ).
Post Reply