Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: rename a table/view
Thanks Karsten,
as you can tell, I am pretty new in the Oracle world!
Erin
"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 - 10:42:13 CDT