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:tetu9jeg6i2de0_at_beta-news.demon.nl...
>
> "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
>

Ah HA! It just dawn on me the whole reason of the 3 quotes! B/C you need to use 2 quotes to surround the actual ' in order for it to appear in the code.... Don't know why it take this long!

Thanks again everyone

Sunny Received on Tue May 01 2001 - 14:30:47 CDT