|
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;
|
