-
importing Sql2000 tables in to oracle 8i
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
-
Import sql2000 tables
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..
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|