Skip to main content

SQL

 All tables in Oracle database that were created within the last 60 days

Ref: https://dataedo.com/kb/query/oracle/find-recently-created-tables


select owner as schema_name, object_name as table_name, created from sys.dba_objects where object_type = 'TABLE' -- excluding some Oracle maintained schemas and owner not in ('ANONYMOUS','CTXSYS','DBSNMP','EXFSYS', 'LBACSYS', 'MDSYS', 'MGMT_VIEW','OLAPSYS','OWBSYS','ORDPLUGINS', 'ORDSYS','OUTLN', 'SI_INFORMTN_SCHEMA','SYS','SYSMAN','SYSTEM', 'TSMSYS','WK_TEST','WKSYS', 'WKPROXY','WMSYS','XDB','APEX_040000', 'APEX_PUBLIC_USER','DIP', 'FLOWS_30000','FLOWS_FILES','MDDATA', 'ORACLE_OCM', 'XS$NULL', 'SPATIAL_CSW_ADMIN_USR', 'SPATIAL_WFS_ADMIN_USR', 'PUBLIC') and created > sysdate - 60 order by created desc, owner, object_name;

Comments

Post a Comment

Popular posts from this blog

Oracle Fusion

  How to Create User and add roles in Fusion  with Basic Roles After adding roles run Retrieve Latest ldap changes is the process available in the Oracle cloud to sync User Account information's should be sync with the Oracle application from LDAP directory    :Retrieve Latest LDAP Changes process"    You can perform the task Run User and Roles Synchronization Process from either an implementation project or the Setup and Maintenance work area.
Post a Comment
Read more

OIC

 
Post a Comment
Read more

1& 2 - Introduction to Fusion Cloud and Course Content

  Front End Pages were developed using JET Framework. Backend access won't be available we have to use BI server FRS/Smart view - Essbase OTBI - Subject Area BIP - Select tables In Fusion Cloud applications you cannot create the process all together from the beginning and you cannot modify the the workflow process also so what you can do you can configure the approval rules you can configure the approval so that means who can approve who has to take the action who has to be notified so all those approval rules . If process is not there you cannot do anything 
Post a Comment
Read more