OraFAQ Forum: Forms » generate different exp name

Home » Developer & Programmer » Forms » generate different exp name

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

generate different exp name [message #193266]

Fri, 15 September 2006 08:53

maoro
Messages: 312
Registered: May 2005

Senior Member

hello i have a form from which i export the schema that owns my application,
i just need something to generate a different export file name each time that exp is invoked from within the form,
i can use a sequence but is there a way to include the sysdate plus the timestamp in the export file name?
thanks

Report message to a moderator

Re: generate different exp name [message #193390 is a reply to message #193266]

Sat, 16 September 2006 02:22

maoro
Messages: 312
Registered: May 2005

Senior Member

hello
i guess user alter session set nls_date_format='dd-mm-yy hh24:mi:ss'
will do the job to generate different export file name each time export is invoked.
but how to use it inside a form ??
plz help
thanks

Report message to a moderator

Re: generate different exp name [message #193408 is a reply to message #193390]

Sat, 16 September 2006 06:13

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

What operating system do you use? If it is (one of) MS Windows versions, you might find a way call this DOS batch script; I'm not the author - I *think* I saved it from OraFAQ forum, but can't tell for sure. I apologize to the original author for not mentioning his/her name.

@echo off
setlocal
for /f "tokens=2" %%i in ("%date:/=_%") do set vdate=%%i
for /f "tokens=1,2 delims=:" %%i in ("%time: =%") do set vdate=%vdate%_%%i%%j
c:\oracle\product\10.2.0\db_1\bin\exp.exe userid=scott/tiger@orcl file=e:\syr%vdate%.dmp owner=scott
endlocal
echo on

When executed:

c:\> test.bat
c:\oracle\product\10.2.0\db_1\bin\exp.exe userid=scott/tiger@orcl
 file=e:\syr07_19_2006_803.dmp owner=scott

Report message to a moderator

Previous Topic:	error found: calling report from form
Next Topic:	How to check uniqness of a field in forms 6i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 10:35:19 CDT 2024