Click to See Complete Forum and Search --> : importing Sql2000 tables in to oracle 8i
kandadaimurali
10-09-2003, 01:54 AM
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
10-10-2003, 09:41 AM
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
12-25-2007, 05:10 AM
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
12-25-2007, 08:45 AM
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
12-26-2007, 03:23 AM
To Mahesh..
Such a lazy dumbass..