así:
Código SQL:
Ver originalbash-3.2$ echo "CREATE USER prueba IDENTIFIED BY prueba;" | sqlplus myuser/mypassword@mysid
SQL*Plus: Release 10.2.0.1.0 - Production ON Vie Dic 3 09:23:06 2010
Copyright (c) 1982, 2005, Oracle. ALL rights reserved.
Conectado a:
Oracle DATABASE 10g Express Edition Release 10.2.0.1.0 - Production
SQL>
Usuario creado.
SQL> Desconectado de Oracle DATABASE 10g Express Edition Release 10.2.0.1.0 - Production
bash-3.2$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production ON Vie Dic 3 09:23:17 2010
Copyright (c) 1982, 2005, Oracle. ALL rights reserved.
Conectado a:
Oracle DATABASE 10g Express Edition Release 10.2.0.1.0 - Production
SQL> SELECT username FROM dba_users WHERE username LIKE 'PRUEBA';
USERNAME
------------------------------
PRUEBA
SQL>
o mira este tema
http://www.unix.com/shell-programmin...able-bash.html
saludos