Re: Importing Paradox data

Well, you could try Lotus Approach.

"Johan Stinckens" <johan.stinckens_at_anaxis.be> wrote in message news:3ab1c658$0$612$5a62924d_at_news.skynet.be...
> I've contacted Oracle Support about this problem and the solution is to
 use
> Oracle's Heterogeneous Services. There aro two agent-types that use
> Heterogeneous Services (HS) ; Transparent Gateways and Generic
 Connectivity.
> It is the Generic Connectivity that provides ODBC and OLE DB-agents, with
> which you can connect to a NON-Oracle database, providing you have the
> correct ODBC or OLE DB-driver.
>
> I've been setting up this configuration on a test-database and it works
> fine. You can even use data-dictionary views on the non-oracle database.
>
> I wrote a script that uses the 'Create table as select * from' command to
> import the tables into Oracle.
> This works fine, but I discovered one 'major' problem. The MEMO datatype
 in
> Paradox is not converted correctly. I receive an Oracle error : ORA-03001
> unimplemented feature.
> This problem I need to get resolved, because a lot of the tables contain
 at
> least one Memo-field.
>
> Does anybody have any idea for altering or specifying the
> conversion-datatype for the MEMO-field in HS.
>
> Documents on Heterogeneous Services can be found in the "Oracle8i
> Distributed Database Systems" documents at :
>

 http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.
> 817/index.htm
>
>
> "Johan Stinckens" <johan.stinckens_at_anaxis.be> wrote in message
> news:3aaf30a3$0$386$446d705c_at_news.skynet.be...
> > I need to import aprox. 55 paradox-tables into an Oracle Database. Does
> > anybody know a way to do this. Is there any Oracle tool to complete this
> > task in a flexible way.
> >
> > I need to do this import more than once, because were are currently
 still
 in
> > the developing-phase for the product. As a result I will need to do the
> > import all over again when the customer will switch to the new
 application.
> > Therefor I would like a tools were I can save the parameters for the
 import
> > in a configuration-file so that I do not need to check a lot off
 parameters
> > when this production-import will be launched.
> >
> > At the moment I'm trying to produce the import through SQL-Loader.
> >
> > So if anybody knows any other tool, or has some tips on using SQL-Loader
 for
> > this procedure, please let me know.
> >
> > Thanks.
> >
> >
>
>
Received on Fri Mar 16 2001 - 21:57:41 CET