How to purge the Oracle Database 10 / 11 Recycle Bin [ID 572029.1]

		修改时间 21-OCT-2009 类型 HOWTO 状态 PUBLISHED

In this Document

  Solution

Applies to:

Oracle Agile Engineering Data Management - Version: 6.0.1 to 6.1.0
Information in this document applies to any platform.

Oracle 10.1

Oracle 10.2

Oracle 11.1

Goal

How to purge the Oracle Database 10 / 11 recycle bin ?

Solution

Use the new statement called PURGE - examples:

Purge single objects out of recycle bin

PURGE {TABLE | INDEX };

Purge all objects in recycle bin out of one tablespace. With the option USER it is possible to delete all objects in recycle bin out of one tablespace belonging to the USER

PURGE TABLESPACE [USER ] ;

Purge all objects out of recycle bin belonging to the current USER

PURGE RECYCLEBIN;

Purge all objects out of recycle bin / only for SYSDBA

PURGE dba_recyclebin;

ITPub博客

How to purge the Oracle Database Recycle Bin

Applies to:

Goal

Solution

最新文章