Monthly Archives: March 2011

ASM database not starting automatically after server reboot

As we all know that in unix, we have different runlevels and every runlevel have certain demons to be started and stopped. We can check the demons in each runlevel by going to directory /etc/rc.d/rc[0-6] or /etc/init.d (or some platform … Continue reading

Posted in Oracle Automatic Storage Management, Oracle Cluster Ready Services | Tagged | 4 Comments

EXP-00056: ORACLE error 1555 encountered

While using the conventional export (exp) utility for exporting the table, following error was seen. . . exporting table         XXXXXXXXXXXXXXXXXXXXXX      14780 rows exported . . exporting table                          XXXXX     589614 rows exported Table XXXXXXXXXX will be exported in conventional path. . … Continue reading

Posted in Oracle EXP/IMP | Tagged , , | Leave a comment

Oracle external table preprocessors

How to use external table preprocessors to unzip files on-the-fly We are using external tables for reading the text files. Now instead of ASCII files, if we may get compressed files as input. Here we have two options to handle … Continue reading

Posted in Oracle 11g Enhancements, Oracle External Tables | Tagged , | Leave a comment

Convert non-partition table to partition table using Oracle redefinition

Goals To convert the non-partition table to partition table No/minimal application downtime Dependent objects should also get created Option to convert current non-primary key global index to local indexes I’ve used scott schema to redefine a table. Scott will need … Continue reading

Posted in Oracle Availability | Tagged | Leave a comment