"EBA_DEMO_TREE_PROJ_FILES" 50.34 KB 4 rows sqlĮxpdp system /oracle directory =DATA_PUMP_DIR dumpfile =dmon. Impdp app /oracle directory =DATA_PUMP_DIR dumpfile =dmon. I know this is alot, but I haven't found anything close to my answers in the documentation or posts.Expdp app /oracle directory =DATA_PUMP_DIR dumpfile =dmon. O/S-Error: (OS 2) The system cannot find the file specified.ġ) In interactive mode, does a dummy file expdat.dmp have to exist in the DATA_PUMP_DIR directory?Ģ) does my export have to reside in the DATA_PUMP_DIR directory (again, no disk space to handle the DMP file), one of the hard drives is just big enough to handle the space but since it has datafiles there also, it would crash during import when trying to extend. ORA-31640: unable to open dump file "C:\oracle\product\10.2.0\admin\orcl\dpdump\ 6) when trying to run impdp interactively I get this error 4) I am able to write to the drive (hence the parfile existing there, and I am able to see the directory in windows explorer) 5) Our company does not have a Metalink account. Notes: 1) I get this also when removing the last slash in dba_directories 2) When trying with mapped drive P, instead of UNC, I get different OS error about not being able to read the file 3)I had to set the nologfile parameter because I was also having problems with writing the log file also. ORA-31640: unable to open dump file "\\server\share\folder\subfolder\expdp_1020.DMP" for read With the Partitioning, OLAP and Data Mining options All rights reserved.Ĭonnected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Produc SQL> select * from session_privs where privilege like '%DICT%' Īnd then when running import datapump with this command: SQL> select * from session_roles where role like '?TABASE' or role like 'DBA' I checked the grants and they seem to be fine I created a new directory called IMPDMP with the directory path (using UNC pathing) to \\server\share\folder\subfolder\ (our network mapped P drive, yes I included the backslash, but I have tried without it also). We received an expdp file from a client that is large enough that we had to copy it to a network drive (40GB). We have a QA database on a VM server with Windows 2003 operating system and oracle 10.2.0.1 installed along with limited disk space. I am new to data pump utilities, I haven't really found the answers on line or in the Oracle documentation so far.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |