Month: March 2015
-
How to identify the ports used by a Windows process
If you have several services running on your Windows server you may need to check which ports they are using in order to prevent or resolve any conflicts. The first step is to obtain a list of the ports being used, this can be carried out by opening a Command Prompt and executing netstat.exe andĀ the…
-
How to identify the Tablespace names from an EXPDP file
If you have been given a datapump dump file to import you may not have been given the export log file or a list of schemasĀ and tablespaces contained in that file. Fortunately all is not lost, datapump provides an option to create a text-based file containing the SQL DDL statements used to import the file…