| edit command in TOAD [message #322091] |
Thu, 22 May 2008 08:36  |
xyzt
Messages: 27
Registered: April 2008
|
Junior Member |
|
|
Hello
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  |
 |
Littlefoot
Messages: 21823
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).
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
