Hello everybody,
When I import metadata on obiee 12c admin tool, lots of bin$ tables come to the list. When I use, 11g there I had never fact this issue. How can I solve this problem?
This is how it is seen;
Thank you for your interest.
Regards,
BIN$... tables are dropped tables in recycle bin. Do you really need them?
About recycle bin management: Managing Tables
Hi,
Andrew explained what these objects are, but what is the issue?
Your tables are probably just after the list of BIN* objects, if you use the search field above the list you quickly jump to your table ...
Actually, I've been thinking about something like purging recycle bin, but that isn't a recommendation I would give without some questioning.
Thx your answer @Gianni Ceresa but what my issue is time. Import metadata takes so much time, whicle opening the table list. So the problem is not to find required table :S
Remove them from the rights of the user you use in the connection pool on the database level?
Are you sure it is possible? From my understanding, you see either your own recycle bin or global (if you are a sysdba).
Hmmm ok in that case empty the bin