2. obclient> create table t1(id bigint not null primary key, gmt_create datetime not null default current_timestamp);
    3. Query OK, 0 rows affected (0.09 sec)
    5. obclient> insert into t1(id) values(1),(2),(3);
    6. Query OK, 3 rows affected (0.02 sec)
    7. Records: 3  Duplicates: 0  Warnings: 0
    9. obclient> select * from t1;
    10. +----+---------------------+
    11. | ID | GMT_CREATE          |
    12. +----+---------------------+
    14. |  3 | 2020-02-28 09:47:07 |
    15. +----+---------------------+
    16. 3 rows in set (0.00 sec)
    18. obclient> drop table t1;
    19. Query OK, 0 rows affected (0.03 sec)
    21. obclient> show recyclebin;
    22. *************************** 1. row ***************************
    23.   OBJECT_NAME: __recycle_$_20200102_1585650066255592
    24. ORIGINAL_NAME: t1
    26. 1 row in set (0.03 sec)
    28. obclient> flashback table __recycle_$_20200102_1585650066255592 to before drop rename to t1;
    29. Query OK, 0 rows affected (0.02 sec)
    31. obclient> select * from t1;
    32. +----+---------------------+
    33. | ID | GMT_CREATE          |
    34. +----+---------------------+
    35. |  1 | 2020-02-28 09:47:07 |
    36. |  2 | 2020-02-28 09:47:07 |