Puts a new file specification into the database root (.rdb) file
for a storage area (.rda) or snapshot (.snp) file.
1 – Format
(B)0[mqwqqqqqq>qqqqqwq> [4mFILE[m qwq> area-id qqqwqwqqqqqqq>qqqqqwqk mq> [4mDEPOSIT[m qj mq> area-name qj mq> [4mSNAPSHOT[m qj x lqqqqqqqqqqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqqqqqqqj mqq> [4mSPECIFICATION[m = file-spec qq>
2 – Arguments
2.1 – area-id
Specifies the number of the .rda or .snp file whose file
specification you are changing in the .rdb file.
2.2 – area-name
Specifies the name of the .rda or .snp file whose file
specification you are changing in the .rdb file.
2.3 – SNAPSHOT
Specifies that the file whose .rdb file fields you are changing
is an .snp file.
2.4 – SPECIFICATION
SPECIFICATION = file-spec
Specifies the file specification that the .rda or .snp file will
have. Use a full file specification (including version number) if
the .rda or .snp file is not in your default directory. The file
must be in the location you specify, otherwise the DEPOSIT FILE
command fails.
3 – Examples
Example 1
The following example deposits a new file specification for the
JOBS storage area file. The word (marked) in the DEPOSIT FILE
display indicates that the JOBS storage area file is marked for
the specified location.
RdbALTER> DISPLAY FILE JOBS
Area JOBS:
File specification is: "DISK1:[RICK.RDB]JOBS.RDA;1"
Corrupt flag is: OFF
Inconsistent flag is: OFF
RdbALTER> DEPOSIT FILE JOBS SPECIFICATION=DISK1:[RICK]JOBS.RDA;1
Area JOBS:
(marked) File specification is: "DISK1:[RICK]JOBS.RDA;1"
See the Oracle Rdb Guide to Database Maintenance for more
examples of how to use the DEPOSIT FILE command.