Database Utilities
ContentsOpens a new window
Opens a new window
Page 987 of 1018

Importing REF Data

REF columns and attributes may contain a hidden ROWID that points to the referenced type instance. Import does not automatically recompute these ROWIDs for the target database. You should execute the following statement to reset the ROWIDs to their proper values:

ANALYZE TABLE [schema.]table VALIDATE REF UPDATE;

See Also:

Oracle Database SQL Language Reference for more information about the ANALYZE statement

Previous PageOpens a new window
Page 987 of 1018
Next PageOpens a new window