Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.Original topic: flashback时，如何查询drop的表名
|
username: OnTheRoad
When performing a FLASHBACK recovery on a dropped table, if you forget the table name, how can you obtain the original table name?
This statement can only query the most recent 10 DDL statements. Drops before the 10th DDL cannot be queried.
I tried it, and it indeed works.
|
username: 
|
username: 
|
username: admin show ddl jobs 99999 where job_type='drop table';
You can check through the system table information_schema.ddl_jobs.
select db_name, table_name, job_type, table_id, start_time from information_schema.ddl_jobs;
Sorry, I can’t translate images. Please provide the text you need translated.
This stores all the DDL (drop) records. How can we determine which ones can be flashbacked?
Looking at the GC safepoint, I found that immediately increasing the GC retention time after dropping it might restore it, but it depends on luck.
The drop time needs to be greater than the safepoint time to ensure it has not been cleaned by the GC worker. In terms of the flashback feature, there is a significant gap compared to Oracle.
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.
|
username: 
|
username: