$LOGFILE = "backup_log" + $date_time_log + ".log"ĮXPDP $export_mode exclude=statistics exclude=$exclude DIRECTORY=$DIRECTORY DUMPFILE=$DUMPFILE LOGFILE=$LOGFILE reuse_dumpfiles=$reuse_dumpfilesįor example output E:\upwork\stackoverflow\expdp_powershell>powershell. $DUMPFILE = "backup" + $date_time_log + ".dmp" $date_time_log = Get-Date -Format "yyyyMMddHHmmss" Or E:\upwork\stackoverflow\expdp_powershell>powershell. expdp_powershell.ps1 -user_name system -user_password manager -connect_string test -exclude table:\"LIKE\'%_80\'\"
You can try this script expdp_powershell.ps1įor example E:\upwork\stackoverflow\expdp_powershell>powershell.
#ORACLE EXPORT PARAMETER FILE TABLE LIST HOW TO#
** EXPDP FULL=Y exclude=statistics exclude=table:\"LIKE\'%_80\'\" DUMPFILE=%bckupdate%.dmp LOGFILE=%bckupdate%.log reuse_dumpfiles=yesĪny helpful hints on how to either use a variable name (as in %DBNAME%) in the PAR file or proper formatting for the batch file would be appreciated. LRM-00111: no closing quote for value 'table:"LIK' I can run this at the command prompt without issue, but if I call it via a batch I get an error PAR files does not seem to like any VARIABLE names defined in the batch files. This produces a series of log and archive files important in the larger scheme of things. This EXPDP is launched via a scheduled task and calls a series of batch files that have defined variables that are passed from batch file to batch file. I'd like to eliminate them from the daily EXPDP as they have been archived offline. Recently we placed 2 tables in it with over 4 million records that will remain static. I need to do a full export of a 12.2 database.
0 kommentar(er)
