Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

altering the size of number column

Ora-affJul 9 2014 — edited Jul 10 2014

Hi,

I have created a table with primary key column declared as NUMBER (default specification).

Create table T

(

col1 primary key number,

col2 varchar2(10)

);

Then I populated this table using sequence. Now I want to modify the size of primary key column to number (15).

Is it possible without emptying the primary key column?
This post has been answered by Karthick2003 on Jul 9 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 7 2014
Added on Jul 9 2014
9 comments
4,025 views