RE: How to re-arrange the nullable columns
Thanks to all ... Nirmal. -Original Message- From: Christopher Spence [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, June 13, 2001 2:40 AM To: Multiple recipients of list ORACLE-L Subject: RE: How to re-arrange the nullable columns There are reasons of storage/performance that simply creating a view will not address. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Tuesday, June 12, 2001 12:12 PM To: Multiple recipients of list ORACLE-L If its for application developers ease in INSERT etc. then how about creating a view which has columns in proper order? -Rahul - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, June 12, 2001 8:45 AM Hi DBA's, Greetings... In some of application tables, i found not null columns are appeared at the last. So, how can i re-arrange by the way i can make the not null columns are in the earliest of the table. Is the only way to re-create the tables accordingly, or any other best methods are there?. Thanks. Regards, Nirmal. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul Dandekar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
How to re-arrange the nullable columns
Hi DBA's, Greetings... In some of application tables, i found not null columns are appeared at the last. So, how can i re-arrange by the way i can make the not null columns are in the earliest of the table. Is the only way to re-create the tables accordingly, or any other best methods are there?. Thanks. Regards, Nirmal. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to re-arrange the nullable columns
Hi Nirmal, Unfortunately, a table re-org (one way of the other) is the only solution to do this. We use a third party tool that unloads, drops, creates, loads the table. It also takes care of all the grants etc. Just a short cut to all the manual steps. Not sure if 9i has anything to address such things. Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Nirmal Kumar Muthu Kumaran [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 12, 2001 7:46 AM To: Multiple recipients of list ORACLE-L Subject: How to re-arrange the nullable columns Hi DBA's, Greetings... In some of application tables, i found not null columns are appeared at the last. So, how can i re-arrange by the way i can make the not null columns are in the earliest of the table. Is the only way to re-create the tables accordingly, or any other best methods are there?. Thanks. Regards, Nirmal. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to re-arrange the nullable columns
It makes no difference in performance where the not null columns are placed. Why do you want to go to the headache of modifying the table structure for something so trivial? [EMAIL PROTECTED] 06/12/01 08:45AM Hi DBA's, Greetings... In some of application tables, i found not null columns are appeared at the last. So, how can i re-arrange by the way i can make the not null columns are in the earliest of the table. Is the only way to re-create the tables accordingly, or any other best methods are there?. Thanks. Regards, Nirmal. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: William Beilstein INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to re-arrange the nullable columns
Yes, 9i you can move modify drop add anything having to do with a table. Pretty impressive. Now to see it work and stand up the test of time. The ultimate test. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Tuesday, June 12, 2001 10:42 AM To: Multiple recipients of list ORACLE-L Hi Nirmal, Unfortunately, a table re-org (one way of the other) is the only solution to do this. We use a third party tool that unloads, drops, creates, loads the table. It also takes care of all the grants etc. Just a short cut to all the manual steps. Not sure if 9i has anything to address such things. Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Nirmal Kumar Muthu Kumaran [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 12, 2001 7:46 AM To: Multiple recipients of list ORACLE-L Subject: How to re-arrange the nullable columns Hi DBA's, Greetings... In some of application tables, i found not null columns are appeared at the last. So, how can i re-arrange by the way i can make the not null columns are in the earliest of the table. Is the only way to re-create the tables accordingly, or any other best methods are there?. Thanks. Regards, Nirmal. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to re-arrange the nullable columns
Chris, The question was, can you shuffle the order of the columns in 9i? Or add new columns after/before a particular column? - Kirti -Original Message- From: Christopher Spence [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 12, 2001 11:07 AM To: Multiple recipients of list ORACLE-L Subject: RE: How to re-arrange the nullable columns Yes, 9i you can move modify drop add anything having to do with a table. Pretty impressive. Now to see it work and stand up the test of time. The ultimate test. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Tuesday, June 12, 2001 10:42 AM To: Multiple recipients of list ORACLE-L Hi Nirmal, Unfortunately, a table re-org (one way of the other) is the only solution to do this. We use a third party tool that unloads, drops, creates, loads the table. It also takes care of all the grants etc. Just a short cut to all the manual steps. Not sure if 9i has anything to address such things. Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Nirmal Kumar Muthu Kumaran [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 12, 2001 7:46 AM To: Multiple recipients of list ORACLE-L Subject:How to re-arrange the nullable columns Hi DBA's, Greetings... In some of application tables, i found not null columns are appeared at the last. So, how can i re-arrange by the way i can make the not null columns are in the earliest of the table. Is the only way to re-create the tables accordingly, or any other best methods are there?. Thanks. Regards, Nirmal. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to re-arrange the nullable columns
I beg to differ. Storage as well as performance is effected if nulls are not at the end of a table. Although it is not a HUGE concern, it is certainly fine tuning. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Tuesday, June 12, 2001 11:01 AM To: Multiple recipients of list ORACLE-L It makes no difference in performance where the not null columns are placed. Why do you want to go to the headache of modifying the table structure for something so trivial? [EMAIL PROTECTED] 06/12/01 08:45AM Hi DBA's, Greetings... In some of application tables, i found not null columns are appeared at the last. So, how can i re-arrange by the way i can make the not null columns are in the earliest of the table. Is the only way to re-create the tables accordingly, or any other best methods are there?. Thanks. Regards, Nirmal. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: William Beilstein INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to re-arrange the nullable columns
If its for application developers ease in INSERT etc. then how about creating a view which has columns in proper order? -Rahul - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, June 12, 2001 8:45 AM Hi DBA's, Greetings... In some of application tables, i found not null columns are appeared at the last. So, how can i re-arrange by the way i can make the not null columns are in the earliest of the table. Is the only way to re-create the tables accordingly, or any other best methods are there?. Thanks. Regards, Nirmal. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul Dandekar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to re-arrange the nullable columns
Actually I think Oracle recommends that NULL columns should be placed at the end of the row for optimal storage of the row in the block. - Ethan Post -Original Message- Sent: Tuesday, June 12, 2001 8:01 AM To: Multiple recipients of list ORACLE-L It makes no difference in performance where the not null columns are placed. Why do you want to go to the headache of modifying the table structure for something so trivial? [EMAIL PROTECTED] 06/12/01 08:45AM Hi DBA's, Greetings... In some of application tables, i found not null columns are appeared at the last. So, how can i re-arrange by the way i can make the not null columns are in the earliest of the table. Is the only way to re-create the tables accordingly, or any other best methods are there?. Thanks. Regards, Nirmal. -- This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to re-arrange the nullable columns
Yeah, Perfomance wise there is no benefit(if yes pls correct me), But i read in manuals as, if the not null columns were resided as a last column of a table, then it consumes more storage space then the other case. Any one have any suggestions regarding this issue Regards, Nirmal. -Original Message- From: William Beilstein [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 12, 2001 6:01 PM To: Multiple recipients of list ORACLE-L Subject: Re: How to re-arrange the nullable columns It makes no difference in performance where the not null columns are placed. Why do you want to go to the headache of modifying the table structure for something so trivial? [EMAIL PROTECTED] 06/12/01 08:45AM Hi DBA's, Greetings... In some of application tables, i found not null columns are appeared at the last. So, how can i re-arrange by the way i can make the not null columns are in the earliest of the table. Is the only way to re-create the tables accordingly, or any other best methods are there?. Thanks. Regards, Nirmal. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: William Beilstein INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to re-arrange the nullable columns
If a row takes more storage, wouldn't it be safe to say it is slower than one of less storage? Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Tuesday, June 12, 2001 1:28 PM To: Multiple recipients of list ORACLE-L Yeah, Perfomance wise there is no benefit(if yes pls correct me), But i read in manuals as, if the not null columns were resided as a last column of a table, then it consumes more storage space then the other case. Any one have any suggestions regarding this issue Regards, Nirmal. -Original Message- From: William Beilstein [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 12, 2001 6:01 PM To: Multiple recipients of list ORACLE-L Subject: Re: How to re-arrange the nullable columns It makes no difference in performance where the not null columns are placed. Why do you want to go to the headache of modifying the table structure for something so trivial? [EMAIL PROTECTED] 06/12/01 08:45AM Hi DBA's, Greetings... In some of application tables, i found not null columns are appeared at the last. So, how can i re-arrange by the way i can make the not null columns are in the earliest of the table. Is the only way to re-create the tables accordingly, or any other best methods are there?. Thanks. Regards, Nirmal. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: William Beilstein INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to re-arrange the nullable columns
There are reasons of storage/performance that simply creating a view will not address. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Tuesday, June 12, 2001 12:12 PM To: Multiple recipients of list ORACLE-L If its for application developers ease in INSERT etc. then how about creating a view which has columns in proper order? -Rahul - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, June 12, 2001 8:45 AM Hi DBA's, Greetings... In some of application tables, i found not null columns are appeared at the last. So, how can i re-arrange by the way i can make the not null columns are in the earliest of the table. Is the only way to re-create the tables accordingly, or any other best methods are there?. Thanks. Regards, Nirmal. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul Dandekar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).