+ Reply to Thread
Page 1 of 2 1 2 LastLast
Results 1 to 10 of 19

Error: -2147217865 Table or View does not exist in Oracle 9i

  1. Error: -2147217865 Table or View does not exist in Oracle 9i

    Hi team,

    We have two schemas SLT5 and SLT6 in oracle 9i database. In both the
    schema, we have two users TESTA and TESTB. Our application is logging
    in using TESTA credentials in both the schemas and trying to access the
    tables owned by TESTB.

    The problem is that, when we run the application connecting to SLT5
    schema. It is working fine. When tried connecting to SLT6 schema. It
    gives an error "Table or View does not exist" in a select query.

    We compare all the privileges in SLT5 and SLT6 schemas for both the
    users (specifically TESTA user). All found same. But we did not get any
    resolution. Even though, TESTA user has the SELECT privilege on those
    tables of TESTB.

    Could any body help me out.

    Thanks,
    Nizam.


  2. Re: Error: -2147217865 Table or View does not exist in Oracle 9i

    Nizam wrote:
    > Hi team,
    >
    > We have two schemas SLT5 and SLT6 in oracle 9i database. In both the
    > schema, we have two users TESTA and TESTB. Our application is logging
    > in using TESTA credentials in both the schemas and trying to access the
    > tables owned by TESTB.
    >
    > The problem is that, when we run the application connecting to SLT5
    > schema. It is working fine. When tried connecting to SLT6 schema. It
    > gives an error "Table or View does not exist" in a select query.
    >
    > We compare all the privileges in SLT5 and SLT6 schemas for both the
    > users (specifically TESTA user). All found same. But we did not get any
    > resolution. Even though, TESTA user has the SELECT privilege on those
    > tables of TESTB.
    >
    > Could any body help me out.
    >
    > Thanks,
    > Nizam.


    Not without seeing your code.

    The following statement you make are not possible as you have stated it.

    You can not have as you state it:
    "In both the schema, we have two users TESTA and TESTB"

    What are the schema names?
    Who owns the application's objects?
    Are there synonyms or are you specifying schema_name dot object_name?

    It might help to post the following:

    conn testa/
    select table_name from user_tables;
    conn testb/
    select table_name from user_tables;

    conn testa/
    you query
    conn testb/
    your query
    --
    Daniel Morgan
    Puget Sound Oracle Users Group

  3. Re: Error: -2147217865 Table or View does not exist in Oracle 9i

    Nizam wrote:
    > Hi team,
    >
    > We have two schemas SLT5 and SLT6 in oracle 9i database. In both the
    > schema, we have two users TESTA and TESTB. Our application is logging
    > in using TESTA credentials in both the schemas and trying to access the
    > tables owned by TESTB.
    >
    > The problem is that, when we run the application connecting to SLT5
    > schema. It is working fine. When tried connecting to SLT6 schema. It
    > gives an error "Table or View does not exist" in a select query.
    >
    > We compare all the privileges in SLT5 and SLT6 schemas for both the
    > users (specifically TESTA user). All found same. But we did not get any
    > resolution. Even though, TESTA user has the SELECT privilege on those
    > tables of TESTB.
    >
    > Could any body help me out.
    >
    > Thanks,
    > Nizam.


    Not without seeing your code.

    The following statement you make are not possible as you have stated it.

    You can not have as you state it:
    "In both the schema, we have two users TESTA and TESTB"

    What are the schema names?
    Who owns the application's objects?
    Are there synonyms or are you specifying schema_name dot object_name?

    It might help to post the following:

    conn testa/
    select table_name from user_tables;
    conn testb/
    select table_name from user_tables;

    conn testa/
    you query
    conn testb/
    your query
    --
    Daniel Morgan
    Puget Sound Oracle Users Group

  4. Re: Error: -2147217865 Table or View does not exist in Oracle 9i

    Nizam wrote:
    > Hi team,
    >
    > We have two schemas SLT5 and SLT6 in oracle 9i database. In both the
    > schema, we have two users TESTA and TESTB. Our application is logging
    > in using TESTA credentials in both the schemas and trying to access the
    > tables owned by TESTB.
    >
    > The problem is that, when we run the application connecting to SLT5
    > schema. It is working fine. When tried connecting to SLT6 schema. It
    > gives an error "Table or View does not exist" in a select query.
    >
    > We compare all the privileges in SLT5 and SLT6 schemas for both the
    > users (specifically TESTA user). All found same. But we did not get any
    > resolution. Even though, TESTA user has the SELECT privilege on those
    > tables of TESTB.
    >
    > Could any body help me out.
    >
    > Thanks,
    > Nizam.


    Not without seeing your code.

    The following statement you make are not possible as you have stated it.

    You can not have as you state it:
    "In both the schema, we have two users TESTA and TESTB"

    What are the schema names?
    Who owns the application's objects?
    Are there synonyms or are you specifying schema_name dot object_name?

    It might help to post the following:

    conn testa/
    select table_name from user_tables;
    conn testb/
    select table_name from user_tables;

    conn testa/
    you query
    conn testb/
    your query
    --
    Daniel Morgan
    Puget Sound Oracle Users Group

  5. Re: Error: -2147217865 Table or View does not exist in Oracle 9i

    On Thu, 21 Sep 2006 14:40:59 -0700, Nizam wrote:

    > Hi team,
    >
    > We have two schemas SLT5 and SLT6 in oracle 9i database. In both the
    > schema, we have two users TESTA and TESTB. Our application is logging
    > in using TESTA credentials in both the schemas and trying to access the
    > tables owned by TESTB.
    >
    > The problem is that, when we run the application connecting to SLT5
    > schema. It is working fine. When tried connecting to SLT6 schema. It
    > gives an error "Table or View does not exist" in a select query.
    >
    > We compare all the privileges in SLT5 and SLT6 schemas for both the
    > users (specifically TESTA user). All found same. But we did not get any
    > resolution. Even though, TESTA user has the SELECT privilege on those
    > tables of TESTB.
    >
    > Could any body help me out.
    >
    > Thanks,
    > Nizam.



    You should set up a login trigger which would do something like this:
    ALTER SESSION SET TRACEFILE_IDENTIFIER=SCOOBYDOO;
    ALTER SESSION SET EVENTS='942 TRACE NAME ERRORSTACK FOREVER, LEVEL 3';

    That will produce trace file with the exact statement which causes the
    error. Don't forget to remove the trigger when you're done.

    --
    http://www.mgogala.com


  6. Re: Error: -2147217865 Table or View does not exist in Oracle 9i

    On Thu, 21 Sep 2006 14:40:59 -0700, Nizam wrote:

    > Hi team,
    >
    > We have two schemas SLT5 and SLT6 in oracle 9i database. In both the
    > schema, we have two users TESTA and TESTB. Our application is logging
    > in using TESTA credentials in both the schemas and trying to access the
    > tables owned by TESTB.
    >
    > The problem is that, when we run the application connecting to SLT5
    > schema. It is working fine. When tried connecting to SLT6 schema. It
    > gives an error "Table or View does not exist" in a select query.
    >
    > We compare all the privileges in SLT5 and SLT6 schemas for both the
    > users (specifically TESTA user). All found same. But we did not get any
    > resolution. Even though, TESTA user has the SELECT privilege on those
    > tables of TESTB.
    >
    > Could any body help me out.
    >
    > Thanks,
    > Nizam.



    You should set up a login trigger which would do something like this:
    ALTER SESSION SET TRACEFILE_IDENTIFIER=SCOOBYDOO;
    ALTER SESSION SET EVENTS='942 TRACE NAME ERRORSTACK FOREVER, LEVEL 3';

    That will produce trace file with the exact statement which causes the
    error. Don't forget to remove the trigger when you're done.

    --
    http://www.mgogala.com


  7. Re: Error: -2147217865 Table or View does not exist in Oracle 9i

    On Thu, 21 Sep 2006 14:40:59 -0700, Nizam wrote:

    > Hi team,
    >
    > We have two schemas SLT5 and SLT6 in oracle 9i database. In both the
    > schema, we have two users TESTA and TESTB. Our application is logging
    > in using TESTA credentials in both the schemas and trying to access the
    > tables owned by TESTB.
    >
    > The problem is that, when we run the application connecting to SLT5
    > schema. It is working fine. When tried connecting to SLT6 schema. It
    > gives an error "Table or View does not exist" in a select query.
    >
    > We compare all the privileges in SLT5 and SLT6 schemas for both the
    > users (specifically TESTA user). All found same. But we did not get any
    > resolution. Even though, TESTA user has the SELECT privilege on those
    > tables of TESTB.
    >
    > Could any body help me out.
    >
    > Thanks,
    > Nizam.



    You should set up a login trigger which would do something like this:
    ALTER SESSION SET TRACEFILE_IDENTIFIER=SCOOBYDOO;
    ALTER SESSION SET EVENTS='942 TRACE NAME ERRORSTACK FOREVER, LEVEL 3';

    That will produce trace file with the exact statement which causes the
    error. Don't forget to remove the trigger when you're done.

    --
    http://www.mgogala.com


  8. Re: Error: -2147217865 Table or View does not exist in Oracle 9i

    In the schema that is giving you trouble (SLT6):

    start a sqlplus session and
    do a simple

    desc table_name (where table_name is table in the other schema
    SLT5)

    If you can not get to it. Try:

    desc SLT5.table_name

    If you can get to it, either create a public synonym for that table or
    create a private synonym within schema SLT6 or change the SQL statement
    to fully qualifed name.

    If you cannot get to it, you don't have select privilege to that table.


  9. Re: Error: -2147217865 Table or View does not exist in Oracle 9i

    In the schema that is giving you trouble (SLT6):

    start a sqlplus session and
    do a simple

    desc table_name (where table_name is table in the other schema
    SLT5)

    If you can not get to it. Try:

    desc SLT5.table_name

    If you can get to it, either create a public synonym for that table or
    create a private synonym within schema SLT6 or change the SQL statement
    to fully qualifed name.

    If you cannot get to it, you don't have select privilege to that table.


  10. Re: Error: -2147217865 Table or View does not exist in Oracle 9i

    In the schema that is giving you trouble (SLT6):

    start a sqlplus session and
    do a simple

    desc table_name (where table_name is table in the other schema
    SLT5)

    If you can not get to it. Try:

    desc SLT5.table_name

    If you can get to it, either create a public synonym for that table or
    create a private synonym within schema SLT6 or change the SQL statement
    to fully qualifed name.

    If you cannot get to it, you don't have select privilege to that table.


+ Reply to Thread
Page 1 of 2 1 2 LastLast