GS_RECYCLEBIN

GS_RECYCLEBIN describes details about objects in the recycle bin of the flashback feature.

**Table 1** GS_RECYCLEBIN columns
Name	Type	Description
oid	oid	System column
rcybaseid	oid	Base table object ID, which references gs_recyclebin.oid
rcydbid	oid	OID of the database to which the current object belongs
rcyrelid	oid	OID of the current object
rcyname	name	Name of the object in the recycle bin. The format is BIN$unique_id$oid$0. unique_id indicates the unique identifier with a maximum of 16 characters, and oid indicates the OID.
rcyoriginname	name	Original object name
rcyoperation	char	Operation type. The options are as follows: d: drop t: truncate
rcytype	integer	Object type. The options are as follows: 0: table 1: index 2: TOAST table 3: TOAST index 4: sequence, indicating the sequence object that is automatically associated with the serial, bigserial, smallserial, and largeserial types. 5: partition 6: global index. 7: materialized view.
rcyrecyclecsn	bigint	CSN when an object is dropped or truncated
rcyrecycletime	timestamp with time zone	Time when an object is dropped or truncated
rcycreatecsn	bigint	CSN when an object is created
rcychangecsn	bigint	SCN when an object definition is modified
rcynamespace	oid	OID of the namespace that contains this relationship
rcyowner	oid	Owner of the relationship
rcytablespace	oid	Tablespace in which this relationship is stored. If the value is 0, the default tablespace of the database is used. This column is meaningless if the relationship has no on-disk file.
rcyrelfilenode	oid	File name of the recycle bin object on a disk, or 0 if none, which is used to restore the physical file when the TRUNCATE object is restored.
rcycanrestore	Boolean	Specifies whether flashback can be performed separately.
rcycanpurge	Boolean	Specifies whether the purge operation can be performed independently.
rcyfrozenxid	xid32	All transaction IDs before this one have been replaced with a permanent ("frozen") transaction ID in the table.
rcyfrozenxid64	xid	All transaction IDs before this one have been replaced with a permanent ("frozen") transaction ID in the table.