Shulou(Shulou.com)06/01 Report--

Tablespace offline

SQL > alter tablespace rcat offile

two。 Delete user

SQL > drop user ractowner cascade

3. Delete tablespaces and data files

DROP TABLESPACE rcat INCLUDING CONTENTS AND DATAFILES

4. Use RMAN to see if the .dbf file still exists.

RMAN > report schema

Report of database schema for database with db_unique_name ORCL

List of Permanent Datafiles

= =

File Size (MB) Tablespace RB segs Datafile Name

1 720 SYSTEM * * + DATA/orcl/datafile/system.256.894905947

2 610 SYSAUX * * + DATA/orcl/datafile/sysaux.257.894905947

3 110 UNDOTBS1 * * + DATA/orcl/datafile/undotbs1.258.894905947

4 5 USERS * * + DATA/orcl/datafile/users.259.894905947

5 345 EXAMPLE * * + DATA/orcl/datafile/example.265.894906137

List of Temporary Files

=

File Size (MB) Tablespace Maxsize (MB) Tempfile Name

-

1 29 TEMP 32767 + DATA/orcl/tempfile/temp.264.894906125

RMAN >

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.