OraFAQ Forum: Server Administration » ORA-0904 after migration workbench from Sybase to Oracle HELP

Home » RDBMS Server » Server Administration » ORA-0904 after migration workbench from Sybase to Oracle HELP

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

ORA-0904 after migration workbench from Sybase to Oracle HELP [message #218054]

Tue, 06 February 2007 10:32

Teresa
Messages: 36
Registered: May 2002

Member

Hi

After a oracle migration workbench from sybase to oracle some table columns have a "_" but in sybase we dont have the "_" how can I get ride of them? this is from sybase 12.0 to oracle 10gR2 on solaris 5.8
Thank You
Teresa

Report message to a moderator

Re: ORA-0904 after migration workbench from Sybase to Oracle HELP [message #218114 is a reply to message #218054]

Tue, 06 February 2007 20:36

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Are these objects in question Sybase temporary tables or reserved words?

Report message to a moderator

Re: ORA-0904 after migration workbench from Sybase to Oracle HELP [message #218245 is a reply to message #218114]

Wed, 07 February 2007 08:06

Teresa
Messages: 36
Registered: May 2002

Member

This are permant tables from sybase, but the issue is not consistent, sometimes copies the tables with a "_" other times they are fine,

Report message to a moderator

Re: ORA-0904 after migration workbench from Sybase to Oracle HELP [message #218297 is a reply to message #218245]

Wed, 07 February 2007 11:48

ebrian
Messages: 2794
Registered: April 2006

Senior Member

If you can't resolve the problem during the migration, then you could simply rename the tables once they are in Oracle with:

alter table <bad_table_name> rename to <good_table_name>;

You'll have to check any of the existing code for this name change too.

Report message to a moderator

Previous Topic:	opatch lsinventory fails with 72
Next Topic:	Oracle10g+APEX+HTTP Server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 01:22:55 CDT 2024