Home » RDBMS Server » Server Utilities » export command in oracle11g (oracle 11g)
export command in oracle11g [message #684385] Sun, 23 May 2021 07:10 Go to next message
knd.prasad
Messages: 35
Registered: December 2009
Location: HYDERABAD
Member

Hi

exp system/manager file= file_na.dmp log=emp_exp.log full=y direct=y STATISTICS=none


I want to set the file= date.dmp (example : file =23052021_0539pm.dmp)


Thanks
Re: export command in oracle11g [message #684386 is a reply to message #684385] Sun, 23 May 2021 07:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

It depends on your OS type and version.
Basically use %DATE%/%TIME% variables on Windows or `date` command on Linux/*nix in the file name.

Re: export command in oracle11g [message #684387 is a reply to message #684385] Sun, 23 May 2021 08:35 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
This is a Windows example I use sometimes, though whether it works for you is dependent on your OS localization:
C:\Users\john>
C:\Users\john>set file_name=%date:~6,4%-%date:~3,2%-%date:~0,2%-%time:~0,2%%time:~3,2%%time:~6,2%.dmp

C:\Users\john>echo %file_name%
2021-05-23-143431.dmp

C:\Users\john>
Re: export command in oracle11g [message #684393 is a reply to message #684385] Sun, 23 May 2021 19:10 Go to previous message
dwatkins
Messages: 6
Registered: June 2011
Location: Australia
Junior Member
Under linux, I use something like this:

$ exp user/pass file=$(date +'%Y%m%d_%H%M').dmp log=exp_$(date +'%Y%m%d_%H%M').log full=y direct=y

cheers,

[Updated on: Sun, 23 May 2021 19:12]

Report message to a moderator

Previous Topic: Taking backup of your own Schema without DBA provs
Next Topic: Issue with sqlldr
Goto Forum:
  


Current Time: Thu Mar 28 03:47:23 CDT 2024