Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Renaming a column
>
> Joe --
>
> If you can get the name of that x$ table out of your sogged mind,
> next eggnog is on me! The only way that I know of to rename a
> column is to create another table with the column name you want
> as select * from x, then drop x, and rename your new table to x,
> and you're done. Makes sense that you can screw around with the
> internals; the column name has to be kept somewhere; but, it reeks
> of danger to me... and I'd like to test it out.
>
> Best for 96!
> Bambi.
>
Hello Seniors and Experts,
Just being a bit curious... Aren't all x$ tables undocumented ? Is there a way to get the list of x$ tables and their descriptions ? All I know is x$kppi which stores the parameter name and value.
Thanks,
Rukmani.
Received on Sun Dec 31 1995 - 08:03:09 CST
![]() |
![]() |