Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Location
    Dhaka,Bangladesh
    Posts
    86

    Question Unanswered: SQL server to Oracle Convertion

    Hello experts...

    Recently tried to covert one of my database table pub(authors) in Oracle9i
    schema using SQL SERVER's "Import and Export Data". The convertion was succesful nut when i logged in Oracle and tried to select that authors table its show me error...

    oracle shows its a table when i issue...

    SQL> select * from cat;
    TABLE_NAME TABLE_TYPE
    ------------------------------ -----------
    BONUS TABLE
    DEPT TABLE
    EMP TABLE
    SALGRADE TABLE
    authors TABLE / * this table comes from SQL server */

    but when i issued as..

    SQL> select * from authors;
    select * from authors
    *
    ERROR at line 1:
    ORA-00942: table or view does not exist

    So, Please help me anyone.I will greatfull to him...Thnaks a Lot.
    hello

  2. #2
    Join Date
    Oct 2003
    Posts
    232

    Arrow

    give right to those table with a grant statement
    bigfoots

  3. #3
    Join Date
    Nov 2003
    Location
    Dhaka,Bangladesh
    Posts
    86

    Thnak You sjumma but plz help me more

    Thnaks sjumma

    I tried to "grant select on [that SQL Server table] to soctt" from system account but still its showing the same error message holding no such object.
    Please give me an example or any other help.
    hello

  4. #4
    Join Date
    Dec 2002
    Posts
    1,245
    Check schema ownership. If the tables created in SQL were not created in the dbo schema, you will have to precisely identify them [schema owner].[table name]

    Regards,

    hmscott

    Quote Originally Posted by Mahfuz
    Thnaks sjumma

    I tried to "grant select on [that SQL Server table] to soctt" from system account but still its showing the same error message holding no such object.
    Please give me an example or any other help.
    Have you hugged your backup today?

Posting Permissions

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