OBIEE Import Metadata Sys Tables Problem

dilek

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,

Andrew Fomin.

BIN$... tables are dropped tables in recycle bin. Do you really need them?

About recycle bin management: Managing Tables

Gianni Ceresa

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 ...

Andrew Fomin.

Actually, I've been thinking about something like purging recycle bin, but that isn't a recommendation I would give without some questioning.

dilek

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

[Deleted User]

Remove them from the rights of the user you use in the connection pool on the database level?

Andrew Fomin.

Are you sure it is possible? From my understanding, you see either your own recycle bin or global (if you are a sysdba).

[Deleted User]

Hmmm ok in that case empty the bin