MVSFORUMS.com

[arshadh]

Is there any Tablespace in a particular Database into which an USER with no SYSADM or DBADM rights can create a table for test purpose?

Because one of tables have gone to CHKP state and I need to find rows that caused problem(lacking parent row) by creating an exception table.

For your Info:

[videlord]

run check data without DELETE YES first
no exception table needed, you can get the information whect broken RI exist.
and you can the get RID for the exception rows from check data output

[arshadh]

Thanks Videlord,

I ran the Check DAta and got the Row id 's of troubling rows...

But How to associate the particular ROW ID with the row...Please help me..

[videlord]

A little difficult to get the row by the RID, can you paste one line of the output?

The easist way is :
create exception table, run CHECK DATA with DELETE YES

[arshadh]

Thanks for your suggestions,,,,,