Home » Developer & Programmer » Warehouse Builder » Need to change the default tablespace of Owb Repositary Schema (OWB Client :10.2.0.2.8 ; Repositary:10.2.0.2.0 ; Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 ; OS Solaris 5.10)
icon9.gif  Need to change the default tablespace of Owb Repositary Schema [message #431408] Tue, 17 November 2009 04:34
sourajit_seth
Messages: 38
Registered: November 2005
Location: India
Member
Hi,
We have one issue related to OWB. The default tablespace of the schema of the owb repositary was earlier set to "USERS". But we need to change it to a new dedicated tablesapce because of running out of space . I have a plan to perform the following activities like other schema export/import :

1. Create new tablespace
2. Export the Schema of OWB repositary through Data Pump .
3. Drop the OWB schema
4. Import the OWB schema to the new tablespace.

Please let me know whether any additional steps are required in view of the OWB schema movement, configure the Control center etc ..
The Versions are as follows :
-----------------------------------------------------------------OWB Client : 10.2.0.2.8
Repositary : 10.2.0.2.0

Oracle Oracle Database 10g Enterprise Edition Release
10.2.0.3.0

OS Solaris 5.10
-----------------------------------------------------------------

Thanks
Previous Topic: download analysis services projects
Next Topic: XML as source in OWB
Goto Forum:
  


Current Time: Fri Dec 09 09:29:25 CST 2016

Total time taken to generate the page: 0.18706 seconds