- select table_name from user_tables where table_name='TEST_IMP_ROLLBACK_BUG';
- no rows selected
>>Note: you might need to adjust schema of the destination table.
A rollback won't drop a table. Are you sure the tale isn't there? select from dba_tables or all_tables, assuming you had to change the destination schema as indicated in your test notes.
You are right that a Database-level rollback does not delete any tables. I didn't say it was a database level rollback. It was something done by SQL Developer referred to as rollback on the screenshot.
Jeff, please try to reproduce the behaviour and you will see whether you can reproduce it if you don't believe the fact that the first query from user_tables show the table, but the 2nd does not show it. There were no 'alter session set current_schema....' nor any similar in the reproduction steps. And I also mentioned that "table is dropped to recycle bin"
The note is only applicable for step 2 of the reproduction as the schema I used is included in the import parameter file test_imp_rollback_bug-import_settings.sdimp
1 person found this helpful
This is a bug that has been fixed for the official release.