SQL> select COUNT(*) from dba_objects where created< to_date('17-01-14','dd-mm-y
y') AND owner='用户名' and object_type='TABLE';
==============================================================
查询某个时间之后创建的表有哪些:
SQL> select object_name,created from dba_objects where created> to_date('17-01-1
4','dd-mm-yy') AND owner='用户名';
================================================
查询当前用户下某个表的创建时间:
SQL> select object_name,created from dba_objects where object_name ='DN_EMPLOYEE
' AND owner='用户名';
==============================================
连接oracle并执行文件,并将执行结果保存到log文件中:
C:\Users\admin>sqlplus用户名/密码@ORCL @D:\aaa.sql > d:\sqlout.log;
==============================================
执行bat文件完成上面的任务:
@echo off
sqlplus %connection% @D:\data_carryover\select_table.sql > D:\data_carryover\select_table_log.log
@echo Create End!
pause
将以上代码保存到bat类型的文件中,并执行
================================
注意:用oracle数据库创建的用户名替换上面内容中的‘用户名’三个字,密码同理。