Re: 9iR2 exp -> 10g imp
From: joel garry <joel-garry_at_home.com>
Date: Mon, 16 Jun 2008 15:16:47 -0700 (PDT)
Message-ID: <994f9e8f-bd73-47e9-ae45-1146cb865975@a32g2000prf.googlegroups.com>
Date: Mon, 16 Jun 2008 15:16:47 -0700 (PDT)
Message-ID: <994f9e8f-bd73-47e9-ae45-1146cb865975@a32g2000prf.googlegroups.com>
On Jun 16, 2:04 pm, 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.
>
Here's two 'obvious' ways:
SQL> select CHR(ASCII('''')) from dual;
C
-
'
SQL> select 'a'||''''||'b' from dual;
'A'
--- a'b (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. jg -- @home.com is bogus. http://www.infoworld.com/article/08/06/16/25FE-stupid-users-part-3-admins_1.htmlReceived on Mon Jun 16 2008 - 17:16:47 CDT