View previous topic :: View next topic
|
Author |
Message |
Rijit
Active User
Joined: 15 Apr 2010 Posts: 168 Location: Pune
|
|
|
|
Hi,
If the tablespace is in CHECK PENDING status. the below 2 commands if executed, will it reset the CHECKPENDING status to normal?
Code: |
REPAIR OBJECT
SET TABLESPACE DB01.TS01 NOCOPYPEND
START DATABASE(DB01) SPACENAM(TS01) ACCESS(RW)
|
Please advise
Thanks |
|
Back to top |
|
|
chandan.inst
Active User
Joined: 03 Nov 2005 Posts: 275 Location: Mumbai
|
|
|
|
What happened when you tried these commands?
Reagrds,
Chandan |
|
Back to top |
|
|
Pandora-Box
Global Moderator
Joined: 07 Sep 2006 Posts: 1592 Location: Andromeda Galaxy
|
|
|
|
Would suggest talk to DBA first and understand why it is in check pending status. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
As PB suggests, you need to understand how/why the tablespace got into a CHECK PENDING status.
These should NOT just be reset . . . |
|
Back to top |
|
|
Rijit
Active User
Joined: 15 Apr 2010 Posts: 168 Location: Pune
|
|
|
|
Hi Dick ,
There is referential integrity constraints which we are facing while loading the table. I want to know if the start database command alone will reset these flags or we need to explicitely give the repair commands for reseting the CKP and COPY pending flags for the tablespace.
I understand that explicitely resetting the flags may cause data inconsistency but again this is the need of the hour.
Thanks, |
|
Back to top |
|
|
Pandora-Box
Global Moderator
Joined: 07 Sep 2006 Posts: 1592 Location: Andromeda Galaxy
|
|
|
|
Quote: |
I understand that explicitely resetting the flags may cause data inconsistency but again this is the need of the hour. |
Bad idea for me .... Did you let your DBA know about your approach ? |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Yup, i concur. . .
I understand it might be expedient, but may cause surprises later.
Suggest proper prevention/correction be implemented soon so the possibility of this causing problems later will be minimized.
My main concern is that when the quick way is used for a while, it is tougher to correct it later . . . |
|
Back to top |
|
|
agkshirsagar
Active Member
Joined: 27 Feb 2007 Posts: 691 Location: Earth
|
|
|
|
option will not reset CHECKPENDING flag. You will need to use NOCHECKPEND option.
will not reset the flag either. You will need to use ACCESS(FORCE) to reset any COPY/CHECK pending flags.
Either one of the approaches is sufficient. There is no need to use both. |
|
Back to top |
|
|
|