Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
ALTER VIEW ORA 43929: Collation cannot be specified if parameter MAX_STRING_SIZE=STANDARD is set.
설명
Sometimes ALTER VIEW > View Info tab improperly attempts to set "Default Collation" to USING_NLS_COMP. For my purposes, this is incorrect as default collation is not required for the view. Following the suggested ORA-43929 corrective action goes down a very dangerous rabbit hole where the MAX_STRING_SIZE is irreversibly switched to EXTENDED and utl32k is run - which can result in the database being un-openable and must be restored from backup. Is there a way to default to "Default Collation"=Default?
로그인 필요
프리미엄 기술 문서를 보려면 로그인해야 하며 최신 유지 관리 계약이 있어야 합니다.