Importing LONG RAW

[Crayz]

I'm using Oracle 9i, and when I look at a table with a LONG RAW datatype, PL/SQL Developer allows me to export a file.

However, I cannot import a file... even one that I have exported using PL/SQL Developer.

Does anyone have any ideas? Thanks.

 

[Marco Kalter]

Tables with Long, Long Raw, CLOB and BLOB columns can be exported/imported in native Oracle export format or PL/SQL Developer format. They cannot be exported in SQL format due to SQL restrictions.

What exactly goes wrong during the import, and which format are you using?

------------------
Marco Kalter
Allround Automations

 

[fehret]

Hello,

Did you got news about this problem ?

Thanks.

Fran

 

[Marco Kalter]

If you are having a problem, please let me know some details.

------------------
Marco Kalter
Allround Automations

 

[Rajeev Agrawal]

Rajeev--> Have you locked the record before trying to import a file. Its mandatory to lock the record before the IMPORT button is enabled.

Originally posted by Crayz:
I'm using Oracle 9i, and when I look at a table with a LONG RAW datatype, PL/SQL Developer allows me to export a file.

However, I cannot import a file... even one that I have exported using PL/SQL Developer.

Does anyone have any ideas? Thanks.