Post reply

Oracle "table or view does not exist" after successful SSIS table export

  • February 28, 2014 at 2:36 pm

    #304861

    I successfully exported a table using Visual Studio 2008 SSIS to an Oracle database. I see the table in the Oracle database from SQL Developer, but when I try and query the table using a select statement I get a "table or view does not exist" error? But, the table is there and has data anybody experience this?

  • February 28, 2014 at 4:07 pm

    #1693298

    case sensitive tablenames?

  • February 28, 2014 at 4:52 pm

    #1693301

    Found it needed to use qoutes like this. I also tried using another table name and it worked. Got to love Oracle. GRRrrr.

    SELECT * from TESTDB."test2"

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply