Hi,
Does anyone know if the end result of these two statements is actually
any different?
CREATE TABLE mytable (
mycol1 NUMBER,
mycol2 VARCHAR2(40),
mycol3 VARCHAR2(30));
and
CREATE TABLE mytable (
mycol1 NUMBER);
ALTER TABLE mytable ADD (mycol2 VARCHAR2(40));
g,
why not try it
the answer is - no difference.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Friday, August 17, 2001 6:01 AM
To: Multiple recipients of list ORACLE-L
Hi,
Does anyone know if the end result of these two statements is actually
any
Thanks Tom.
I know that logically the schema would be the same, I was just wondering
if the underlying physical storage set up by Oracle would in some way be
suboptimal in the second case. But if they're identical, that's great,
because it means I don't need to worry about patching schemas :0)
For all intensive purposes the table will be created the same. But, and someone with
the ability to read the block data please check it out.
There are my own thoughts In method 1 the block data is set up to have 3 columns
per table. In method 2 the table is set up to have 1 column and the
No need to worry - there is no 'data block' info
about how many columns are defined to the table.
Every row stored has a byte indicating the number
of columns actually used in that row.
Consequently a row with the first column filled out
of three will look identical to a row belonging to a
On Fri, 17 Aug 2001, [EMAIL PROTECTED] wrote:
If you had a large number of columns that would fill a block
and the added a column, would the row be chained or migrated?
On creating the column, no extra space should be added, but then
when the column gets updated, rows could start getting
