Taking backup from Forms

In this forum Oracle Applications DBA's, System Administrators & Developers can share their knowledge/issues.
Post Reply
tahir_mehmood
Posts: 26
Joined: Tue Oct 03, 2006 12:50 am
Location: Pakistan

Taking backup from Forms

Post by tahir_mehmood »

hi
how we take back from oracle froms form 6i without command prompt.
bye
ahmadbilal
Posts: 615
Joined: Mon Sep 18, 2006 1:32 am
Location: United Arab Emirates
Contact:

Post by ahmadbilal »

Write Following Code On The Button
When Button Pressed


declare
filename varchar2(20);

begin

filename := to_char(sysdate,'ddmmyyyy');


host('exp userid=system/MAPPER OWNER = QMSALE file=C:\QMSALE\BACKUP\'||filename||'.dmp');


end;
tahir_mehmood
Posts: 26
Joined: Tue Oct 03, 2006 12:50 am
Location: Pakistan

Post by tahir_mehmood »

Thank u very much sir,I tried this code but it make a file of 4kb only nothing more then that plz help me regarding this
bye
[quote]Write Following Code On The Button
When Button Pressed


declare
filename varchar2(20);

begin

filename := to_char(sysdate,'ddmmyyyy');


host('exp userid=system/MAPPER OWNER = QMSALE file=C:\QMSALE\BACKUP\'||filename||'.dmp');


end;


<i><div align="right">Originally posted by abmian1981
ahmadbilal
Posts: 615
Joined: Mon Sep 18, 2006 1:32 am
Location: United Arab Emirates
Contact:

Post by ahmadbilal »

userid :- inventory
Pass :- inventory

owner=username for which u want ge export

Check is it same
tahir_mehmood
Posts: 26
Joined: Tue Oct 03, 2006 12:50 am
Location: Pakistan

Post by tahir_mehmood »

Respected sir
Thank u very much for your help.
bye.
[quote]userid :- inventory
Pass :- inventory

owner=username for which u want ge export

Check is it same



<i><div align="right">Originally posted by abmian1981
Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests