Can I drop this table ?

[Former Member]

This morning, I found my PSAPPRD tablespace free space dropped dramatically.

Then I typed db02, Detailed analysis, I found there is a strange table with around 43 GB but I can't type its table name as it has a strange character that I couldn't type it in my keyboard : ACCTIT#?

(1)How can I know where this table came from ?

(2)Is this table useful ?

(3)Can I drop it ?

(4)How can I upload a screen capture to you ?

[Former Member]

I fixed it.

Please ignore this thread.

[former_member199632]

Hello Ming...

Then I typed db02, Detailed analysis, I found there is a strange table with around 43 GB

How you find out the DB table sizes using DB02 (ex: table with 43 GB). I also tried to find out. But still unable to locate the place in db02;

You got the table sizes using , Db02 or using any other method?

regards,

Zerandib

[Former Member]

t-code : db02

go to the Tables and Inexes tab,

click the "Detailed analysis" button

Object name : *

Tablespace : PSAPPRD

Object type : table

Size / kbyte > 1000000

It will show you the tables' sizes.