1 réponse
- Le plus récent
- Le plus de votes
- La plupart des commentaires
2
Delete files in DATA_PUMP_DIR that you no longer require, use the following command.
EXEC UTL_FILE.FREMOVE('DATA_PUMP_DIR','filename');
To delete all files in DATA_PUMP_DIR, you could you something below..
begin for i in (select filename from table(RDSADMIN.RDS_FILE_UTIL.LISTDIR('MY_DIR')) where type='file') loop UTL_FILE.FREMOVE ('DATA_PUMP_DIR', i.filename); end loop; end; /
Please test the script/procedure in non-production before moving on to production and acknowledge the answer.
répondu il y a un an
Contenus pertinents
- demandé il y a 4 mois
- demandé il y a un an
- demandé il y a 2 mois
- AWS OFFICIELA mis à jour il y a 3 ans
- AWS OFFICIELA mis à jour il y a 3 ans
- AWS OFFICIELA mis à jour il y a un an
Its working , Thank you