Empty query when exporting table as insertions

User_XF720

I'm looking to export a table as an insertion script to move the data to a separate, existing table. When I do this, I get blank queries rather. It's not a problem with the table itself, since other users are able to export the data in the same way with no problem. I'm using the built in export tool in oracle by selecting the table. My parameters for exporting are the same as the other users, but I end up with this empty query whereas they have the expected result. Any help would be appreciated. I am using the latest version of Oracle SQL Developer.

thatJeffSmith-Oracle

what happens you run select * from prism.load_hdrgeneric81_staging

Do you get the data back?

and if on that grid you do a right-click export to INSERT Statements, what happens?

User_XF720

@thatJeffSmith-Oracle Yes, the table with the data is still there. Right click export to INSERT results in the result above. Saved the output as a .sql, and opened as .txt in the notepad above to find no INSERT statements were generated. Saving as an unspecified filetype does not resolve the issue, either.

thatJeffSmith-Oracle

what data types are used to define those two columns?

Does an export to CSV or Excel work?

User_XF720

@thatJeffSmith-Oracle Both are VARCHAR2(4000 BYTE). Issue isn't resolved by changing the file type options.

thatJeffSmith-Oracle

version of Oracle database and SQL Developer?

And any messages written to the Output panels (Messages / Logging Page) ?

User_XF720

@thatJeffSmith-Oracle 18.0.0.0.0