oracle 表空间操作

EXECUTE DBMS_LOGMNR.ADD_LOGFILE('E:/oracle/oradata/J2YDTEST/REDO01.LOG',DBMS_LOGMNR.NEW); EXECUTE DBMS_LOGMNR.ADD_LOGFILE('E:/oracle/oradata/J2YDTEST/REDO02.LOG',DBMS_LOGMNR.ADDFILE); EXECUTE DBMS_LOGMNR.START_LOGMNR(DICTFILENAME=>'c:/dic.ora'); SELECT * FROM V$LOGMNR_CONTENTS ALTER DATABASE DROP LOGFILE GROUP 3 SELECT v$log.STATUS,V$LOGFILE.* FROM v$log,V$LOGFILE WHERE v$log.GROUP#=V$LOGFILE.GROUP# ALTER SYSTEM SWITCH LOGFILE; SELECT * FROM DBA_TABLESPACES SELECT * FROM V$TABLESPACE SELECT * FROM DBA_DATA_FILES SELECT * FROM V$DATAFILE SELECT * FROM DBA_TEMP_FILES SELECT * FROM V$TEMPFILE ALTER TABLESPACE INDEXES RENAME DATAFILE 'E:/oracle/oradata/J2YDTEST/INDEXES1.ORA' TO 'D:/oracle_data/INDEXES1.ORA' DROP TABLESPACE xdb INCLUDING CONTENTS CASCADE CONSTRAINTS