-
Query -- 8.1.7.0.0 (sequence in 8.1.7.0.0)(sun solaris 32 bit)
------
SELECT SEQ_QUEUE.NEXTVAL,
ca.customer_id
FROM CUSTOMER_ACTIVATIONS@SOURCE_DB ca
WHERE ca.customer_id NOT IN (SELECT unique_id
FROM WEBCARE_ORIG_EVENT@SOURCE_DB
WHERE event_type = 1
AND unique_id = ca.customer_id)
Remote DB 7.3.4.1.0 (SOURCE_DB).(HP Unix)
Above query does not work and gives the following error in 8.1.7.0.0. But works fine in 8.1.6.3.0
ORA-00920invalid relational operator
ORA-02063preceding line from SOURCE_DB
Any help will be appreciated.
Thanks in advance.
Raj
-
8.1.7..0 had a lot of bugs please apply the patch to the latest version of 8i which 8.1.7.3.2
-
Is your db link configured correctly on 8.1.7? Do you get results from the following queries?
SELECT * FROM WEBCARE_ORIG_EVENT@SOURCE_DB WHERE ROWNUM=1;
SELECT * FROM DUAL@SOURCE_DB;
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
Hello All,
Thanks for the help.
jmodic , The queries you have mentioned, both works fine.
First fetches one row. second fetch is X from dual.
Can I straight away apply 8.1.7.3.2 on 8.1.7.0.0?. Please let me know the patch# or any reference. (I am new to this Oracle DBA. I can use metalink. Can I get it from there?)
Thanks in advance.
Raj
-
Yes, you can get patches from Metalink. I'm not 100% sure about Solaris, but I think you'll first need to apply patchset to go to 8.1.7.3 (patch number 2189751), and then apply a patch for 8.1.7.3.2 (if it is available for Soalris) on top of that.
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
Hello jmodic,
Thank you very much. I will apply the patch and check the result.
Regards
Raj
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|