Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Discussions :

Re: Repair Tables in Oracle doesn't work!

Jul 3, 2001, 4:51 PM
Alex
Administrator (9387 posts)
Jul 3, 2001, 4:51 PM
Views: 2009
Shortcut
Quote Reply
Re: Repair Tables in Oracle doesn't work! In reply to
Hi,

Can you confirm if the following SQL works for you:

SELECT wdLinks.Title, wdLinks.ID
FROM wdLinks, wdCatLinks
WHERE wdLinks.ID = wdCatLinks.LinkID(+)
AND (wdCatLinks.LinkID IS NULL)

Our Oracle book seems to think that should work. If it does, I'll update our Oracle driver so it handles this.

Cheers,

Alex

--
Gossamer Threads Inc.
Subject Author Views Date
Thread Repair Tables in Oracle doesn't work! Anton_P 2102 Jul 2, 2001, 11:29 PM
Thread Re: Repair Tables in Oracle doesn't work! 		Alex 2009 Jul 3, 2001, 4:51 PM
Thread Yes it works. 		Anton_P 1997 Jul 3, 2001, 11:55 PM
Thread Re: Yes it works. 		Alex 1989 Jul 4, 2001, 10:06 AM
Thread Thank you! 		Anton_P 1979 Jul 4, 2001, 8:18 PM
Post Re: Thank you! 		Alex 1966 Jul 5, 2001, 12:20 PM