LightDB23.3新特性 Oracle模式支持spool输出日志

从23.3开始，LightDB Oracle模式支持Oracle spool 输入日志到系统文件，下面我们来看下

lightdb@postgres=# \c test test
Password for user test: 
You are now connected to database "test" as user "test".
compatible type: oracle
test@test=# spool objects.log
test@test=# select object_name,object_type from dba_tables;
ERROR:  column "object_name" does not exist
LINE 1: select object_name,object_type from dba_tables;
               ^
test@test=# select object_name,object_type from dba_objects;
test@test=# spool off;
test@test=# exit
复制

推出之后看下系统文件

$ more objects.log
                    object_name                     |    object_type     
----------------------------------------------------+--------------------
 PG_SHOW_PLANS                                      | VIEW
 DUAL                                               | VIEW
 UTL_FILE_DIR_DIRNAME_KEY                           | INDEX
 UTL_FILE_DIR                                       | TABLE
 DB_PIPES                                           | VIEW
 PG_STATISTIC                                       | TABLE
 PG_TYPE                                            | TABLE
 LT_STAT_ACTIVITY                                   | VIEW
 PG_STAT_STATEMENTS                                 | VIEW
 SAMPLE_ACTIVITY_HISTORY_ID_SEQ                     | SEQUENCE
 DUAL                                               | VIEW
 DBA_SEQUENCES                                      | VIEW
 ALL_SEQUENCES                                      | VIEW
 USER_SEQUENCES                                     | VIEW
 SAMPLE_ACTIVITY_PROFILE_ID_SEQ                     | SEQUENCE
 DBA_SYNONYMS                                       | VIEW
 ALL_SYNONYMS                                       | VIEW
 PG_FOREIGN_TABLE                                   | TABLE
 PG_AGGREGATE_FNOID_INDEX                           | INDEX
 PG_AM_NAME_INDEX                                   | INDEX
复制