FILESPEC Clause

Specify a data file

Syntax:

   'filename' [size] [REUSE]
   'filename' [size] K [REUSE]
   'filename' [size] M [REUSE]

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

e.g. ('file1' 200 M, 'file2' 300 M)

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