This is my first time to actually performed data pump so please bear with me. Linux-x8664 Error: 2: No such file or directory. ORA-31640: unable to open dump file 'EXPORT.dmp' for read.I saw some discussion related to the ora errors I encountered and some of them are saying "typically exp is higher version than imp", I am now planning to upgrade my oracle software on windows. DataPump import fails with the following errors: ORA-39001: invalid argument value. Is there a way/ option in expdp where the dump file will be automatically zipped when its been created. ORA-31619: invalid dump file "C:\P7DB\fpac052912_dp01.dmp" Hi All, i am using expdp to create a dump file of contents from an oracle table. impdp dumpfile=dp:fpac052912_dp%U.dmp logfile=dp:fpac052912_impdp.log full=y I created a database named p7db, then create and run a script for tablespaces (based on the fpac2 database).Ģ.4 grant read, write on directory dp to public ģ. On my Windows machine (Oracle 10.1.0.2 Windows 32bit): Then I copy those dump files to my external hdd and paste it on the other machine that is not connected in the network. After that I use fireFTP to copy those dump files to my Windows machine. expdp full=y dumpfile=dp:fpac052912_dp%U.dmp logfile=dp:fpac052912_expdp.log job_name=full_exp I have a database named fpac2, then I performed the following:Ĥ.4 grant read, write on directory dp to public ĥ. On the AIX Machine (Oracle 10.2.0.5 AIX 64bit): How can I be sure that it was in binary mode? The directory is located in the database serverģ. When attempting to import the dump files using impdp in WIN02: DOS>impdp DIRECTORY=WINDUMP_DIR DUMPFILE=expdp.1/ The directory must be located in the database serverĢ/ Do not tell what you did and saw: SHOW US.ģ/ Are you sure you did your ftp in BINARY mode?ġ.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |