FILESPEC Clause

Specify a number of bytes, kilobytes (K), megabytes (M), gigabytes (G), terabytes (T), petabytes (P), or exabytes (E) in any statement that allocates amounts of disk or memory space.

Syntax:

   'filename' [size] [REUSE]
   'filename' [size] K [REUSE]
   'filename' [size] M [REUSE]
   'filename' [size] G [REUSE]
   'filename' [size] T [REUSE]
   'filename' [size] P [REUSE]
   'filename' [size] E [REUSE]

When creating Datafiles or Redo log file groups - the filename can be several filenames separated with commas.

e.g. ('file1' 500 M, 'file2' 10 G)

REUSE will reuse an existing file, or if the filename does not already exist, will create a new one.

Related Oracle Commands:

ALTER DATABASE

Related Views:

DBA_DATA_FILES
FILEXT$
SYSFILES


 
Copyright © 1999-2020 SS64.com
Some rights reserved