I found something strange when trying to copy a view from one database to another. I spooled the text from dba_views and ran the CREATE VIEW AS ... statement. There was an error because one of the fields needed an alias (it was SUBSTR(xxx)). I went back to the source database and poked around a bit. The view definition from dba_views had no field aliases, but dba_tab_columns did.
For example, dba _views would show something like: View_name: test Text: SELECT SUBSTR(name1,3) FROM emp While dba_tab_columns would have: Table_name: emp Column_id: 1 Column_name: ename as if the view_text was SELECT SUBSTR(name1,3) ename FROM emp What's up here? Henry -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Poras, Henry R. INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
