Re: 9iR2 exp -> 10g imp

From: joel garry <>
Date: Mon, 16 Jun 2008 15:16:47 -0700 (PDT)
Message-ID: <>

On Jun 16, 2:04 pm, Arch <> 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.

Here's two 'obvious' ways:

SQL> select CHR(ASCII('''')) from dual;

SQL> select 'a'||''''||'b' from dual;



(those would be 4 single quotes).

Also it can be useful to have a NOT IN ('SYS','SYSTEM' etc laying
around to put into scripts.

-- is bogus.
Received on Mon Jun 16 2008 - 17:16:47 CDT

Original text of this message