Re: 9iR2 exp -> 10g imp
From: gazzag <gareth_at_jamms.org>
Date: Tue, 17 Jun 2008 03:05:30 -0700 (PDT)
Message-ID: <08eb5718-b65a-4677-9cf0-ee983a37cf49@p25g2000hsf.googlegroups.com>
' surrounded by quotes '
Date: Tue, 17 Jun 2008 03:05:30 -0700 (PDT)
Message-ID: <08eb5718-b65a-4677-9cf0-ee983a37cf49@p25g2000hsf.googlegroups.com>
On 16 Jun, 22:04, Arch <send..._at_spam.net> wrote:
> Spooling a select from dba_users proved to be far and away the best
> way to create a script to create the users. I manually edited out the
> various "built in" accounts (sys, system, etc). The script included
> passwords, profiles and tablepaces. I couldn't figure out how to
> embed a literal quote character (') into the spool output, so I used
> _Q_, then a single global replace with an editor fixed the file.
SQL> select chr(39)||' surrounded by quotes '||chr(39) from dual;
CHR(39)||'SURROUNDEDBYQU
' surrounded by quotes '
HTH -g Received on Tue Jun 17 2008 - 05:05:30 CDT