Tablespaces and repositories
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:
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,