oracle administratrion

[atul]

How to convert data from paradox to oracle
without using sqlloader ?
Is there any tool which converts?
Can Migration work bench convert from paradox to oracle?
This process should be regular i.e. Twice a week..
Is there any ETL tools are available like oracle datawarehouse builder which will convert this data?

[marist89]

Can you use ODBC with Paradox? If so, create a paradox database, attach via ODBC your oracle tables, and do the operations from paradox.

[atul]

Yes , we can connect paradox through odbc ..

but from that i will connect to paradox ..
how i can convert that data into oracle tables ?
Can you please explain ?

[marist89]

It's been a while since I used paradox, but the gist of it would be something like:
1. create tables on oracle database
2. attach the tables to your paradox database
3. perform an insert/append query from your paradox table to your attached oracle table

[atul]

how to attach the tables to your paradox database
from oracle database?

[marist89]

via ODBC. I am unclear of the exact Paradox commands.

[atul]

Is there any tool which we can use?

I have mentioned some tools above .

Will it be possible through one of them ?