REPAIR SET TABLESPACE DBY05.T050US NOCOPYPEND

zatish · New User Joined: 06 May 2005 Posts: 14

Hi,
Can you pls explain what the statement below does.

REPAIR SET TABLESPACE DBY05.T050US NOCOPYPEND

I know T050US is a tablename and DBY05 is a prefix to the table.
It does repair the table space.

Thanks for your help

khamarutheen · Active Member Joined: 23 Aug 2005 Posts: 677 Location: NJ

hi zathish,

I Searched in the documentation that REPAIR is simply a previlage granted to the user.. and NOCOPYPEND is not a valid key word as per i search.. can recheck and say???

prakash271082 · New User Joined: 09 Sep 2005 Posts: 53

Hi,
It resets the Copy Pending Status of Tablespace.
Hope this helps. Correct me if I am wrong.