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

Perfect order of ODI export and import

  Smart Export / Import is the recommended way to achieve such a migration. This is the easiest way to make sure all the dependencies are ta...