‘database’ Archives
Recreating Database Link
I was trying to recreate database links as part of database migration activity. This involved mixture of 8i,9i and 10g database. In case of 8i/9i it is very easy to find the old password which was used to create database link as passwords for database links are stored in [Read More]
Database Security: Transparent Data Encryption
Data in the database is secured by using authentication, authorization and auditing mechanism, but the information stored in the datafiles can be read using any hex-editor tools or other OS level utilities, which is causing threat to sensitive data. To overcome this [Read More]
Changes To 10g OCA Certification
People planning to appear for 10g OCA Exam will be startled to find that they need to pass additional exam to get the certificate. Starting from December 1, 2008, in addition to the existing exam (Oracle Database 10g: Administration I (1Z0-042)), candidates are also [Read More]
How To Change/Restore User Password in 11G
Oracle 11g introduces Case-sensitive passwords for database authentication. Along with this if you wish to change the password (temporarily) and reset it back to old , you will find that password field in dba_users is empty. Prior to 11g we could use following technique to [Read More]
Tom Kyte Seminar in Bangalore, India
All India Oracle user Group (AIOUG) has arranged for Seminar by Tom Kyte on 18th December 2008. Venue- The Good Shepherd Auditorium Residency Road- Museum Road Junction Opp. St. Joseph’s P.U. College Bangalore – 560 025 SEMINAR TOPICS Storage Techniques [Read More]
Full Database Export Failing With ORA-00980
While trying to do a full export for 10.2.0.3 database, we were getting following errors About to export the entire database ... . exporting tablespace definitions . exporting profiles . exporting user definitions . exporting roles . exporting resource costs . exporting [Read More]
