Oracle impdp command ORA-39145, ORA-31655, ORA-39154

While using the Oracle 11g impdp command there are few precursors that need to be taken care:

1. impdp is a OS command and hence need to be executed from command prompt and not SQL Plus. For using it within SQL Plus,you got to use the following command: host impdp

2. Prerequisite steps:

a. First create the directory within SQL Plus :
create or replace directory importTestDB as 'c:\importTestDB';

If there is an issue with this directory, you may receive the following error:
ORA-39145: directory object parameter must be specified and non-null

b. Grant the permissions to user for this directory:
grant read,write on DIRECTORY importTestDB to user1;


c. Grant the permission to import full database to the user:
 grant imp_full_database to user1;

Failing which you may receive the following error:
ORA-31655: no data or metadata objects selected for job
ORA-39154: Objects from foreign schemas have been removed from import

3. Execute the following command from command prompt:

impdp user1/pass@orcl directory=importTestDB full=y dumpfile=TestDBDump11092012.dmp logfile=log.txt;

if you see the following text after the above command starts execution, then you have successfully met all the prerequisities to import a Oracle database :


Connected to: Oracle Database 11g Release 11.2.0.1.0 - Production
Master table "user1"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "user1"."SYS_IMPORT_FULL_01":  user1/********@orcl directory=importTestDB full=y dumpfile=TestDBDump11092012.dmp logfile=log
txt;
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA


Please check the log file especially the last few lines to see if import was successfully completed or not.

 

Comments

Post a Comment

Popular posts from this blog

Tomcat 6 error on startup: Commons Daemon procrun stdout initializedError occurred during initialization of VM

I noticed the following exception in Tomcat logs: Commons Daemon procrun stdout initializedError occurred during initialization of VMjava/lang/NoClassDefFoundError: java/lang/Object Resolution: Go to C:\Program Files\Apache Software Foundation\Tomcat 6.0\bin and double click on tomcat6w.exe. This will open the Tomcat 6 properties. Go to Java tab and check the path for jvm.dll under Java Vitual machine textbox. This should be under the same JRE that is used for all other purposes like keystore, JAVA_HOME, etc. This fix should resolve the problem.
Read more

Setting property 'keystoreFile' did not find a matching property. No Certificate file specified or invalid file format

I encountered this weird exception on X server even after configuring the Tomcat  configuration file properly same as i did for other server  Y where it is working fine. Solution is mentioned after the exception log: May 24, 2011 5:23:45 PM org.apache.catalina.startup.SetAllPropertiesRule begin WARNING: [SetAllPropertiesRule]{Server/Service/Connector} Setting property 'keystoreFile' to 'C:\Program Files\Java\jdk1.6.0_25\keystore\.keystore' did not find a matching property. May 24, 2011 5:23:45 PM org.apache.catalina.startup.SetAllPropertiesRule begin WARNING: [SetAllPropertiesRule]{Server/Service/Connector} Setting property 'keystorePass' to 'changeit' did not find a matching property. May 24, 2011 5:23:45 PM org.apache.catalina.startup.SetAllPropertiesRule begin WARNING: [SetAllPropertiesRule]{Server/Service/Connector} Setting property 'clientAuth' to 'false' did not find a matching property. May 24, 2011 5:23:46 PM org.apache.coyote.h...
Read more

Query execution failed for dataset (rsErrorExecutingCommand) / SELECT permission was denied on the object

Image
After resolving the permissions issue for 'NT AUTHORITY\NETWORK SERVICE'  i landed on the following error upon accessing the aspx page where i have a Microsoft.Reporting.Webforms.Reportviewer control embedded. An error has occurred during report processing. (rsProcessingAborted) Query execution failed for dataset 'dataset1'. (rsErrorExecutingCommand) For more information about this error navigate to the report server on the local server machine, or enable remote errors  To find out the exact error : 1. Navigate to C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__10_09_2012_17_05_27.log 2. Located the following error  Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'dataset1'. ---> System.Data.SqlClient.SqlException: ...
Read more