INSTALLATION DOCUMENTS BY RAVI

Saturday, April 15, 2017

SQL query for finding the schema name of the tabale

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';

No comments:

Post a Comment

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...