confirmation of the table partitioning(Oracle)

[Masaaki]

Hi,

I have partitioned the DB table via T-cd:SE14. according to the note 742243. This table contains more than 1,000,000 records.

but it takes only 5 seconds to "activate the database and data conversion" (se14).

So I cannot be confident if this table is really partitioned.

How can I confirm this?

Kind regards,

Masaaki

[Former Member · Accepted solution]

Hi Masaaki,

select TABLE_NAME, PARTITION_COUNT

from user_part_tables

where TABLE_NAME = '<table name>';

Nahum

[Masaaki · Accepted solution]

Hi,

Thank you very much for your help.

but this table seems not to be possible to check from SAPGUI.

user_part_tables (it is not defined in abap dictionary)

is it possible from SAPGUI?

excuse me,, I am not know so much about basis matter...

Kind regards,

Masaaki

[former_member185954 · Accepted solution]

Hello,

you may have to execute that query from the Operating System using a tool like 'sqlplus'.

Ask your Basis guy to execute the query and give you the results.

Regards,

Siddhesh