ORA-00604 error occurred at recursive SQL level stringCause: An error occurred while processing a recursive SQL statement (a statement applying to internal dictionary tables).Action: If the situation described in the next error on the stack can be corrected, do so; otherwise contact Oracle Support Services.
这个视图脚本在9i上运行很正常,而且把视图的空格去掉后,在10g上也可以建立,
怀疑是oracle在解析sql语句时内部缓冲不足导致的