No question at this time
DBA Top 10
1 B. Vroman 14600
2 M. Cadot 11000
3 J. Schnackenberg 8200
4 T. Boles 7950
5 A. Kavsek 6200
6 M. Hidayathullah ... 2200
7 G. Lambregts 1100
8 T. P 1000
9 P. Wisse 900
10 B. Derous 500
10 . Lauri 500
10 R. Pattyn 500
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48286
Total active users1591
Act. users last 24h3
Act. users last hour0
Registered user hits last week242
Registered user hits last month1121
Go up

Migrating OWB repository into a new database
Next thread: Is OJVM patch is mandatory in 12c rac ?? if yes, its need to apply on RAC and oracle home both??
Prev thread: Instance loaded and Scan Listeners

Message Score Author Date
Hi all, out of "reasons" I need to move an OWB ...... Jan Schnackenberg Jul 12, 2018, 14:14
Jan As far as I know OWB has been deprecated si...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Guy Lambregts Jul 12, 2018, 15:43
Thanks Guy, a colleague told me, that an export...... Jan Schnackenberg Jul 13, 2018, 10:56

Follow up by mail Click here


Subject: Migrating OWB repository into a new database
Author: Jan Schnackenberg, Germany
Date: Jul 12, 2018, 14:14, 129 days ago
Os info: SLES 11.4
Oracle info: 12.1.0.2
Message: Hi all,

out of "reasons" I need to move an OWB repository from one database into a new one.

A short google search ("Oracle Warehouse Builder datapump" and some similar things) did not reveal anything that tells me

* Is this possible
* If so, do I need to do anything special
* etc.

While I'll keep searching (and keep trying to reach some people with more OWB know how than me): Does any one here have practical experience with something like this?

Regards,
Jan
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Migrating OWB repository into a new database
Author: Guy Lambregts, Belgium
Date: Jul 12, 2018, 15:43, 129 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: Jan

As far as I know OWB has been deprecated since a few years.

My knowledge of OWB itself is limited but years ago I participated in a DW project with OWB involved.

You can export OWB metadata from a database 1 and import that into a database 2.

The below URL is at least a starting point, not more than that

https://docs.oracle.com/cd/E11882_01/owb.112/e17130/toc.htm

Regards
Guy
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Migrating OWB repository into a new database
Author: Jan Schnackenberg, Germany
Date: Jul 13, 2018, 10:56, 128 days ago
Message: Thanks Guy,

a colleague told me, that an export/import should be possible. She also told me, that MOS Doc ID 434272.1 is involved in the post-migration steps.

We'll try to test this in the next weeks. I'll try to post an update here, afterwards.

Regards,
Jan
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here