OraFAQ Forum: General » Exporting from SQL Server2000 to Oracle9i

Home » Other » General » Exporting from SQL Server2000 to Oracle9i

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Exporting from SQL Server2000 to Oracle9i [message #104538]

Mon, 22 November 2004 01:51

Amudan
Messages: 8
Registered: September 2004

Junior Member

HI,

While exporting sql server 2000 database to oracle9i, using sql server's Export and Import utility, I found that the name of tables are in lower case letters.� Oracle Enterprise manager displayed those tables but not used for queries and transcations.� How can I convert those tables into uppercase letters?.

�

Pl.suggest.

�

bye

Amudan.

�

�

Report message to a moderator

Re: Exporting from SQL Server2000 to Oracle9i [message #104543 is a reply to message #104538]

Tue, 23 November 2004 03:25

Frank Naude
Messages: 4587
Registered: April 1998

Senior Member

Hi,

You can rename the tables after migrating them to Oracle:

SQL> ALTER TABLE "tab1" RENAME TO "TAB1";

Table altered.

Best regards.

Frank

Report message to a moderator

Previous Topic:	courses for financial background
Next Topic:	retreiving UTF-8 encoded data to Pro C using OCI

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Dec 28 13:33:20 CST 2024