Archive for the ‘Oracle’ Category
The Reason behind Oracle 11g: SEVERE: Error while registering Oracle JDBC Diagnosability MBean
Posted by: Chyne on: May 7, 2009
It seems there is a well-known bug for Oracle Database 11g release (Oracle 11.1.0.6.0) and it has been discussed in the Oracle forum post: SEVERE: Error while registering Oracle JDBC Diagnosability MBean
How do you know this error is related to Oracle 11g? If you are using the Oracle 11g Release 1 (11.1.0.6.0) JDBC driver (ojdbc6.jar), [...]
Table Conversion from Oracle to DB2
Posted by: Chyne on: August 5, 2008
- In: DB2| Oracle
- Leave a Comment
Oracle
Connect the Oracle database through Toad (Download from: http://www.toadsoft.com/, Toad for Oracle)
Save the result (data retrieval) based from the SQL statement in Fixed Field Spacing (Untick column headers, Tick ‘Include NULL text’)
• Save the result with the filename: testing.txt
DB2
Create a database
• Create a table
• Create the fields with the same attributes as the table in Oracle
Right click the [...]
Oracle Installation – Import Files
Posted by: Chyne on: July 30, 2008
Open the command line
Find the location of the database /.dmp file
> imp system/password@XE file=[filename].dmp fromuser=user1 touser=user2
Search
- The BASEDIR environment variable is not defined correctly. This environment variable is needed to run this program
- The Reason behind Oracle 11g: SEVERE: Error while registering Oracle JDBC Diagnosability MBean
- Why Windows Subsystem Process Terminated Unexpectedly?
- java.io.FileNotFoundException with (Permission Denied)
- Installation of Subversion 1.6.5 on Ubuntu 8.10
- Installation of Bugzilla in Ubuntu Environment
- 'Interface was expected' for JPEGImageEncoder
- SSL Certificate is not imported properly - 'unable to find valid certification path to requested target'
- How to Install Mantis in Ubuntu?
- Firefox ASSERT: *** Search: _installLocation: engine has no file!
- Polprav: Hello from Russia! Can I quote a post in your blog with the link to you?
- Alex: Huge Thanks! This bug has annoyed me for a long time.
- Donnieboy: Just wanted to drop you a line to say, I enjoy reading your site. I thought about starting a blog myself but don't have the time. Oh well maybe one
RSS - Posts