Home » SQL & PL/SQL » Client Tools » edit command in TOAD (10g)
edit command in TOAD [message #322091] Thu, 22 May 2008 08:36 Go to next message
Messages: 27
Registered: April 2008
Junior Member

I use TOAD8.6 and I want to edit a view by:
edit my_view_name

but i get this error:
ORA-01446 cannot select ROWID from view with DISTINCT, GROUP BY, etc.

Cause: A SELECT statement attempted to select ROWIDs from a view containing columns derived from functions or expressions. Because the rows selected in the view do not correspond to underlying physical records, no ROWIDs can be returned.

Action: Remove ROWID from the view selection clause, then re-execute the statement.

how can i edit it?
Re: edit command in TOAD [message #322121 is a reply to message #322091] Thu, 22 May 2008 09:50 Go to previous message
Messages: 21580
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'm not sure that I understand what "editing a view" means, but - go to views tab in Schema Browser. In right pane you'll see several tabs, and one of them is "Script". Copy-paste CREATE VIEW statement into SQL Editor and modify it (i.e. change view's SELECT statement).
Previous Topic: Table name in trc files?
Next Topic: how to open the editor
Goto Forum:

Current Time: Tue Aug 11 08:13:18 CDT 2020