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 may 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 Commands:

ALTER DATABASE

Related Views:

DBA_DATA_FILES
FILEXT$
SYSFILES


© Copyright SS64.com 1999-2014
Some rights reserved