DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: URGENT - USER as Default in CREATE TABLE

  1. #1
    Join Date
    Sep 2000
    Posts
    14

    Unhappy

    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


  2. #2
    Join Date
    Jul 2000
    Posts
    296
    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
  •  


Click Here to Expand Forum to Full Width