Using the SQL SERVER2005 Export tool, the data export table to Oracle, the table name to see the table, but the query or delete prompt "ORA-00942 table or try not to exist" error, the internet to check a bit, is the following reasons:
"When you query or delete a table with a name that doesn't exist, do you see if the table names are lowercase in user_tables?" That means you must have the quotation mark when you build the watch, and please quote it when you select. For example: SELECT * from "TableName", you can see if the table name is lowercase in SQL Server, when imported to Oracle, the table will be built with double quotation marks, so when exported to Oracle, when user_tables, the table name will be lowercase, Rather than the capitalization we see in general. ”
Try some of the results are true, the table name is more quotes, delete and re-import, import the table name to uppercase is OK.