Database Administration (MOSC)

MOSC Banner

key preserved table in a vew

edited Apr 28, 2011 5:30PM in Database Administration (MOSC) 5 commentsAnswered
Hello all.

I am trying to get understanding of the key-preserver tables. I have read a few articles on the subjects , but it still is somewhat vague.

We have a view SCHEMA2.V1 that is defined as follows

select a."BATCH_COMPONENT_ID",a."BATCH_ID",a."TRAN_COUNT",a."POSTED_TMS",a."POST
ED_STATUS_CODE",a."RETRY_COUNT",a."DATASET_NAME",a."NUMBER_PROCESSED",a."OUTSTAN
DING_TRANSACTIONS",a."START_NBR",a."END_NBR"
from SCHEMA1.BATCH_COMPONENT_CONTROL a,
     SCHEMA0.NUMBER_PARTITION b
where a.START_NBR = b.START_NBR and a.END_NBR = b.END_NBR

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center