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

  Opatch reports 'Cyclic Dependency Detected' error when patching ODI   Issue: When applying a Patch Set Update (PSU) to WebLogic Se...