📋Steps in this guide1/1

Create tablespace in oracle db

-- Create New tablespace

oracle configurationintermediate

by OracleDba

12 views

Create tablespace in oracle db

Code/Command (click line numbers to comment):

-- Create New tablespace
Create tablespace DATA datafile '/u01/dbaclass/oradata/data01.dbf' size 5G autoextend on next 500M;
-- Create tablespace on ASM diskgroup
Create tablespace DATA datafile '+DATAG' size 5G autoextend on next 500M;
-- Create big tablespace:
CREATE BIGFILE TABLESPACE BIGTS datafile '/u01/dbaclass/oradata/bigts01.dbf' size 100G autoextend on NEXT 1G;

Comments (0)

Please to add comments

No comments yet. Be the first to comment!