Datafile not showing in PSAP<SID>640 tablespace

[Former Member]

Hi All,

In our quality server we are having we are having datafile PSAPDQT & PSAPDQT640,

in PSAPDQT sapdata 1 & 2 not showing remaining datafiles are showing, but in PSAPDQT640 its showing all the datafiles sapdata1,2,3 &4., in transaction DB02--> datafiles/temp files.

This is on ECC 5 on HP-HX, with oracle 10g.

Kindly suggest what may be the issue and how to resolve.

Thanks & Regards!!

[Former Member]

Hi,

U can check all datafiles within a Tablespace by below statement or brtools.

Sapdata1 and sapdata4 are not tablespace these are only folder

SQL> select file_id,file_name,tablespace_name from dba_data_files order by

tablespace_name;

/

Thnx SurendraJain

[markus_doehr2]

> In our quality server we are having we are having datafile PSAPDQT & PSAPDQT640,

> in PSAPDQT sapdata 1 & 2 not showing remaining datafiles are showing, but in PSAPDQT640 its showing all the datafiles sapdata1,2,3 &4., in transaction DB02--> datafiles/temp files.

Is it not showing the TABLESPACES or not showing the DATAFILES in the tablespaces? Do you "see" them using brtools?

I read your sentence about 10 times but I must admit, I don't understand your problem.

Markus

[Former Member]

Hi,

Its not showing the tablespace (sapdata1 & sapdata2) in PSAPDQT, but remainig other tablespace like (sapdata3 & sapdata4) are showing.

where as in PSAPDQT640 its showing all the tablespace, including (sapdata1,2 ,3 & 4)

where can we check in brtools.

Regards!

[markus_doehr2]

> Its not showing the tablespace (sapdata1 & sapdata2) in PSAPDQT, but remainig other tablespace like (sapdata3 & sapdata4) are showing.

maybe PSAPDQT has no "sapdata1 and sapdata2" - those are only directories and not tablespaces. This depends on how the system was set up initially and is not a problem.

start "brtools" as user ora<SID> and follow the menue.

Markus

[Former Member]

Hi Sayad

Hope u have checked in both SAP level & OS level

Check in DB02-goto-tablespaces-DBA data files.

If you have not find in both OS & SAP level it may be like they have not cofigured by the time of installation. It's does not give you any errors you can create if you want them.