Delete Import set tables

[prashanth_udupa]

Looks like once the import set table is created, we cannot delete it (If we issue delete command, it takes very long and does not delete the table. The same thing happened to couple of tables). Even if we delete the corresponding Data source, the import set table still remains. Is there any way to remove these? We are using Fuji.

[Pradeep Sharma]

Hi Prashanth,

You cannot clean up import set tables that have a transform map defined in a different application scope, starting with the Fuji release.

[prashanth_udupa]

Hi Pradeep,

    The datasource does not contain the transform Map. There was a typo in the name, so I was trying to delete it and recreate the data source. But the Import Set still remains.

[brycegodfrey]

Did you figure this out?   I can not seem to delete mine either once its in a scoped app via cleanup or the table editor.   I removed the transform map manually, but the import set table still remains.

[tony_barratt]

Hi Prashhanti,

I think that you should not delete import set tables - they have sys_import_set_row as super class.

Someone else may have different advice I suppose.

Can you just leave the table as is - and ignore it?

Best Regards

Tony