Tag: datapump

ORA-01045: user SCOTT lacks CREATE SESSION privilege

ORA-01045: user SCOTT lacks CREATE SESSION privilege

November 7, 2010 | By | Add a Comment

Hi Friends, This is general error getting from Oracle 10g database. It calls as ORA-01045 that lacking of create session privilege. Reason of ORA-01045: From Oracle 10g, connect role doesn’t contain create session privilege. Solution of ORA-01045: If you granted connect role to any user and database was upgraded then you should need to give […]

Read More

How can perform Expdp with consistent=y

How can perform Expdp with consistent=y

October 22, 2010 | By | Add a Comment

Hi Friends, After introducing DATAPUMP, there are lot of confusion occurring. One of those confusion is how to perform export using EXPDP (datapump) like exp consistent=y. Because in export when we are using consistent=y, there would be very chance to get ORA-01555 snapshot too old error in live database. In 24*7 running database active DML […]

Read More