Tag Archives: SYS_CONNECT_BY_PATH

帮客户将数据库从11.2.0.1升级到11.2.0.3后，数据库运行正常，不过随后出现了ORA-30004错误。 这个错误以前还真没有碰到过，检查后发现感觉问题似乎不一定和升级有关系： ORA-30004: WHEN USING SYS_CONNECT_BY_PATH FUNCTION, cannot have separator AS part OF COLUMN VALUE Cause: A COLUMN VALUE contained the string that the SYS_CONNECT_BY_PATH FUNCTION was TO USE TO separate COLUMN VALUES. Action: Specify another separator FOR the SYS_CONNECT_BY_PATH … Continue reading →