Results 1 to 2 of 2

Thread: DB Links

  1. #1
    Join Date
    Apr 2003
    Washington DC area

    Cool Unanswered: DB Links

    We'll I'm back in the trenches again,

    Error ORA-00942
    The error was prior to the link being setup.

    I'm getting the same error, so the link is not set up to see the data ithat is link via (table_name.field_name ref) to link database.

    Please Advise

  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    You have an error & still yet again provide ZERO details about what specifically caused the error.

    SQL> connect scott/tiger
    SQL> select count(*) from ID10T;
    select count(*) from ID10T
    ERROR at line 1:
    ORA-00942: table or view does not exist

    Either table does not exist or USER does not have required privilege to SELECT from the table.

    Problem Exists Between Keyboard And Chair!
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts