Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: rename a table/view
Hi Karsten,
The poster has asked how to change the name of table without impacting data already stored.
Excuse me if I'm missing something but what's wrong with RENAME oldname TO newname ?
It's basically that simple with or without FKs ...
You may however have issues with dependent views or stored programs.
Cheers
Richard
"Karsten Farell" <kfarrell_at_medimpact.com> wrote in message
news:CaLk9.3209$B51.85314729_at_newssvr21.news.prodigy.com...
> If you have *not* implemented integrity constraints (Primary Key /
> Foreign Key), it's a snap:
>
> create temp_table as select * from orig_table;
> drop table orig_table;
> alter table temp_table rename to orig_table;
>
> Recreate any indexes on orig_table.
>
> If you *have* implemented integrity constraints, you have your work cut
> out for you. You can disable them on any tables "related" to your
> orig_table, then follow the above, then enable them again. But only you
> know the parent-child relationships among your tables. You'll have to
> research that.
>
> Erin Gu wrote:
> > Hi,
> > what I am trying to accomplish is change table/view name without impact
on
> > data stored already. Any suggestions?
> >
> > Thanks in advance!
> >
> > Erin
> >
>
Received on Fri Sep 27 2002 - 07:08:16 CDT