> >>> is there any option how to rename table?
> >>
> >> Nobody knows? :\
> >
> > Sure, the only thing you can do is extract the DDL, rename the table
> > and recreate the table. Next, pump the data.
> >
> > There's no built-in "rename" functionality.
>
> It's not good. :( The table is about too big to do this.
>
> So it must stay as is.

In some cases, the following solution might help:

create view mynewname as select * from myoldtable

:-)

This is what we did when someone finally discovered a typo in a legacy
table name already in use all over the bloody application! The guy who
created the table and continued using it with the typo included was,
obviously, smacked in the head :-)

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com