Importing Oracle's DUMP files in Informix 
Author Message
 Importing Oracle's DUMP files in Informix
Hi All!

Any help towards the subject is wellcome: HOW-TO, tips and tricks, etc...

Thanks a lot in advance,
Sergei



Sat, 20 Mar 2004 18:00:07 GMT
 Importing Oracle's DUMP files in Informix

En Serge Moisseyev va escriure el dia  2 Oct 2001, a les 12:00:

Quote:
> Hi All!

> Any help towards the subject is wellcome: HOW-TO, tips and tricks, etc...

> Thanks a lot in advance,
> Sergei

I supose Oracle DUM file = ascii flat file with a <LF> by row.
If this it's correc you can use dbload:

See Informix migration guide for more detailed help.

---------------------------------------
 Isidre PONS ROCA
 BASE - Gesti d'Ingressos Locals
 (Diputacio de Tarragona)
 Servei de Sistemes d'Informacio
 Av President Lluis Companys 12-C
 43005 - Tarragona
 SPAIN
 Tel # +34 977 236731
 Fax # +34 977 227302
 http://www.base.es

---------------------------------------



Sat, 20 Mar 2004 19:20:32 GMT
 Importing Oracle's DUMP files in Informix

Quote:

>Hi All!

>Any help towards the subject is wellcome: HOW-TO, tips and tricks, etc...

>Thanks a lot in advance,
>Sergei

I suppose you are talking about an oracle export.
You will need to change the export file into a delimited file
Never done it, but I would try the following:
1: exp with option compress=N
The result is not completely a comma delimited file, but has to be cleaned
2: Look with head and tail what the file looks like
3: Use awk to clean it (sed might also do it and perl certainly can. If not
too big you could use an editor)
4: Load it into Informix with dbload.

Joachim.
--

WWW http://www.xs4all.nl/~jcdverha/  (Science Jokes)



Sun, 21 Mar 2004 01:25:54 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. importing an Oracle 7 dump file into 8

2. import a dump file from another oracle question.

3. importing Oracle's DAT files into SQL Server

4. Importing a Dump from Oracle 7.3 into Oracle Personal Edition 8

5. Editing dump file before Import??

6. Import dump file from 8.0.5 to 8.1.5

7. Help-Stored Procedures became invalid after the dump file was imported

8. Partially Import from a dump file

9. Cant import backup from dump file

10. Filemaker 'capture'/read/store imported file name

11. another try: Filemaker 'capture'/read/store imported file name

12. How know a dump file's characterset?


 
Powered by phpBB® Forum Software