today:
64,284
yesterday:
36,263
Total:
9,691,780

Oracle APEX SQL

General EXPORT & IMPORT

admin 2016.05.01 05:24 Views : 1391

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
32 Display Value, Return Value admin 2016.05.10 1198
31 Fundamentals of PL/SQL admin 2016.05.10 3335
30 Interactive Report admin 2016.05.07 1145
29 Group by, Order by (두개의 Table을 활용한 Sub Total / 최고값 ) admin 2016.05.06 1392
28 EMPLOYEE_LEVEL_ID admin 2016.05.03 1144
27 HEAD TITLE (제목)을 조건에 따라 바꾸기 admin 2016.05.03 1224
26 APEX ADMIN PASSWORD 바꾸기 admin 2016.05.02 1040
25 wwv_flow_files admin 2016.05.01 1232
» EXPORT & IMPORT admin 2016.05.01 1391
23 Outer Join with Oracle SQL admin 2016.04.29 1270
22 Report by Order / Product / Order and Product / By Order & Non Order admin 2016.04.29 1391
21 Delimiter admin 2016.04.29 1249
20 SQL SELECT DISTINCT Statement admin 2016.04.29 1474
19 TAP ( Main & Sub ) / Button 의 Switch admin 2016.04.28 1268
18 COUNT admin 2016.04.28 1260
17 CREATING A TABLE / SEQUENCE / TRIGGER admin 2016.04.28 1269
16 CREATE (INSERT) PROCESS admin 2016.04.28 1266
15 DELETE PROCESS admin 2016.04.28 1275
14 Global & Custom Serach file admin 2016.04.28 1454
13 INSERT PROCESS admin 2016.04.28 1276