importing Sql2000 tables in to oracle 8i

[kandadaimurali]

HI

I have exported a database from sqlserver2000 to oracle8i,it was successful, i could also see the table names in oracle, but when i want to view the contents of the table it says table or view does not exists. What could be the problem?

Murali

[gbrabham]

SQL> Select table_name from user_tables ;

Logged on as the owner of the tables ...

You may find that the SQLServer tables were defined as
"Tablename" - Using both upper and lower. If this is true
and they were created in Oracle with " marks, then the tables
are now case sensitive ...

HTH
Gregg

[c.mahesh]

I have exported a database from sqlserver2000 to oracle8i,it was successful, i could also see the table names in oracle, but when i want to view the contents of the table it says table or view does not exists. What could be the problem?

Mahesh C

[davey23uk]

are you serious? you copy and paste the original question which was answered 4 years ago, dont add anything and dont even try the answer supplied?

what a disgrace

[malay_biswal]

To Mahesh..
Such a lazy dumbass..