Pavan DBA's Blog

The DBA Knowledge Store

New Oracle 11g RAC batch in DBATALENT

Posted by Pavan DBA on October 18, 2014


RAC batch

 

ORACLE RAC 11g NEW BATCH !!!

Attend First 2 days as a demo by the Trainer Vishnu Pavan (Oracle RAC certified Expert)

Meeting link : https://global.gotomeeting.com/join/938441877

Training Details:
– Start Date: 20th Oct 2014
– Duration: 20 days
– Timings: 7am – 8:30am IST
– Mode: Online Training

Other Details:
– Fees: Rs 15,000
– Training material provided

For more details, write to: corporate@dbatalent.com
Contact Us: 040-40036087

Posted in Training | Leave a Comment »

How to resolve ORA-01400 during import(imp) in 11g database

Posted by Pavan DBA on July 12, 2014


Posting after long time…

Recently I am performing a refresh activity using export/import. Donno the reason, but DBA who handled this database in the past configured traditional export (exp) backup on 11.2.0.3 database.

I got a request to import that dump into UAT database which I started performing using imp utility.

For some of the tables, i received ORA-01400 error and detailed message will be as below

. . importing table “TEST”
IMP-00019: row rejected due to ORACLE error 1400
IMP-00003: ORACLE error 1400 encountered
ORA-01400: cannot insert NULL into (“ABC”.”TEST”.”C1″)
Column : 1
Column :

Note that schema, table and column names are changed for security reasons.

Immediately I verified the column C1 in TEST table and observed that it is defined as NOT NULL. Intially, I thought this might be the reason for the error that Oracle is trying to insert NULL value. I checked in the production database and found that there is no NULL values at all in C1 column which means the table structure, data everything is perfect.

After referring to MOS doc 826746.1, got to know that this is a known issue when you take export with exp command from 11gR1 onwards using DIRECT=Y option.

This is because there is behaviour change in exp utility. Prior to 11gR1 when you take export (exp) with DIRECT=Y, if a NULL value is there in column, Oracle used to replace that with default value what it will have in COL$ table. But, from 11gR1 onwards, the value is not replaced by its default but the NULL values is stored in export dump. This will produce ORA-1400 during import.

The solution for this problem is simple…. take the export in conventinal path only i.e don’t use DIRECT=Y or use datapump for your activity.

Even though it seems to be a problem, Oracle has not opened any bug on this because exp utility is desupported from 11g onwards and Oracle recommends to use datapump only.

Finally, i temporarily fixed the issue by taking TEST table export in expdp. Also, changed the daily export backup method from exp to expdp in the production database.

Hope this helps for some people….

Posted in export/import/Datapump | Tagged: , , , , , , , , , , | 2 Comments »

Purchase your own Oracle cloud server @ DBATALENT

Posted by Pavan DBA on June 29, 2014


Now purchase your own personal Oracle cloud server at half the price and practice anytime, anywhere

Oracle Database 11g, 12c Server: Rs 2000
Oracle RAC 2 Node 11g Server: Rs 4000
Oracle Apps R12 Server: Rs 4500
Oracle Apps R12.2 Server: Rs 9,000

Corporate@dbatalent.com

oraservers

Posted in Training | 4 Comments »

Golden chance to listen to Oracle Experts in Dubai and UAE

Posted by Pavan DBA on May 21, 2014


Friends, a golden chance to people to listen to so many interesting sessions from Oracle Industry Experts like Oracle ACE, ACE Directors etc. It’s a Great opportunity to meet the Oracle experts, Meet Top Executives, Network with Other Senior DBAs, Database Managers in Dubai..

Event organized across UAE. You can attend physically or virtually by registering at http://otnmenatour.org/

For Dubai location see here – http://www.araboug.org/ib/index.php?app=nexus&module=payments&section=store&do=item&id=24

MENA OTN

Posted in General | Leave a Comment »

My New Oracle DBA batch from 21st April

Posted by Pavan DBA on April 16, 2014


Friends, there is a change in the batch timings. Initially we planned for 8:30 to 10 PM IST. But, after 1st demo so many people are interested in attending morning session. so, we have changed the timings. New timings would be 6:30 to 8 AM IST.

Faculty: Pavan Dba
Demo 1: 18/04/0214 at 8:30 PM IST
Demo 2 : 21/04/2014 at 6:30 AM IST
Start Date: 21/04/2014
Timings:06:30AM – 08:00AM IST
Duration: 30 days

Demo Link:https://global.gotomeeting.com/meeting/join/156856405

Registration Link: http://dbatalent.com/index.php/store/product/46-oracle-dba-11g-12c
Coupon Code: DB@T@L3NT

Note: Early Bird Registrations will get 10% Discount.

For any further queries, Please get in touch with us:
Contact: 040-40036087, 8008500064
Email: contact@kannatechnologies.com

Pavan DBA Batch

Posted in Training | 12 Comments »

 
Follow

Get every new post delivered to your Inbox.

Join 2,438 other followers

%d bloggers like this: