Re: OPS$ Help

From: Charles Jardine <cj10_at_cam.ac.uk>
Date: 1996/02/05
Message-ID: <4f4p3s$gmo_at_lyra.csx.cam.ac.uk>#1/1

pallison_at_ppg.com wrote:
>I just did a user export from one instance and imported into another.
>The user ID is SFA and is identified externally.
>When I go into the new instance and try to select or even describe
>the tables, I get a table does not exist error. I am logged onto unix
>as SFA and OPS$SFA shows up in the v$session when I am on.
>SFA is the owner of the tables.
>
>Does anyone know why OPS$SFA can't see the table.
>
>In the old instance it can.

Check the values of the INIT.ORA parameter OS_AUTHENT_PREFIX for the two instances. I expect the old instance has is set to the empty string (spelt ""), and the new instance has it defaulting to OPS$. Received on Mon Feb 05 1996 - 00:00:00 CET

This message: [ Message body ]
Next message: Dave Eason: "Re: Unable to use ORDER BY in an INSERT statement"
Previous message: Richard Moulding: "Re: Insert into an Oracle DB from Excel - how?"
In reply to: pallison_at_ppg.com: "OPS$ Help"
In reply to E A Macnaghten: "Re: OPS$ Help"
Next in thread: Dave Eason: "Re: Unable to use ORDER BY in an INSERT statement"
Reply: Tom Cooke: "Re: OPS$ Help"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message