使用Linux文件句柄恢复Oracle数据文件(三)
LE# STATUS NAME
---------- ------- -------------------------------------------------
1 SYSTEM /u01/app/oracle/oradata/ZWC/system01.dbf
2 ONLINE /u01/app/oracle/oradata/ZWC/sysaux01.dbf
3 ONLINE /u01/app/oracle/oradata/ZWC/undotbs01.dbf
4 ONLINE /new_oradata/users01.dbf
5 ONLINE /new_oradata/example01.dbf
SQL> create user zhongwc identified by zhongwcpwd default tablespace users;
User created.
SQL> grant dba to zhongwc;
Grant succeeded.
SQL> conn zhongwc@zwc
Enter password:
Connected.
SQL> create table t_test tablespace users as select * from dba_objects;
Table created.
SQL> select count(*) from t_test;
COUNT(*)
----------
75203