Are these biio tables temp table
I asked DBA to grant me write privelege to some import tables with table name BIIO. These tables are used as staging tables for data import. I found these tables seem to drop and create every time after I loaded data. In this case, i lost my write privilege to these tables each time the table got dropped. Is there any way that I can have write privilege to these tables even after the table got dropped besides getting schema password?
If I want to change the logic from dropping table and then recreating table to truncating the table, how to do it?
1