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
Printable View
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
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
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
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
To Mahesh..
Such a lazy dumbass..