Options
Bug with Long Defintion of a View
oracle2000
Posts: 13
I have view that has a very long Definition/SQL
SELECT * FROM all_views WHERE view_name = 'V_FT_CONTRIBUTION'
Gives me a TEXT_LENGTH of 80001.
"Schema Compare for Oracle" seem to cut the view-definition at the end before checking it into TFS.
Leaving me with an incomplete and invalid view that does not compile in PROD.
SELECT * FROM all_views WHERE view_name = 'V_FT_CONTRIBUTION'
Gives me a TEXT_LENGTH of 80001.
"Schema Compare for Oracle" seem to cut the view-definition at the end before checking it into TFS.
Leaving me with an incomplete and invalid view that does not compile in PROD.
Comments
Project Manager
Red Gate Software Ltd
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com