Re: Converting UNIFY to ORACLE database

Hi,

we're using a shellskript that generates SQLs for selecting and ctl-files for inserting. The SQLs write ASCII-Files for (about 300) tables in a format that can be used for sqlload. The output of the SQL should be piped through an sed to eliminate the leading and trailing blanks and you need a dedicated field separator. This separator makes trouble if it is part of any field !
If you still got some questions, mail me. Is oracle running under unix, too, or do you have an database connection from the OS (with the unify-DB) to the oracle-db. This is helpful :-)

Ciao,

        Holger

P.S.: One special point is the language variable. You should try some small tables using text with special characters. The application with the oracle-db should display and behave as you need it, but this might not work with the first try :-)

Bernard wrote:

> I have to convert a UNIFY database to a ORACLE database.
> Is there any utilitie that do that ?
> Can someone help me ?
>
> Thank's.
>
Received on Sun May 26 2002 - 14:37:26 CDT