The database user has been deleted, and the tablespace and data files are all there. How can this problem be recovered?

The database user is deleted, and the tablespace and data files are all there. How to restore the environment: www.2cto.com [html] SQL> select * from v $ version where rownum = 1; BANNER ---------------------------------------------------------------- Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Prod SQL>! Uname-a Linux think-V30SA 2.6.35-22-generic # 33-Ubuntu SMP Sun Sep 19 20:34:50 UTC 2010
I686 GNU/Linux www.2cto.com
Http://www.bkjia.com/database/201209/154083.html

The simulated experiment process is as follows: [SQL] SQL> show user USER user is "SYS" SQL> select flashback_on from v $ database; FLASHBACK_ON ---------------- yes SQL> create user u1 identified by u1 default tablespace users quota 10 m on users;
-- Create u1 User created. SQL> grant connect, create any table to u1; Grant succeeded. SQL> conn u1/u1 Connected. SQL> create table test (I int); Table created. SQL> insert into test values (1); 1 row created. SQL> insert into test values (2); 1 row created. SQL> commit; Commit complete. SQL> select * from test; I ---------- 1 2 SQL> conn/as sysdba Connected. SQL> drop user u1 cascade; -- u 1. Delete the associated object. User dropped. SQL> shutdown immediate SQL> startup mount SQL> flashback database to timestamp sysdate-9/1440; Flashback complete. SQL> alter database open resetlogs; Database altered. SQL> select * from u1.test; I ---------- 1 2 conclusion: the key to the entire simulation experiment is the time difference between creating u1 and deleting u1. The timestamp specified by flashback database
To fall between them, otherwise the experiment will fail.