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