SQL> select sysdate from dual;
SQL> set time on;
SQL> select * from all_users;
SQL> select username from all_users where username='SCOTT';
SQL> drop user scott cascade;
SQL> select username from all_users where username='SCOTT';
SQL> shut immediate
SQL> startup mount
SQL> flashback database salgrade to timestamp to_timestamp('09-MAY-2013 18:23:45','dd-mm-yyyy hh24:mi:ss');
SQL> alter database open read only;
SQL> conn scott/tiger
scott> conn / as sysdba
SQL> shut immediate
SQL> startup mount
SQL> alter database open resetlogs;
