Re: [OT] Lack of IEEE values in Oracle

Sorry, further to this, I meant:

    create TABLE "niall.litchfield" (etc.)

not:

    create USER "niall.litchfield" (etc.)

TC

TC <no_at_email.please> wrote in article
<01c165e8$13a6c880$0f8850d2_at_pentium>...
>
>
> Niall Litchfield <n-litchfield_at_audit-commission.gov.uk> wrote in article
> <3be66055$0$8514$ed9e5944_at_reading.news.pipex.net>...
>
> >> "Oracle allows you to create a user name with a "." (dot) in it"
> >
> > SQL> create user niall.litchfield identified by test;
> > create user niall.litchfield identified by test
> > *
> > ERROR at line 1:
> > ORA-01936: cannot specify owner when creating users or roles
>
>
> You're assuming that by "user name", he meant "object owner". I think he
> meant "an object name assigned by the user". With that definition, you
> *can* create a user name containing a dot:
>
> create user "niall.litchfield" (etc.)
>
>
> TC
>
>
Received on Mon Nov 05 2001 - 04:57:40 CST