m15217321304的博客

set lin 2000 set long 20000 set pagesize 1000 select dbms_metadata.get_ddl('VIEW','DBA_ROLLBACK_SEGS','SYS') from dual CREATE OR REPLACE FORCE VIEW "SYS"."DBA_ROLLBACK_SEGS" ("SEGMENT_NAME", "OWNER", "TABLESPACE_NAME", "SEGMENT_ID", "FI LE_ID", "BLOCK_

这个问题是我模拟的故障，具体怎么出现的请参考链接 https://blog.youkuaiyun.com/m15217321304/article/details/105223487 --//查看数据库日志 Recovery of Online Redo Log: Thread 1 Group 3 Seq 24 Reading mem 0 Mem# 0: /u01/app/oradata/QXY1...

@session1 SQL> select *from a; ID ---------- 10 SQL> delete a; --//没有提交 1 row deleted. SQL> alter system flush buffer_cache; System altered. SQL> alter system ch...

--//数据库启动报ORA-00600 4185错误 SQL> startup ORACLE instance started. Total System Global Area 242208768 bytes Fixed Size 2227176 bytes Variable Size 184550424 bytes Data...

如果这种方式不行，请参考https://blog.youkuaiyun.com/m15217321304/article/details/105118977 SQL> select file_name, tablespace_name from dba_data_files; rows will be truncated FILE_NAME ----------------------------...

#####删除数据库文件########### col file_name for a50 select file_name, tablespace_name from dba_data_files FILE_NAME TABLESPACE_NAME --------------------------------...