|Oracle® OLAP DML Reference
10g Release 1 (10.1)
Part Number B10339-02
FILEMOVE old-file-name new-file-name
A text expression specifying the name of the file you want to move or rename. Unless the file is in the current directory, you must include the name of the directory object in the name of the file.
Note:Directory objects are defined in the database, and they control access to directories and file in those directories. You can use the CDA command to identify and specify a current directory object. Contact your Oracle DBA for access rights to a directory object where your database user name can read and write files.
A text expression specifying the new name or location for the file. Unless the file is in the current directory, you must include the name of the directory object in the name of the file.
The following statement moves the file
log.txt from your session's current directory object to file
oldlog.txt in a directory object called
FILECOPY 'log.txt' 'backup/oldlog.txt'