Page 1 of 1
Taking backup from Forms
Posted: Tue Oct 03, 2006 1:42 am
by tahir_mehmood
hi
how we take back from oracle froms form 6i without command prompt.
bye
Posted: Tue Oct 03, 2006 2:08 am
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;
Posted: Tue Oct 03, 2006 3:51 am
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
Posted: Tue Oct 03, 2006 7:10 am
by ahmadbilal
userid :- inventory
Pass :- inventory
owner=username for which u want ge export
Check is it same
Posted: Wed Oct 04, 2006 1:14 am
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