Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mdienta
Starting Member
2 Posts |
 Posted - 2010-06-17 : 22:27:02
|
| here is my problem 1 UPDATE EMP_BK 2 SET JOB='(PRESIDENT)' 3* WHERE ENAME='KING'SQL> /SET JOB='(PRESIDENT)' *ERROR at line 2:ORA-12899: value too large for column "SQL_USER"."EMP_BK"."JOB" (actual: 11,maximum: 9)my action was 1 ALTER TABLE EMP_BK 2* ALTER COLUMN JOB varchar(20)SQL> /ALTER COLUMN JOB varchar(20)*ERROR at line 2:ORA-01735: invalid ALTER TABLE option please help me figure out thank you |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2010-06-17 : 22:30:24
|
your question is on Oracle on SQL Server. Try posting at dbforums.com
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
mdienta
Starting Member
2 Posts |
Posted - 2010-06-17 : 22:41:12
|
| thank you |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-06-18 : 02:39:19
|
quote:
Originally posted by mdienta
here is my problem 1 UPDATE EMP_BK 2 SET JOB='(PRESIDENT)' 3* WHERE ENAME='KING'SQL> /SET JOB='(PRESIDENT)' *ERROR at line 2:ORA-12899: value too large for column "SQL_USER"."EMP_BK"."JOB" (actual: 11,maximum: 9)my action was 1 ALTER TABLE EMP_BK 2* ALTER COLUMN JOB varchar(20)SQL> /ALTER COLUMN JOB varchar(20)*ERROR at line 2:ORA-01735: invalid ALTER TABLE option please help me figure out thank you
ALTER TABLE EMP_BKMODIFY JOB varchar(20)MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
column size increase