Table Space Create

-- Maximum Size Fixed
CREATE TABLESPACE Name DATAFILE
  'D:\ORADATA\MICR\MICR01.DBF' SIZE 512M AUTOEXTEND ON NEXT 512M MAXSIZE 3072M
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT MANUAL
FLASHBACK ON;

--Maximum Size Unlimeted

CREATE TABLESPACE Name DATAFILE
  'E:\ORADATA\BEFTN\BEFTNALL01.DBF' SIZE 1024M AUTOEXTEND ON NEXT 512M MAXSIZE UNLIMITED
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON;