Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: EXPORT/IMPORT Problem - Can't get user imported into new DB... <-- GOT IT, THANK YOU EVERYONE!
"Sunny Yu" <sunny_at_medservintl.com> wrote in message
news:tetqpumsbgnga5_at_corp.supernews.com...
>
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> news:tet588jnlt5kdd_at_beta-news.demon.nl...
>
> > select 'create user '||username||' identified by values
'''||password||'''
> > default tablespace '||default_tablespace||' temporary tablespace
> > '||temporary_tablespace||';'
> > from dba_users
>
>
> Ah HA! Thanks Mr. Bakker, your select statement did the trick! Never
> thought of putting 3 single qoute around the ||password||. Thanks again.
>
> Sunny
>
>
Just a small explanation to make sure you understand what's happening
the statement is
... identified by values '<password>'
The <password> comes from the column and to use a quote in a string you need
to escape it with another quote.
That's why there are 3 quotes in my statement.
Regards,
Sybrand Bakker, Oracle DBA Received on Tue May 01 2001 - 13:00:19 CDT