select * from "jobs";
Why's that? Don't understand?
Next time when I export more tables from SQL Server 2000 into Oracle, how can I avoid this from happening each time when I do a select ... from "...", instead of select ....from ....;
Thanks in advance.
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