Re: ORA-00942: table or view does not exist

adil wrote:
>
> hi all,
>
> I tried to migrate database abc from MS-SQL7 to ORACLE as user sa
> using ORACLE migrtion
> workbench i am getting the error 'ORA-00942: table or view does not
> exist'
> but the table exist in database abc of MS-SQL7

   Try double quote table and columns name

   SELECT * FROM "TableName"

Valery Yourinsky

-- 
Oracle8 Certified DBA
Moscow, Russia