The following errors are observed when running a “repair using” and using “where” clause in it:
sp_ctrl (alvsupu15:5438)> repair using config2 where "NUM_COL > 10"
Unknown option: 'where'
Usage: repair {source_owner}.{source_table}[.{partition}]
[not ({list of exceptions})]
[to {target_owner}.{target_table}[.{partition}]]
[at {target_host}[@o.{target_sid}]]
[for o.{source_sid}]
[key]
[onepass]
[orderby "{column_list}"]
[include "{column list}"]
[exclude "{column list}"]
[hint "{hint}"]
[where "{clause}"]
[threads {threads count}]
[parallelism {parallelism count}]
[sourcewhere "{clause}"]
[targetwhere "{clause}"]
[insertonly]
[log split]
[nosqllog]
[port {number}]
[on {host}] | [on {host}:{port}] |
[on {login}/{password}@{host}] |
[on {login}/{password}@{host}:{port}]
Usage: repair using {filename}
[key]
[onepass]
[threads {threads count}]
[parallelism {parallelism count}]
[insertonly]
[log split]
[on {host}] | [on {host}:{port}] |
[on {login}/{password}@{host}] |
[on {login}/{password}@{host}:{port}]
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center