Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Tablespaces and repositories

Hi all,

I have configured an MDM application (stand alone -no NW) running on SUSE and RDBMS ORACLE 10.2 for a test phase of a project. After the set up completed successfully the functional team started uploading repositories. The repositories some times had to be dropped and recreated. Now, by looking at my Oracle Enterprise Manager I see that many table spaces have been created for the same repository but different names. For instance for the repository TSTBUSINESSPARTNER I have the following tablespaces created:

A2I_TSTBUSINESSPARTNER_M000

A2I_TSTBUSINESSPARTNER_M000_IX

A2I_TSTBUSINESSPARTNER_Z000

A2I_TSTBUSINESSPARTNER_Z000_IX

some of them are 1.0 or 0.1 MB. Are all these created because of these deletions and recreations?

Moreover, I would like to know where is defined how the tablespaces are created and where to locate the respective datafiles. By the way all the datafiles created by the repositories have been automatically stoed in the ORACLE_HOME directory while I had already prepared another FS for the datafiles. Could I also define the path of the new created datafiles?

Many thanks in advance,

Loukas

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question