Oracle DB Version
You can check the version of the export utility by looking at a DMB file from Oracle 1234567/> strings BACKUP_101220.DMP | head -n 5 "SYS"."SYS_EXPORT_FULL_01" x86_64/Linux 2.4.xx USWMC WE8MSWIN1252 11.02.00.00.00
Deinstall Oracle 12c
Run the installer as an elevated user 1setup.exe -deinstall -home C:\app\oracle\product\12.1.0\dbhome_1
Oracle Managed Driver
1). Launch Visual Studio and install OMD – Click Tools > NuGet Package Manager > Package Manager Console – Type: Install-Package Oracle.ManagedDataAccess – Locate the dll Oracle.ManagedDataAccess.dll and copy it …
Error Installing Oracle 11.2.0.1
During the install, the error “OS error in starting service oraclemtsrecoveryservice” To resolve, edit registry key: [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ORACLE\Ora cleMTSRecoveryService\Protid_0] Edit the Host key and set to the machine name.
PL/SQL Determine Table Size
Original Source Link 1234567891011121314151617181920212223242526272829303132COLUMN TABLE_NAME FORMAT A32 COLUMN OBJECT_NAME FORMAT A32 COLUMN OWNER FORMAT A10 SELECT owner, table_name, TRUNC(sum(bytes)/1024/1024) Meg FROM (SELECT segment_name table_name, owner, bytes FROM dba_segments WHERE …
JDeveloper Change Java Location
To change the Java location that JDeveloper uses. 1). Locate the file E:\oracle\product\11.2.0\client32\sqldeveloper\sqldeveloper\bin\sqldeveloper.conf 2). Open the file in Notepad 3). Remove the line that starts with SetJavaHome 4). Save the …
Burleson Tribute
No other man’s picture detracts from concentrating on an Oracle issue more than this guy…
Determine Version of Oracle
1select * from v$version where banner like ‘Oracle%’;
Error Running Oracle Universal Installer 10.2.0.1
The error can occur when either installing or uninstalling (deinstalling) Oracle 10.2.0.1. To resolve the error: 1). Set the OUI exe to Windows XP SP3 mode (right click > properties) …
Oracle impdp ORA-00439: feature not enabled: Deferred Segment Creation
When getting the following error when using impdp: 1ORA-00439: feature not enabled: Deferred Segment Creation Alter the impdp syntax (add the version): 1impdp user/secret@ORACLE11G schemas=USERSCHEMA directory=export_dir dumpfile=export.dmp logfile=output.log version=10.2