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

Loading xml file data to oracle table using python

Sample xml file (test.xml): <?xml version="1.0"?> <data>     <customer name="Ravi" >     ...