Ora Tbs
Create TBS
CREATE TABLESPACE &TBS_NAME DATAFILE '&fname1' SIZE &gb1G AUTOEXTEND OFF, '&fname2' SIZE &gb2G AUTOEXTEND OFF LOGGING ONLINE EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M BLOCKSIZE 8K SEGMENT SPACE MANAGEMENT MANUAL FLASHBACK ON;
Drop TBS
DROP TABLESPACE &TBS_NAME INCLUDING CONTENTS AND DATAFILES;
page revision: 0, last edited: 22 Dec 2017 09:16