Editing PDE files

[Rafal]

Hi,

I exported a table containing a LONG column, edited the file and tried to import back to the database. However, I got an incorrect checksum error. I realise that this is a result of changes I made to the PDE file, but I need this table to be reimported regardless of the checksum errors. Is there any way to turn that checking off ?

I've also tried Oracle Export/Import but it returns errors after editing the DMP file. SQL Inserts does not handle LONG columns.

Please help.

Regards

Rafal

 

[Marco Kalter]

I'm afraid that's not possible. The PDE file is compressed, and decompression requires that it os 100% unchanged.

What exactly did you want to change?

 

[Rafal]

The LONG field contains a script with application setting like

mdiTemplateHumanResources.DateFormat=DD/MM/YYYY

I need to change it into "mdiHumanResource.....".

There are 3000 records - one for each application user. I can individually export, amend and import each script but - as you may expect - this is not the kind of job I'd like to do....;-))))

For Oracle Export file it works fine when you replace an exact number of characters e.g. mdiAAAAManagement to mdiBBBBManagement, but it fails when strings have different length...

Thanks

Rafal

 

[Marco Kalter]

Perhaps you can create a little PL/SQL program to do this job directly in the database.

 

[Rafal]

I'll do a search on the Internet, maybe I will find something....Thanks anyway !!