database table details

[Former Member]

Hi all,

Is there any function module in SAP to get the database table size details for the oracle database.

Thanks

Ramana

[Former Member]

use these FMs:

GET_TABLE_SIZE_ORA Get Table Size for Oracle

Function module              GET_TABLE_SIZE_ORA

  Import parameters               Value
  TABNAME                         VBAK
  DATA_SPACE_ONLY
  SIGNI                            3

  Export parameters               Value
  TABSIZE                               2.448

also check

MSS_GET_TABLE_SIZE_INFO Get size information on a table

GET_TABLE_SIZE_MSS Calculate/retrieve size of a database table (MSSQL)

Edited by: Soumyaprakash Mishra on Sep 12, 2009 12:13 PM

[sreeramkumar_madisetty]

Hi

Try these.

GET_TABLE_SIZE_INFO_DB2

GET_TABLE_SIZE_DB2

GET_TABLE_SIZE_DB4 AS/400: Get table size w/ or w/o indices

GET_TABLE_SIZE_ADA

DB_GET_TABLE_SIZE

GET_TABLE_SIZE_INF Calculate/Retrieve Size of a Database Table (Inf

GET_TABLE_SIZE_DB6 DB6: Retrieve size of database table

MSS_GET_TABLE_SIZE_DETL OBSOLETE! Use RAT sap_get_table_size_detail inst

MSS_GET_TABLE_SIZE_INFO Get size information on a table

Regards,

Sreeram

[Former Member]

Hi all,

The function module GET_TABLE_SIZE_ORA is fine to find out the database table size (for Oracle database)

Is there any single function module to find out the Table size,Table Index size and Table total size.

Thanks,

Ramana.

[Former Member]

try this:

SCCR_CHECK_TABLESPACE_ORACLE

[Former Member]

Hi all,

I need to create a file on the application server with details like Tablename,package,table size allocated,total table size,used size of all the data base tables.

I have 7 lacs tables in the database and it is Oracle database.

Please help me out in solving this.

Thanks and Regards,

Ramana