Re: TOAD: SQL Script execution

rik wrote:
> Hi, I'm trying to execute a simple SQL script in TOAD
>
> INSERT INTO TABLE (fields...)
> SELECT fields FROM TABLE
>
> But I obtain an error on second table:
>
> Table or view not found!
>
> Why this??
>
> I'm logged in TOAD with the users of TableSpace, and then I try to execute a
> query on a table of this TableSpace
>
> Thanks

Hi Rik,

Please clarify what you mean by "I'm logged in TOAD with the users of TableSpace, and then I try to execute a query on a table of this TableSpace". My assumption is you mean the user has been granted INSERT access on the table, but doesn't own it? In this case, the user would either need a synonym, or need to provide completely qualified names (with owner) to the statement trying to run. I thought TOAD did this under the hood, but maybe it only does it when you click on a table in the GUI.

To test, change your INSERT to...

INSERT INTO ownername.TABLE (fields...)
SELECT fields FROM ownername.TABLE

...and see what you get

Regards,

Steve Received on Fri Jun 09 2006 - 08:12:26 CDT