Home » Other » General » Exporting from SQL Server2000 to Oracle9i
Exporting from SQL Server2000 to Oracle9i [message #104538] Mon, 22 November 2004 01:51 Go to next message
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.

 

 
Re: Exporting from SQL Server2000 to Oracle9i [message #104543 is a reply to message #104538] Tue, 23 November 2004 03:25 Go to previous message
Frank Naude
Messages: 4579
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
Previous Topic: courses for financial background
Next Topic: retreiving UTF-8 encoded data to Pro C using OCI
Goto Forum:
  


Current Time: Thu Mar 28 15:25:34 CDT 2024