DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Query works in 8.1.6.3.0 not in 8.1.7.0.0

  1. #1
    Join Date
    Apr 2002
    Posts
    7
    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

  2. #2
    Join Date
    Aug 2001
    Posts
    390
    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


  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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?

  4. #4
    Join Date
    Apr 2002
    Posts
    7
    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

  5. #5
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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?

  6. #6
    Join Date
    Apr 2002
    Posts
    7
    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
  •  


Click Here to Expand Forum to Full Width