TS_PITR_OBJECTS_TO_BE_DROPPED lists all objects lost as a result of performing tablespace point-in-time recovery. This view applies only to the tablespace point-in-time recovery feature.
| Column | Datatype | NULL | Description |
| OWNER | VARCHAR2(30) | NOT NULL | The owner of the object |
| NAME | VARCHAR2(30) | NOT NULL | The name of the object that will be lost as a result of undergoing tablespace point-in-time recovery |
| CREATION_TIME | DATE | NOT NULL | Creation timestamp of the object |
| TABLESPACE_NAME | VARCHAR2(30) | | Name of the tablespace containing the object |
Note:
1. select * from sys.TS_PITR_OBJECTS_TO_BE_DROPPED;
| OWNER | NAME | CREATION_TIME | TABLESPACE_NAME |
| SYS | I_IND1 | 2004-03-06 4:32:12 PM | SYSTEM |
| SYS | I_COBJ# | 2004-03-06 4:32:12 PM | SYSTEM |
| SYS | I_OBJ1 | 2004-03-06 4:32:12 PM | SYSTEM |
| SYS | I_PROXY_ROLE_DATA$_2 | 2004-03-06 4:32:12 PM | SYSTEM |
| SYS | C_FILE#_BLOCK# | 2004-03-06 4:32:12 PM | SYSTEM |
| SYS | C_OBJ# | 2004-03-06 4:32:12 PM | SYSTEM |
No comments:
Post a Comment