InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comSat, 06 Sep 2008 23:09:55 GMT20http://www.teradata.com/teradataforum/Topic10433-22-1.aspxPost your query dude. After seeing that, we can comment on that.Sat, 05 Apr 2008 06:00:08 GMTMonikahttp://www.teradata.com/teradataforum/Topic10433-22-1.aspxI'm running an insert select into a new table with a foreign key check constraint and getting an error 3807 Object Spool 2 does not exist. when I run the select part of the query it works fine. when I take the foreign key off the table being inserted to it works fine.I can't even run an explain on the insert query - which implies its not my data.Has anyone come across this before or have any immediate ideas ? Tue, 29 Jan 2008 08:48:30 GMTSuperflash