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!
"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 Received on Tue May 01 2001 - 12:04:20 CDT