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;
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License