Re: Informix tables into Oracle

Hi Anders,

    For each of the tables you want to port run the following two programs and put the output in the same directory:

        Create text files from Informix tables using unload. (End the file name with .dat)

        Run dbschema -d <database_name> -t <table_name> -p -ss <table_name>.sql

    Next exit the <table_name>.sql file(s). Delete the first two lines and you are left with a create table statement. You will find that the syntax for constraints is somewhat different and that you will have to edit them. The only other editing you will have to do is to delete or change the in dbspace and extent clauses. (I set up defaults for the users default tablespace and don't bother using them).

    Create the Oracle tables. The easiest way is to start up sqlplus from the directory containing the *.sql files you created and then run them one at a time using:

        @<table_name>

    Next build Oracle SQL*Loader control files for each table using the model and name them using the pattern <table_name>.ctl :

        LOAD DATA
        INFILE '<full_path_name>'
        BADFILE '<full_path_name>.bad'
        INSERT INTO TABLE <table_name>
        FIELDS TERMINATED BY '|'
        (
            user_id            VARCHAR2(12),
            user_name    VARCHAR2(20),
            group_name    VARCHAR2(10)
        )

    Finally, run the SQL*Loader from the directory with the data files using the command:

        sqlldr <user>/<password> control=<table_name>

regards

Jerry

Anders Gunnare wrote in message <361DCD74.F9D41E24_at_lule.frontec.se>...
>Hello World,
>
>Which is the simpliest way to do the following:
>
>1) take a table from Informix
>2) make that table exact as it was in Informix but now is it in Oracle
>with all the values.
>
>Or haow do I import a textfile into an Oracle db ?
>
>I'm driving on a Unix.
>
>--
>Best regards
>Anders Gunnare
>
>
>
>===============================================================
>"Impossible only means that you haven't found the solution yet"
>===============================================================
> Frontec Norr AB
> Anders Gunnare
> anders.gunnare_at_lule.frontec.se
> Aurorum 1
> S-977 75 Luleå
> Sweden
>
> +46 (0) 920 752 09
>===============================================================
>
>
>
Received on Fri Oct 09 1998 - 00:00:00 CDT