: Tuesday, June 05, 2001 3:45 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Renaming columns ...
will this work?
RENAME TABLE_NAME TO table_name_2;
create table TABLE_NAME
( column_name_you_want...)
as select * from table_name_2;
COMMIT
You can get the same interface for the 8i docs as well at
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage. Just in case you were
interested. =)
-::YEX::-
)))
-Original Message-
Sent: Monday, 04 June, 2001 14:42 PM
To: Multiple recipients of list ORACLE-L
Kevin,
see this link
We could do this, but this is a lot of work to propagate changes to
constraints, indexes etc. I am not even counting the code changes. But we
are not going this way
Cheers
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot
will this work?
RENAME TABLE_NAME TO table_name_2;
create table TABLE_NAME(column_name_you_want...)as select * from table_name_2;COMMIT;
DROP TABLE table_name_2;COMMIT;
HTH
"Deshpande, Kirti" [EMAIL PROTECTED] wrote:
Hi Raj,1. There is a way to do it. And Mr. Steve A. has some good info about
:
Renaming columns ...
will this work?
RENAME TABLE_NAME TO table_name_2;
create table TABLE_NAME(column_name_you_want...)as select *
from table_name_2;COMMIT;
DROP TABLE table_name_2;COMMIT;
HTH
"Deshpande, Kirti" [EMAIL PROTECTED]
wrote:
Hi
Raj,1. There is a
: Tuesday, June 05, 2001 6:14
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Renaming columns ...
This
will work:
RENAME TABLE_NAME TO table_name_2;
create table TABLE_NAMEas select
* from table_name_2;
DROP TABLE
table_name_2;
Note
you don't need to issue
Hi Raj,
1. There is a way to do it. And Mr. Steve A. has some good info about it (
its implications) on his web site. (Sorry I do not have a direct URL link to
it). I believe this works for all versions.
2. Yes, it does. I have played with it on my test database.
However, I will not do this
Kirti,
Thanks for the info, BTW are there any significant advantages of moving NOT
NULL columns towards HEAD of the table?
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here
Message-
|| From: Joseph Raj [mailto:[EMAIL PROTECTED]]
|| Sent: Monday, June 04, 2001 12:46 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: Re: Renaming columns ...
||
||
|| This is right from Guru Steeve Adam's site
||
|| No, if the table is referred to in any stored PL/SQL
This is right from Guru Steeve Adam's site
No, if the table is referred to in any stored PL/SQL program units, you
must first drop those program units and then manually delete the rows for
that table (based on its OBJ# from OBJ$) from the 4 data dictionary tables
beginning with IDL. The IDL
Yes renaming a column is supported, in fact you can change almost every
aspect of a table online.
it works parallel to existing table, right before switching them over, it
gets the latest DML applied, then switches over.
Walking on water and developing software from a specification are easy if
Column position has no value what so ever.
Walking on water and developing software from a specification are easy if
both are frozen.
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
Sent: Monday, June 04, 2001 11:31 AM
To: Multiple recipients of list ORACLE-L
Kirti,
Kevin,
see this link ...
http://otn.oracle.com/docs/products/oracle9i/doc_library/901_doc/server.901/
a90117/tables.htm#12596
this link will be broken, but put it on one line and click ... there is a
complete example ...
BTW Oracle has done one job very well ... the 9i document search
Title: RE: Renaming columns ...
To add to Kirti's' comments -
The same applies for columns that have default values defined.
Lisa Koivu
Oracle Database Administrator
954-935-4117
The information in the electronic mail message is Cendant confidential and may be legally privileged
HELP !
-Original Message-
From: PHU,JULIA (HP-Sunnyvale,ex2) [SMTP:[EMAIL PROTECTED]]
Sent: Monday, June 04, 2001 2:21 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Renaming columns ...
ALTER TABLE table_name MODIFY ( new_col_name DATATYPE);
It works for me
ARE YOU AN IDIOT
|| -Original Message-
|| From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]]
|| Sent: Monday, June 04, 2001 4:17 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: RE: Renaming columns ...
||
||
|| HELP !
||
|| -Original Message-
|| From: PHU
Oops! My apology. It was for datatype changed. Erased what I said.
-Original Message-
Sent: Monday, June 04, 2001 1:59 PM
To: Multiple recipients of list ORACLE-L
How does it know which column to rename?
At 11:21 AM 6/4/01 -0800, you wrote:
ALTER TABLE table_name MODIFY (
17 matches
Mail list logo