/oracle/SID/sapdata* mount points

[former_member182921]

Hi SAP Experts

I have three question for the mount points /oracle/SID/sapdata*

1.Can we delete the entry in /oracle/SID/sapdata*.?

2. What is inside these mount points ?

3. what is the relationship with tablespace ?

Regards,

Abhishek

[Former Member]

1. no

2. datafiles

3. tablespace -> one or more datafiles

You might want to talk to an oracle dba (or use google) about database size, datafile autoextend feature and such.

Cheers Michael

[magexposito]

Hello,

If you check the installation guide 'SAP Systems Based on the Application Server ABAP of SAP NetWeaver on Oracle Solaris: Oracle' for example on point 4.3.2 (Oracle Directories) you can read the following information:

Directory: /oracle/<DBSID>/sapdata*

Description: SAP data

This is one of the required file systems and directory in almost every SAP system installation.

About your questions:

1. No unless you want to destroy your database.

2. The datafiles from the DB.

3. From the Oracle's official documentation: Each tablespace in an Oracle database is comprised of one or more operating system files called datafiles.

Best regards.

[Reagan]

Hello

Sounds like you are OS specialist.

If there is an Oracle database running, then you need to leave the file system as it is.

An Oracle database stores data in the tablespace and physically in the datafiles.

The /oracle/SID/sapdata file systems are used by the Oracle database for storing the data files.

If I were in your place I would run an fuser command against the file system to check the processes using the file system

Cheers

RB

[Former Member]

Hi

1.why !?!?!?!?!?

2. pieces of database called datafile

3. logical; phisically the database and tablespaces dont exist; in reality only datafiles and control files exist in the file systems

Regards

a