OraFAQ Forum: Server Utilities » export command in oracle11g

Home » RDBMS Server » Server Utilities » export command in oracle11g (oracle 11g)

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

export command in oracle11g [message #684385]

Sun, 23 May 2021 07:10

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

Report message to a moderator

Re: export command in oracle11g [message #684386 is a reply to message #684385]

Sun, 23 May 2021 07:54

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

Re: export command in oracle11g [message #684387 is a reply to message #684385]

Sun, 23 May 2021 08:35

John Watson
Messages: 8966
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>

Report message to a moderator

Re: export command in oracle11g [message #684393 is a reply to message #684385]

Sun, 23 May 2021 19:10

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 03 11:29:44 CST 2025