-
HI,
I'm getting error when I try to create a table with USER as
the default.
i.e create table test (col1 varchar2(18) default USER);
ERROR at line 1:
ORA-01401: inserted value too large for column
if I expand col1 to varchar2(30) then I won't have this problem. Does this means the length of USER is 30?
Can anyone confirm that the default size for USER is 30.
Thanks
MCL
-
Usernames can be from 1 to 30 characters long, size of col1 must be at least 30 and there is reason to make it larger.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|