| I can't see table [message #64101] |
Wed, 15 December 2004 13:20  |
jack
Messages: 123
Registered: September 2000
|
Senior Member |
|
|
I transfered a table from SQLSERVER2000 to Oracle 9. After transfered, I can find the table name when I am checking user_tables. But I can't find it when I use desc utility. Furthermore, I can find all the details about it with OEM in terms of struture and contents.
Can some body tell me the reason? Thanks in advance!
take care
Jack
|
|
|
|
| Re: I can't see table [message #64104 is a reply to message #64101] |
Wed, 15 December 2004 23:39  |
Frank
Messages: 7901
Registered: March 2000
|
Senior Member |
|
|
In user_tables, does it display in all uppercase ?
Normally in Oracle, objects are created with names in uppercase.
It is however possible to use lowercase/mixed case by using double quotes.
If your table shows in user_tables as lowercase, try to enclose this name in double quotes when describing it.
(For further use, it would be handy to rename the table to an all uppercase name )
hth
|
|
|
|
| Re: I can't see table [message #64133 is a reply to message #64104] |
Mon, 20 December 2004 07:29 |
jack
Messages: 123
Registered: September 2000
|
Senior Member |
|
|
Hi, Frank
Thanks for your suggestion. You are right that it is a problem of case sensitiveness. I wanted to change the name of the table. As I know, there is not command can change it directly. I wanted to used EXP/IMP. The problem is that it was still case sensitive. Can you explain to me some ways to resolve the problem?
Thanks in advance
Jack
|
|
|
|
| Re: I can't see table [message #64166 is a reply to message #64133] |
Fri, 24 December 2004 04:43 |
Frank
Messages: 7901
Registered: March 2000
|
Senior Member |
|
|
As a matter of fact, there IS a command for renaming tables in Oracle 9:
See the docs
rename <<z>old_tablename> to <<z>new_tablename>;
Remember to double-quote the old tablename.
hth
|
|
|
|
| Re: I can't see table [message #64167 is a reply to message #64166] |
Fri, 24 December 2004 05:54 |
jack
Messages: 123
Registered: September 2000
|
Senior Member |
|
|
Thanks for your information for the rename command. While my problem is still there and now I find it more interesting that I not only can't rename it but also can't drop it off because the commands can't find the table in terms of drop and rename. Do you have suggestions with this situation? Thanks for your help!
Jack
|
|
|
|
| Re: I can't see table [message #64168 is a reply to message #64167] |
Sat, 25 December 2004 00:59 |
Frank
Messages: 7901
Registered: March 2000
|
Senior Member |
|
|
I made an example:
SCOTT>create table "MixedCase" ("Id" int, "Name" varchar2(10));
Table created.
SCOTT>desc mixedcase
ERROR:
ORA-04043: object mixedcase does not exist
SCOTT>select table_name from user_tables;
TABLE_NAME
------------------------------
MixedCase
SCOTT>rename "MixedCase" to mixedcase;
Table renamed.
SCOTT>select table_name from user_tables;
TABLE_NAME
------------------------------
MIXEDCASE
SCOTT>desc mixedcase
Name Null? Type
----------------------------------------- -------- ----------------------------
Id NUMBER(38)
Name VARCHAR2(10)
So, also in your drop/rename command you have to use the double quotes.
hth
|
|
|
|
| Re: I can't see table [message #64170 is a reply to message #64168] |
Sat, 25 December 2004 05:32 |
jack
Messages: 123
Registered: September 2000
|
Senior Member |
|
|
Frank, thank you very much. The problem got resolved. Last time I tried to quote the table name with single quote. That is the reason I failed.
Jack
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
