Oracle Database Discussions

PLATFORM AND O/S VERSION: RedHat Linux 7.2, Kernel 2.4.9-21smp, Oracle 8.1.7.4
MIGRATION WORKBENCH VERSION: 9.2.0.1.2 (Windows 2000, ServicePack 2)
THIRD-PARTY DATABASE AND VERSION BEING MIGRATED: MySQL 3.23.41


Hi there,

I urgently need to migrate a mysql (3.23.41) database (7.1 GB) into Oracle 8i (8-1-7-4),
but faced a lot of problems during migration.(capturing went well):

1. ORA-01843: not a valid month
2. java.lang.OutOfMemoryError

For error no. 1:

Here comes a description of a suspicious source table(mysql), which has a 'datetime' (column: 'created')
in it:

mysql> desc analysisprocess;
-----------------------------------------------------------------------------------+
| Field | Type | Null | Key | Default | Extra |
-----------------------------------------------------------------------------------+
| analysisId | int(10) unsigned | | PRI | NULL | auto_increment |
| created | datetime | | | 0000-00-00 00:00:00 | |
| logic_name | varchar(40) | | | | |
| db | varchar(120) | YES | MUL | NULL | |
| db_version | varchar(40) | YES | | NULL | |
| db_file | varchar(120) | YES | | NULL | |
| program | varchar(80) | YES | | NULL | |
| program_version | varchar(40) | YES | | NULL | |
| program_file | varchar(80) | YES | | NULL | |
| parameters | varchar(80) | YES | | NULL | |
| module | varchar(80) | YES | | NULL | |
| module_version | varchar(40) | YES | | NULL | |
| gff_source | varchar(40) | YES | MUL | NULL | |
| gff_feature | varchar(40) | YES | MUL | NULL | |
-----------------------------------------------------------------------------------+
14 rows in set (0.00 sec)

I tried to map the 'date' datatype from mysql into the date datatype in oracle, but always
got the ora-01843 error.- How can I EXACTLY set 'NLS_DATE_FORMAT'/'NLS_DATE_LANGUAGE' to fit?
Or is there any other solution? (NLS_LANGUAGE is being initialized as 'AMERICAN')


For error no. 2:

I tried using Java 1.3.1 (which comes with omwb) and java 1.4.0_02.
RAM(on notebook running OMWB ): 256 MB; javaw -mx1024m.
Virtual Memory on machine running OMWB: 1024 MB.

Unfortunately, there was now success. What else can I do?

Is there any possibility to have a look at the generated sql (inserts etc.)
during migration?

Your help is highly appreciated. Thanks for your effort in advance.

Best Regards,
Dan


P.S.: I also tried to use Oracle 9i with 'date' to 'timestamp' mapping, but also got 'ora-01843'
error and additionaly:

'Failed to create default for Table :HOMO_SAPIENS_CORE_8_30.ANALYSISPROCESS; ORA-00907: missing right parenthesis'