Create undo tablespace:
|
create undo
tablespace undotbs2 datafile
'/u01/app/oracle/oradata/ORCL/datafile/undotbs2.dbf' size 100M autoextend on
next 10M;
|
Create tablespace:
|
create tablespace
BOC datafile '/u01/app/oracle/oradata/ORCL/datafile/BOC.dbf' size 100M
autoextend on next 10M;
|
Create temporary tablespace:
|
CREATE TEMPORARY TABLESPACE
TEMP1 TEMPFILE '/u01/app/oracle/oradata/ORCL/datafile/temp.dbf' SIZE 2000M;
|
0 Comment to "Example Creating tablespace in Oracle Database."
Post a Comment