Welcome to Paul Chuks Oracle dba Professional

Script to get the USER CREATION SCRIPT in the database: set escape on select 'create user ' || U.username || ' identified ' || DECODE(password, NULL, 'EXTERNALLY', ' by values ' || '''' || password || '''' ) || chr(10) || 'default tablespace ' || default_tablespace || chr(10) || 'temporary tablespace ' || temporary_Tablespace || chr(10) || ' profile ' || profile || chr(10) || 'quota ' || decode ( Q.max_bytes, -1, 'UNLIMITED', NULL, 'UNLIMITED', Q.max_bytes) || ' on ' || default_tablespace || decode (account_status,'LOCKED', ' account lock', 'EXPIRED', ' password expire', 'EXPIRED \& LOCKED', ' account lock password expire', null) ||';' "Create user scripts" from dba_users U, dba_ts_quotas Q where U.username = '<USERNAME>' and U.username=Q.username(+) and U.default_tablespace=Q.tables

exec dbms_job.broken( , FALSE); exec dbms_job.run( ); Example: exec dbms_job.broken(111033, FALSE); exec dbms_job.run(111033);

To set up your SQLPATH environmental variable. 1. From run cmd, type regedit and press enter. 2. Under SOFTWARE, expand it, then select ORACLE, expand it, select KEY_Oraclient10g_Home1. 3. On the right pane, double click the SQLPATH. 4. Then add the path for the location of your sql on the hard disk example . 5. And press enter or OK.