Digital Developer Conference: a FREE half-day online conference focused on AI & Cloud – North America: Nov 2 – India: Nov 9 – Europe: Nov 14 – Asia Nov 23 Register now

Refine your search by using the following advanced search options.

Criteria	Usage
Questions with keyword1 or keyword2	keyword1 keyword2
Questions with a mandatory word, e.g. keyword2	keyword1 +keyword2
Questions excluding a word, e.g. keyword2	keyword1 -keyword2
Questions with keyword(s) and a specific tag	keyword1 [tag1]
Questions with keyword(s) and either of two or more specific tags	keyword1 [tag1] [tag2]
To search for all posts by a user or all posts with a specific tag, start typing and choose from the suggestion list. Do not use a plus or minus sign with a tag, e.g., +[tag1].

Ask a question

Can I create a view in a replicated Db that points to a non replicated DB?

Question by Rafael-LzPz (1) | Jun 07, 2017 at 05:17 AM pda nps replication view

I have few replicated DBs (PDA replication) and I need to create a view in one of the DBs that uses a table from a DB that is not included in the replication set ( db is not replicate in the subordinate).

Is is possible to do that? and how it will behave in the subordinate?

Answer by Rafael-LzPz (1) | Jun 07, 2017 at 05:21 AM

Is not permitted to create such views because in the SUBORDINATE is missing the source DB

The create view sql will fail in the MASTER with the following error:

REPL_TEST.ADMIN(ADMIN)=> create view external_view as select * from PRO_QRADAR.SV00056.T2; ERROR: CREATE VIEW refers to a cross-db query with at least one database being non-replicated

And it will never be replicated/executed in the sub

NPS 7.2.0.3 Replication 1.6

0 Share

Can I create a view in a replicated Db that points to a non replicated DB?

1 reply

Follow this question

Can I create a view in a replicated Db that points to a non replicated DB?

1 reply

Follow this question

Related questions