CREATE BIGFILE TABLESPACE OMP_DB DATAFILE '&1\omp_db.dbf' SIZE 10240M AUTOEXTEND OFF LOGGING EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO FLASHBACK ON; CREATE BIGFILE TABLESPACE OMP_IND DATAFILE '&1\omp_ind.dbf' SIZE 10240M AUTOEXTEND OFF LOGGING EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO FLASHBACK ON; --select '&1' from dual; --select name from v$datafile; exit;