Post

3 followers Follow
0
Avatar

DbVisit Replicate all Instance

Hi,

 

I wanted to know if there is a command to be replicated throughout the instance with DbVisit Replicate without going for schemes.
The motivation of the question is why should I do a migration from Oracle 11 to Oracle 12.
Do you have tips on how to proceed?

Thanks so much

Stefania
Stefania Preto Answered

Official comment

Avatar

The physical structure of the target database can be different in terms of tablespaces, file paths, indexes, etc.

One can create the structure of the database including tables, triggers etc manually and then enable replication for the data only.

DDL replicattion can be enabled on schema level only.
PL/SQL objects should be created on the target manually (via Datapump for example) and once replication starts you can replicate DDL changes.

We do not replicate DCL like changes in grants or roles.

We always recommend to run the Pre-Flight script to get more detailed information about the environment
https://dbvisit.atlassian.net/wiki/display/ugd8/Pre-flight+SQL+script

Charmaigne Bezuidenhout
Comment actions Permalink

Please sign in to leave a comment.

1 comment