| Could you help me? [message #372875] |
Thu, 15 March 2001 03:24  |
mhy
Messages: 15
Registered: March 2001
|
Junior Member |
|
|
Dear sir:
I met a question that's I transmit data from SQL sever 7.0 with its Export tool.I can find table name with sql sentence "select table_name from user_tables",but when I use "desc tablename",I got an error:the object you select isn't exist.
|
|
|
|
| Re: Could you help me? [message #372881 is a reply to message #372875] |
Thu, 15 March 2001 08:09  |
Siddharth Bahri
Messages: 18
Registered: March 2001
|
Junior Member |
|
|
Hi,
If you exported data from SQL Server's DTS Wizard make sure that the the name you gave to the table was in UPPER CASE.
If the name was not in upper case then the table created in oracle will have the name "table_name" instead of TABLE_NAME
(note the double quotes around the name).
To query this table you will have to write
Select * from "table_name"
-Siddharth
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
