Home » RDBMS Server » Server Utilities » how to add date/time in export dump file in Linux (Rhel 6.4)
how to add date/time in export dump file in Linux [message #589874] Thu, 11 July 2013 10:26 Go to next message
bvo65
Messages: 3
Registered: November 2009
Location: US
Junior Member
Hello,

I want to know how to add date/time in export dump file in Linux using parfile script. I keep getting an error "contain an invalid substitution variables"

my parfile is:
Dumpfile = Daily_Full_%U_`date "+%Y%m%d%H%S"`.dmp or
Dumpfile = Daily_Full_%U_`%date%`.dmp

thanks,BVo

[Updated on: Fri, 12 July 2013 07:57] by Moderator

Report message to a moderator

Re: how to add date/time in export dump file in Linux [message #589877 is a reply to message #589874] Thu, 11 July 2013 10:29 Go to previous message
ThomasG
Messages: 3064
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Well, the parfile is not a "script" that is executed, it's a static parameter file.

So the usual way would be to use a script to first write the (temporary) parfile, and then call the export with the script-created parfile.
Previous Topic: Location of SQL*Loader required
Next Topic: ORA-02374: conversion error loading table (through Data-pump)
Goto Forum:
  


Current Time: Mon Apr 21 10:16:51 CDT 2014

Total time taken to generate the page: 0.16924 seconds