Last date of adding data file in tablespace

[Former Member]

Dear Expert/guru

From SAP level, where can i find last date when i added datafile to tablespace

[former_member199632 · Accepted solution]

Hi Sumit ,

You can use DB14 -> BRSPACE

there you can get the date of last added DF

regards,

zerandib

[former_member182034]

hi,

you can get information with following commands,

select a.file_name,a.tablespace_name,b.creation_time from dba_data_files a,v$datafile b

where a.file_id=b.file# order by tablespace_name;

for more info please have look the # 5 on following link

http://help.sap.com/saphelp_nw70ehp1/helpdata/en/1b/d20f6fe45a9e43b1856ea1b52c9612/content.htm

Regards,

[Former Member]

hi,
> you can get information with following commands,
> select a.file_name,a.tablespace_name,b.creation_time from dba_data_files a,v$datafile b
> where a.file_id=b.file# order by tablespace_name;
> 
> for more info please have look the # 5 on following link
> http://help.sap.com/saphelp_nw70ehp1/helpdata/en/1b/d20f6fe45a9e43b1856ea1b52c9612/content.htm
> 
> Regards,

hi,

Could you suggest me any way from SAP level

[former_member182034]

Hi sumit,

you can use SAP transactions DB02, SM49, SM69 for tablespace.

mostly users are using BRTOOLS for creation and manage the tablespace while DB02 is used for check the growth and stats of tablespace and DB. if you use the SM49 and SM69 than brtools's utilities will be call, so best way is brtools and sql command for your query which i mentioned in my first reply.

Regards,

[Former Member]

Hi Sumit,

You need the same output from SAP? Its simple. Use the sql given by majamil in SA38 -> RSORADJV -> Paste the SQL and run.

select a.file_name,a.tablespace_name,b.creation_time from dba_data_files a,v$datafile b where a.file_id=b.file# order by tablespace_name;

If your system report RSORADJV not found, use the following procedure

Performance -> Additional Functions -> SQL Command Editor

Br,

Venky