DDL for tables using indexfile

[fraze]

I'm after the DDL for creating tables using the INDEXFILE option for imp, However I'm still getting broken lines in the file - column names are spilt across lines, giving me an error when running the script:
e.g
REM ("OWNER","IPADDR_BYTE1","IPADDR_BYTE2","IPADDR_BYTE3","IPADDR_BY
REM TE4_UPPERLIMIT","IPADDR_BYTE4_LASTUSED") USING INDEX

Does anyone know anyway to get round this?

Using 8.1.6 on Sun 5.8

Thanks,

[fraze]

Have also tried the import on a 9.2.0.3 database but get the same problem so I dont think it can be a version issue

[fraze]

Can anyone suggest a way to extract table DDL from an 8.1.6 database if the indexfile approach isnt valid?

[jovery]

Take a look at the free version of DataBee from the following

http://www.databee.com/

It's a quick an easy method of extracting DDL from export files.

HTH

[jovery]

...Or if you have a 9i database you can use the DBMS_METADATA package.

[fraze]

Unfortunately we're stuck at 8.1.6 as its a third part application! For anyone whos interested it seems to be a version problem - according to Tom Kyte the problem was fixed at 8.1.7 and he cant think of a work around so I'm pretty much up the creek I think! Will have a look at databee and see if thats any help.