 | |
#141
 
| |||
| |||
|
Re: 9iR2 exp -> 10g imp -
06-16-2008
, 05:16 PM
|
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(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/...-admins_1.html
#142
| |||
| |||
|
|
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. |
CHR(39)||'SURROUNDEDBYQU
------------------------
' surrounded by quotes '
HTH
-g
#143
| |||
| |||
|
|
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. |
CHR(39)||'SURROUNDEDBYQU
------------------------
' surrounded by quotes '
HTH
-g
#144
| |||
| |||
|
|
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. |
CHR(39)||'SURROUNDEDBYQU
------------------------
' surrounded by quotes '
HTH
-g
#145
| |||
| |||
|
|
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. |
CHR(39)||'SURROUNDEDBYQU
------------------------
' surrounded by quotes '
HTH
-g
#146
| |||
| |||
|
|
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. |
CHR(39)||'SURROUNDEDBYQU
------------------------
' surrounded by quotes '
HTH
-g
#147
| |||
| |||
|
|
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. |
CHR(39)||'SURROUNDEDBYQU
------------------------
' surrounded by quotes '
HTH
-g
#148
| |||
| |||
|
|
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. |
CHR(39)||'SURROUNDEDBYQU
------------------------
' surrounded by quotes '
HTH
-g
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.