Export Clobs and Synonyms

[agent86]

Version 7.0.1.1066

Exporting tables containing non null clobs using Pl/SQL Developers export table gives me an "stream read error".

Any chance schema compares can pick up synonyms?

thanks

 

[Marco Kalter]

Works fine for me. Which format did you use?

 

[agent86]

Tools --> Export Tables --> Pl/SQL Developer Tab

I could have sworn it worked before. I have tried it on both CORE 9.2.0.6.0 and 9.2.0.7.0 versions. Not sure what else to check.

 

[Marco Kalter]

Can you send me a demo table + contents?

 

[agent86]

Pretty easy to recreate:

CREATE TABLE exp_clob_test (ID INT, c_data CLOB DEFAULT empty_clob() );
INSERT INTO exp_clob_test VALUES (1, 'test');
COMMIT;

They try to export using the PL/SQL Developers tab. I get a small error box that says "write stream error". Perhaps its my environment but not sure where to look. Note: the Oracle tab export works fine.

 

[Marco Kalter]

Works fine for me. Can you go to Help > About, press the 'Info' button, press the 'Copy all pages' button on this info screen, and paste this text into an e-mail reply?

 

[agent86]

email sent.

thanks Marco