Non-system schema Exports in Oracle 9i

Shell Script:

oracle on Server-Name:/admin/home/oracle> cat non_system_schemas.sh

# /bin/ksh

exp userid=\'/ as sysdba\' parfile=/admin/home/oracle/non_system_schemas.par

PAR file:

oracle on Server-Name:/admin/home/oracle> cat non_system_schemas.par

file=/backup2/non_system_schemas.dmp log=/backup2/non_system_schemas.log owner=schema1,

schema2,

schema3,

schema4,

schema5,

schema6,

schema7,

schema8,

schema9,

schema10

Shell script Execution:

oracle on Server-Name:/admin/home/oracle>nohup /admin/home/oracle/non_system_schemas.sh &

[1]     7410

oracle on Server-Name:/admin/home/oracle>Sending output to nohup.out

oracle on Server-Name:/admin/home/oracle>jobs

[1] +  Running                 nohup /admin/home/oracle/non_system_schemas.sh &

oracle on Server-Name:/backup2>jobs

'[1] +  Running                 nohup /admin/home/oracle/non_system_schemas.sh &

Export terminated successfully without warnings.

^C[1] +  Done                    nohup /admin/home/oracle/non_system_schemas.sh &

List of system's schemas

SQL> select username,created from dba_users where USERNAME IN ('SYS','SYSTEM','OUTLN','ANONYMOUS','CTXSYS','DBSNMP','LBACSYS','MDSYS','OLAPSYS','ORDPLUGINS','ORDSYS','OUTLN','SCOTT','WKSYS','WMSYS','XDB');

USERNAME                       CREATED

------------------------------ ---------

DBSNMP                         12-JUN-04

OUTLN                          30-JUL-99

SYSTEM                         30-JUL-99

SYS                            30-JUL-99