![]() 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 '%DATABASE' 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 |