[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference orarep::nomahs::repository

Title:Oracle CDD/Repositorynce
Notice:Current versions are V7.0-01 and V6.1-03eld Test 3
Moderator:8292::PJACOBN
Created:Thu Jan 21 1993
Last Modified:Fri Jun 06 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:1094
Total number of notes:4913

1051.0. "RMU-I-NODATANDX" by M5::JAKUHN (rdb exists *ONLY* for CDD) Thu Feb 20 1997 12:54

    CDD 6.1
    
    Hi all,
    Why is it when you define a new repository, and do an RMU/VERIFY/ALL,
    you see %RMU-I-NODATANDX, no data records in index warnings?
    
    thanks
    jay
T.RTitleUserPersonal
Name		DateLines
1051.1NOVA::SMITHIDon't understate or underestimate Rdb!Thu Feb 20 1997 15:134
It is not a warning, it an informational (i.e. -I-)
RMU thinks this is interesting information for you.

Ian
1051.2thanksM5::JAKUHN[email protected]Thu Feb 20 1997 15:372
    I think what threw me was i can't remember seeing this on a generic
    RDB db. huh.
1051.3NOVA::SMITHIDon't understate or underestimate Rdb!Thu Feb 20 1997 23:0514
$ rmu/veri/index db$:scratch
...stuff deleted...
%RMU-I-ENDNDXVER, completed verification of index T_MAPPING_INDEX
...stuff deleted...

Yep you will get it for any old database.

Whenever you create an index but never store a row in the table then the
actual root node creation is deferred until the first insert.  This feature
was added in Rdb V3.1 primarily for CDD which contains many table and indices
which may not be used.  e.g. a DATATRIEVE user may never use the ACMS tables,
etc.

Ian