database tables missing in db02

[Former Member]

hello,

I have problem with text master data tables with SE11 the system tell me that I have 200 tables but in DB02 I get only 7 tables

[Former Member]

Hi Michel,

You can try accessing tables from DB02 --> SPACE -->Tables and Indexes , put your search filter and check.

Also to have more details on each table , you can check option

DB02 --> SPACE --> Single table analysis

Br, Vaibhav

[Former Member]

Hi Michel,

I believe there would be more than 200 tables when you search in SE11. Try this when searching in SE11 as by default we will have 200 set Max. no. of hits.

To verify please try to get the list/count at DB level.

Login to the ORA<SID> and on sql prompt fire the command something like below

1. to get the names of the table

select table_name from all_tables where table_name like '/BIC/T%';

2. To get total count

select count(*) from all_tables where table_name like '/BIC/T%';

And check if the count matches with SE11.

Let us know the outcome

Regards,

Prithviraj.

[Former Member]

Hi Michel,

Can please tell what text tables are you talking about?

SE11 and DB02 screen-shot might help here.

Regards,

Prithviraj.

[Former Member]

Hi Prithviraj,

In fact i'm looking for the text master data tables  used in my sap BW system  i have launched a search using se11 for all tables begin with /BIC/T* and i have found 200 entries and then i need to know the size of those tables using DB02 but in db02 under segments detailed analysis when i launch a search using the same above criteria the system return only 7 tables while i should find all the 200 tables as in se11