Re: Synchronization Wizard weirdness

A Nice Guy wrote:
[Only top-posting platform and version info! More comments embedded below.]

Whoops, should have known better about explaining platform and versions!

Running Oracle 10g R2 on a Linux server (don't have the hardware specifics
available).
Using the Oracle Enterprise Manager and Oracle Change Manager packages, which
includes the Oracle DB Synchronizer. This is the piece which is causing me
trouble.

In <dt28in$rus$1@xxxxxxxxxxxxxxxxxxxxxxx> article, Frank van Bortel said:
: A Nice Guy wrote:
: > Hi All,
: > I'm an old-time Informix DBA who has now switched over to Oracle. I've
: > been learning the Oracle packages as I go.
: >
: > I have a Test Schema in the same database as the Main schema and need to
: > synchronize Test with Main (all table & data mods).
: >
: And how did you implement this? Sorry to bother you, but the
: crystal ball is gift-wrapped.

How implemented? First I created a blank schema, then I ran the Comparison
Wizard between the Main schema and Test schema -- obviously returned the full
set of objects since Test was empty. Then I ran the DB Synch program which
copied the objects and the data from Main to Test.
That's how the Test schema was originally built.

Ah - but I'm an old guy, and like the keyboard better than a mouse :)
Sorry - not familiar with that. But I should have noticed the post
header, sorry for that.

Not sure exactly what materialized views and the different forms of
refreshing those views has anything to do with my issue. I'm dealing with
DDL, not the underlying data (although I also move some data between the
schemas, this is not the root of my problem).


Mike, in your original post you mention "need to
synchronize Test with Main (all table & data mods)"

Data synchronization (DML) = materialized views.
Data and Model (DDL & DML) sync: Streams.

Really. Takes about 20 lines of code.
Streams. Schema level.

Warning: you're at risk of learning something! :)

But if that is not the level you want to take it, I can't
help you, maybe someone with more OEM experience can?
--
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
.

Relevant Pages

  • Re: Synchronization Wizard weirdness
    ... Using the Oracle Enterprise Manager and Oracle Change Manager packages, ... :> I have a Test Schema in the same database as the Main schema and need to ... Wizard between the Main schema and Test schema -- obviously returned the full ... :> All seems to go well, until the script actually runs. ...
    (comp.databases.oracle.tools)
  • Re: ODBC cannot access Oracle tables under different schemas in one session
    ... >Access / Oracle problem, ... >referring to the proper server / SID of every branch. ... >table, when i try to query the second table under another schema, ODBC ... >shift to another schema and query their tables, ...
    (comp.databases.oracle.misc)
  • Re: UTL_FILE Permissions
    ... The schema APP has already been granted READ and WRITE to the APP_DIR, ... I used the usermod command so that oracle user has a secondary group ... it should be possible for your upload ...
    (comp.databases.oracle.server)
  • Re: UTL_FILE Permissions
    ... The schema APP has already been granted READ and WRITE to the APP_DIR, ... I used the usermod command so that oracle user has a secondary group ...
    (comp.databases.oracle.server)
  • Re: ODBC cannot access Oracle tables under different schemas in one session
    ... >>Access / Oracle problem, ... >>referring to the proper server / SID of every branch. ... >>table, when i try to query the second table under another schema, ODBC ... >>shift to another schema and query their tables, ...
    (comp.databases.oracle.misc)