topic Re: database table details in Application Development and Automation Discussions

database table details

Former Member — Sat, 12 Sep 2009 06:38:51 GMT

Hi all,

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

Thanks

Ramana

Re: database table details

Former Member — Sat, 12 Sep 2009 06:43:27 GMT

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

Re: database table details

sreeramkumar_madisetty — Sat, 12 Sep 2009 06:47:25 GMT

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

Re: database table details

Former Member — Sat, 12 Sep 2009 07:30:52 GMT

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.

Re: database table details

Former Member — Sat, 12 Sep 2009 09:23:49 GMT

try this:

SCCR_CHECK_TABLESPACE_ORACLE

Re: database table details

Former Member — Sat, 12 Sep 2009 10:05:06 GMT

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