1. select owner, table_name from all_tables where table_name like 'EMP_NAME'; 2. select B.FILE_NAME from dba_segments a, dba_data_files b where a.header_file=b.file_ID and segment_name='EMP_NAME';
Subscribe to:
Post Comments (Atom)
SQL query to find whether OdiSendMail is configured or not ODI 12c
In the SQL developer connect to the ODI work repository user (Ex: DEV_ODI_REPO) and run the below query. select SCEN_NAME,TASK_NAME3,DE...
-
Getting the below error when installing oracle database 12c on linux machine Soft Limit: maximum stack size - This is a prerequisite con...
-
In general when we leave the database connection opened for a while in oracle sql developer, It will throw a "connection timeout"...
-
Please find the steps below to increase the performance of obiee 12c : 1. Tuning Hogging and Stuck Threads Hogging and stuck threads...
No comments:
Post a Comment