today:
39
yesterday:
158
Total:
1,001,293

General EXPORT & IMPORT

admin 2016.05.01 05:24 Views : 166

c:windowssystem32>


imp file=c:haiwork_0410.dmp fromuser=haiwork touser=jongwork ignore=y commit=y


exp file=c:haiwork_0410.dmp owner=haiwork compress =y


========================================================

When I do a backup in 9i using the Export facility i get the following error:


Export file: EXPDAT.DMP>

Exp-00028:failed to open EXPDAT.DMP for write.


How do i write to the dump file?

Reply With QuoteReply With Quote   

12-12-2002, 06:29 PM#2stecal's Avatarstecal stecal is offline

Senior Advisor

Join Date

May 2002

Posts

2,645

Do you have write permission in the directory where you are sending the dump file?

No. Subject Author Date Views
106 Delimiter admin 2016.04.29 133
105 Report by Order / Product / Order and Product / By Order & Non Order admin 2016.04.29 220
104 Outer Join with Oracle SQL admin 2016.04.29 147
» EXPORT & IMPORT admin 2016.05.01 166
102 wwv_flow_files admin 2016.05.01 147
101 APEX ADMIN PASSWORD 바꾸기 admin 2016.05.02 108
100 HEAD TITLE (제목)을 조건에 따라 바꾸기 admin 2016.05.03 132
99 EMPLOYEE_LEVEL_ID admin 2016.05.03 88
98 Group by, Order by (두개의 Table을 활용한 Sub Total / 최고값 ) admin 2016.05.06 219
97 Interactive Report admin 2016.05.07 116
96 Fundamentals of PL/SQL admin 2016.05.10 2031
95 Display Value, Return Value admin 2016.05.10 115
94 BOOLEAN SAMPLE admin 2016.05.11 144
93 test admin 2016.05.11 121
92 CREATE VIEW admin 2016.05.13 218
91 3D Pie Chart admin 2016.05.17 214
90 TREE admin 2016.05.18 722
89 INSTR admin 2016.05.19 785
88 NVL admin 2016.05.19 151
87 ROWNUM admin 2016.05.19 240