Reinitialize/relocate MDM tablespaces

[Former Member]

We installed Portal with their own Java DB schema.

Now we would to to connect MDM server with their directories to the same Java DB schema.

By doing so two talbespaces will be created during the initialization from MDM console within E:\oracle\<sid>\102\database

A2I_A2I_XCAT_DBS.DBF

A2I_A2I_XCAT_DBS_IX.DBF

Also 2 users will be created: MDMADMIN and A2I_XCAT_DBS

Unfortutalely the data files are located under under path: F:\oracle\<sid>\

What is the easiest way to reinitialize/relocate the both tablespaces to other directory? (brtools/editing the control file)

[former_member204746]

environment variable SAPDATA_HOME was not set. set it to F:\oracle\<sid>\

then, use this command to move your datafiles:

brspace -c -u / -f dfmove

note that you will need DOWNTIME to do this.

[lbreddemann]

> *What is the easiest way to reinitialize/relocate the both tablespaces to other directory? 
>(brtools/editing the control file)*

"editing the control file" ?

Seriously?

Sorry, but did you ever adminster a Oracle DB in the current century???

Please just use the BRTOOLS and walk through the menus...

regards,

Lars

[Former Member]

Hi,

We faced the same issue.

Pls check for setting the environment variables accordingly.

restart the system.

Kindly update.

Thanks and Regards,

Vimal

[Former Member]

I guess my problem was that I use existing Java-DB-instance for MDM, but I took mdmadm operation user that does not have any oracle environment (MDM itself does not have any DB-instance).

So by creation of MDM repository the following Oracle objects have been created:

1) Oracle Schema A2I_XCAT_DBS

2) 2 oracle users: A2I_XCAT_DBS (owner of the schema) and MDMADMIN

3) 2 tablespaces A2I_A2I_XCAT_DBS.DBF and A2I_A2I_XCAT_DBS_IX.DBF within the main dbs directory E:\oracle\<sid>\102\database

Now I would like to delete all these objects and start from scratch.

Is this the right way to to do this manually?

sqlplus /nolog

SQLPLUS> connect / as sysdba

SQLPLUS> drop user A2I_XCAT_DBS cascade;

SQLPLUS > drop user MDMADMIN cascade;

SQLPLUS> drop tablespace A2I_A2I_XCAT_DBS.DBF including contents;

SQLPLUS> drop tablespace A2I_A2I_XCAT_DBS_IX.DBF including contents;

SQLPLUS> exit

[former_member204746]

These commands should work... but I would do them in another order and slightly change them::

qlplus /nolog

SQLPLUS> connect / as sysdba

SQLPLUS> drop tablespace A2I_A2I_XCAT_DBS.DBF including contents and datafiles;

SQLPLUS> drop tablespace A2I_A2I_XCAT_DBS_IX.DBF including contents and datafiles;

SQLPLUS> drop user A2I_XCAT_DBS cascade;

SQLPLUS > drop user MDMADMIN cascade;

SQLPLUS> exit