|
-
In oracle table name is not case sensitive, in SQL server, default, table name is case sensitive. So after import SQL server table, you table anme is case sensitive. You have to get the table name from user_tables, then you have to use " " for your table name, this way, Oracle know your table name is case sensitive. In your case, your table name is "jobs". But in oracle, if you use
select * from jobs.
In oracle it means
select * from "JOBS".
But your table name is "jobs".
xyz
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|