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
|
rcytype
|
int
|
Object type
- 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.
|
rcyrecyclecsn
|
bigint
|
CSN when an object is dropped or truncated
|
rcyrecycletime
|
timestamptz
|
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
|
Relationship owner
|
rcytablespace
|
oid
|
Tablespace where the 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, used to restore the texture file when the TRUNCATE object is restored.
|
rcycanrestore
|
bool
|
Whether flashback can be performed separately
|
rcycanpurge
|
bool
|
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.
|