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