BUG: Import selected tables

Nepherim

Member²
Importing data for selected tables from a data file that contains data for many tables, and choosing the truncate option causes ALL tables to be truncated (not just the selected ones), and only the selected ones get repopulated. This is *extreemly* annoying. I just lost all development data.

For example:

1] Perform an Export in PL/SQL Dev format of three tables .
2] Import the data -- select *one* of the tables and choose the Truncate option
3] Control urge to scream as you notice one populated and two empty tables.

~ ~ David
 
I tried this, and it works just fine. I double-checked the PL/SQL Developer source code, and verified that indeed only the selected tables are truncated.

Are you sure the 2 other tables were populated before the import? Can you verify the LOG tab and check that the other tables were indeed truncated (there should be a line for each truncated table)?
 
Oh, it definiately happened -- an attempt to restore two tables truncated over 30 others. Unfortunately I didn't save the log file. Let me try and create a test example.

~ ~ David
 
Back
Top